Hi Konstantin,
Thanks for your support, i tried your methodology and it works perfectly. i have some problem now.
when my page initially load it will call Evaluation_Read method because it have kendo grid. and when i try to add new row for the grid while click add new button on grid toolbar click i getting error "Uncaught ReferenceError: Attachmentslist is not defined" i also attached my coding please help me to find this out.
index.cshtml:-
@(Html.Kendo().Grid<EmployeeSelfService.Models.EvaluationViewModel>()
.Name("DetailGrid")
.Events(e => e.Edit("onEdit"))
.Columns(columns =>
{
columns.Bound(p => p.RequestDtlNum).Title("Seq No").Width(110).Hidden(true);
columns.Bound(p => p.RequestID).Hidden(true);
columns.Bound(p => p.Company).Hidden(true);
columns.Bound(p => p.CandidateID).Title("Candidate ID").Width(165);
columns.Bound(p => p.CandidateName).Title("Name").Width(165);
columns.Bound(p => p.ResumeStatus).Width(165).Title("Resume Status").EditorTemplateName("ResumeStatusTemplate");
columns.Bound(p => p.InterviewDate).Format("{0:dd/MM/yyyy}").Width(165).Title("Interview Date").EditorTemplateName("InterviewDateTemplate");
columns.Bound(p => p.InterviewType).Width(165).Title("Interview Type").EditorTemplateName("InterviewTypeTemplate");
columns.Bound(p => p.InterviewStatus).Width(165).EditorTemplateName("InterviewStatusTemplate");
columns.Bound(p => p.Comments).Width(150);
columns.Bound(p => p.Attachments).EditorTemplateName("EvaluationUploadTemplate").Width(150);
//if(Model.Attachmentslist != null)
//{
columns.Bound(p => p.Attachmentslist).Title("Uploaded Files").Width(165).ClientTemplate("#=MyUploadTemplate(Attachmentslist)#");
//columns.Bound(p => p.Attachmentslist).Title("Uploaded Files").Width(165).ClientTemplate("<a href='Evaluation/Download?id=#=getID(Attachmentslist)#'>#=getName(Attachmentslist)#</a>");
//}
columns.Command(command => command.Destroy().Text(" ")).HtmlAttributes(new { @style ="color:white;"}).Width(80).Title("Action");
})
.ToolBar(toolbar =>
{
toolbar.Create();
toolbar.Save();
})
script:-
<script type="text/javascript">
function MyUploadTemplate(list) {
console.log("S");
var result = "";
var str = "";
var name = new Array();
var tt = [];
for (var i = 0; i < list.length; i++) {
str = list[i];
name = str.split("~");
var obj = {
'id': name[0],
'val': name[1],
}
tt.push(obj);
}
for (var j = 0; j < tt.length; j++)
{
var id = tt[j].id;
var val = tt[j].val;
console.log(id);
console.log(val);
result += "<a href='Evaluation/Download?id="+id+"'>"+val+"</a><br>"
}
return result;
}
Evaluation Controller :-
[AcceptVerbs(HttpVerbs.Post)]
public ActionResult Evaluation_Read([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")]IEnumerable<EmployeeSelfService.Models.EvaluationViewModel> products, string requestID)
{
var results = new List<EmployeeSelfService.Models.EvaluationViewModel>();
System.Linq.IQueryable<EmployeeBusinessLogic.PayResourceEvaluationCandidateDtl> resourcecandidate = null;
resourcecandidate = Db.PayResourceEvaluationCandidateDtl.Where(H => H.Company == cookie.CompanyID && H.RequestID == requestID);
if (resourcecandidate != null)
{
products = resourcecandidate.AsEnumerable().Select(L => new Models.EvaluationViewModel
{
RequestID = L.RequestID,
RequestDtlNum = L.RequestDtlNum,
Company = L.Company,
CandidateID = L.CandidateID,
CandidateName = L.CandidateName,
ResumeStatus = L.ResumeStatus,
InterviewDate = L.InterviewDate,
InterviewType = L.InterviewType,
Comments = L.Comments,
InterviewStatus = L.InterviewStatus,
Attachmentslist = getAttachments(L.Company, L.RequestID) ?? null,
}).ToList();
}
if (products != null && ModelState.IsValid)
{
foreach (var product in products)
{
results.Add(product);
}
}
return Json(results.ToDataSourceResult(request, ModelState));
}
[NonAction]
private List<string> getAttachments( string Company, string requestID)
{
requestID = "10000/17/12/2017/1";
var attachmentList = new List<string>();
try
{
var epicorAttach = (from XR in Db.XFileRef
join XA in Db.XFileAttch on new { Company = XR.Company, XFileRefNum = XR.XFileRefNum } equals new { Company = XA.Company, XFileRefNum = XA.XFileRefNum }
where (XA.Company == Company && XR.Company == Company && XA.RelatedToFile.ToUpper() == "PayHROtherRequests"/*"PayResourceEvaluation"*/ && XA.RelatedToSchemaName.ToUpper() == "ERP" && XA.Key1 == requestID)
select XR);
if (epicorAttach != null)
{
foreach (var item in epicorAttach)
{
string[] XfileName = item.XFileName.Split('\\');
string attachXFile = XfileName.Last().ToString();
foreach(var list in (AppDb.Attachments.Where(A => A.Company == Company && A.Key1 == requestID && A.RelatedToProcess.ToUpper() == "Other"/*"Evaluation"*/ && A.FileName.Contains(attachXFile) && A.ActualName.Contains(item.XFileDesc))))
{
attachmentList.Add(list.Id + "~" + list.ActualName);
}
}
}
}
catch (Exception e)
{
Utilities.PrintErrorLine(ConfigurationManager.AppSettings["ErrorLogPath"].ToString(), string.Format("{0}~{1}~{2}~{3}", "MVC", "Evaluation controller", "getAttachments", e.ToString()));
}
return attachmentList;
}