//
// GET: /CostUpdation/
public ActionResult CostUpdation(int id)
{
costUpdationVM Cost = new costUpdationVM();
if (Session["UserID"] != null)
{
if (id > 0)
{
Cost = CU.GetCostupdationbyCostUpID(id);
// Cost.InvoiceDate = System.DateTime.UtcNow;
//BindMasters();
Cost.CostUpdationDetails = DAL.GetCostUpdationDetailsbyCostUpdationID(id);
foreach (var item in Cost.CostUpdationDetails)
{
string currency = (from c in entity.CurrencyMasters where c.CurrencyID == item.ProvisionCurrencyID select c.CurrencyName).FirstOrDefault();
string revenuename = (from r in entity.RevenueTypes where r.RevenueTypeID == item.RevenueTypeID select r.RevenueType1).FirstOrDefault();
// item.RevenueTypeName = revenuename;
// item.CurrencyName = currency;
}
BindMasters_ForEdit(Cost);
}
else
{
Cost.CostUpdationDetails = new List <costUpdationDetailVM>();
BindMasters();
}
}
else
{
return(RedirectToAction("Login", "Login"));
}
return(View(Cost));
}
public void BindMasters_ForEdit(costUpdationVM costupdation)
{
List <SP_GetJobCodesForCostUpdation_Result> JobCodes = new List <SP_GetJobCodesForCostUpdation_Result>();
JobCodes = CU.GetJobCodes();
List <SP_GetAllEmployees_Result> Employees = new List <SP_GetAllEmployees_Result>();
Employees = MM.GetAllEmployees();
ViewBag.DocumentNos = costupdation.DocumentNo;
ViewBag.AllJobCodes = new SelectList(JobCodes, "JobID", "JobCode", costupdation.JobID);
// ViewBag.Suppliers = new SelectList(new[] { new { SupplierID = "0", SupplierName = "Select" } }, "SupplierID", "SupplierName");
ViewBag.Employes = new SelectList(Employees, "EmployeeID", "EmployeeName", costupdation.EmployeeID);
}
public ActionResult CostUpdation(costUpdationVM CostU, string Command)
{
BindMasters();
int costupdationId = 0;
if (Session["UserID"] != null)
{
CostU.UserID = Convert.ToInt32(Session["UserID"]);
CostU.SupplierPaymentStatus = "1";
CostU.SupplierID = CostU.SelectedSupplierID;
CostU.JobID = 0;
// CostU.SupplierID = Convert.ToInt32(Suppliers);
/* if (CostU.JobID == null)
* {
*
* CostU.InvoiceNo = CU.GetInvoiceNoByJobID(Convert.ToInt32(CostU.MultiJobID.First()));
* CostU.JobID = CostU.MultiJobID.First();
* }
* else
* {
* CostU.InvoiceNo = CU.GetInvoiceNoByJobID(Convert.ToInt32(CostU.JobID));
* }*/
costupdationId = CU.SaveCostUpdation(CostU);
if (costupdationId > 0)
{
int n = 0;
foreach (var item in CostU.CostUpdationDetails)
{
////////////////////////////////////
CU.SaveCostUpdationDetails(item, costupdationId);
//todo:fix to run by sethu
// int jid = (from c in entity.CostUpdations where c.CostUpdationID == item select c.CostUpdationID).FirstOrDefault();
//todo:fix to run by sethu
// var d = CostU.CostUpdationDetails.Where(x => x.CostUpdationID == jid).ToList();
// if (d.Count==0)
// {
// var query1 = (from t in CostU.CostUpdationDetails where t.CostUpdationID == item select t).ToList();
// foreach (var j in query1)
// {
// CU.SaveCostUpdationDetails(CostU.CostUpdationDetails[n], jid);
// }
// CU.SaveCostUpdationDetails(query1, item);
// // CU.saveAcJournalDetails(item, Convert.ToInt32(Session["fyearid"]));
// }
// else
// {
// foreach (var i in d)
// {
//var data = (from t in entity.CostUpdations where t.CostUpdationID == item select t.JobID).FirstOrDefault();
//var query = (from context in CostU.CostUpdationDetails where context.JobID == data select context).FirstOrDefault();
//if (query == null)
//{
// var query1 = (from t in CostU.CostUpdationDetails where t.CostUpdationID == item select t).FirstOrDefault();
// CU.SaveCostUpdationDetails(query1, item);
// // CU.saveAcJournalDetails(item, Convert.ToInt32(Session["fyearid"]));
//}
//else
//{
// CU.SaveCostUpdationDetails(query, item);
// CU.saveAcJournalDetails(item, Convert.ToInt32(Session["fyearid"]));
//}
// }
// }
//var data=(from t in entity.CostUpdations where t.CostUpdationID==item select t.JobID).FirstOrDefault();
//var query=(from context in CostU.CostUpdationDetails where context.JobID==data select context).FirstOrDefault();
//if (query == null)
//{
// var query1 = (from t in CostU.CostUpdationDetails where t.CostUpdationID == item select t).FirstOrDefault();
// CU.SaveCostUpdationDetails(query1, item);
// // CU.saveAcJournalDetails(item, Convert.ToInt32(Session["fyearid"]));
//}
//else
//{
// CU.SaveCostUpdationDetails(query, item);
// CU.saveAcJournalDetails(item, Convert.ToInt32(Session["fyearid"]));
//}
n = n + 1;
}
CU.saveAcJournalDetails(costupdationId, Convert.ToInt32(Session["fyearid"]));
}
}
else
{
return(RedirectToAction("Login", "Login"));
}
return(RedirectToAction("CostUpdationDetails", "CostUpdation", new { ID = 15 }));
}
