public vmPrdWeavingMachineConfigMasterDetail GetMaintenanceMachineData(vmCmnParameters objcmnParam)
{
vmPrdWeavingMachineConfigMasterDetail objMMOMachineData = null;
try
{
using (_ctxCmn = new ERP_Entities())
{
objMMOMachineData = (from IM in _ctxCmn.MntMachineMaintenanceOrders.Where(x => x.CompanyID == objcmnParam.loggedCompany && x.IsDeleted == false && x.MaintenanceID == objcmnParam.id)
join MC in _ctxCmn.PrdWeavingMachinConfigs on IM.MachineConfigID equals MC.MachineConfigID
join CO in _ctxCmn.CmnOrganograms on IM.DepartmentID equals CO.OrganogramID
select new
{
MachineConfigID = IM.MachineConfigID,
MachineConfigNo = MC.MachineConfigNo,
DepartmentID = IM.DepartmentID,
OrganogramName = CO.OrganogramName
}).ToList().Select(x => new vmPrdWeavingMachineConfigMasterDetail
{
MachineConfigID = x.MachineConfigID,
MachineConfigNo = x.MachineConfigNo,
DepartmentID = x.DepartmentID,
OrganogramName = x.OrganogramName
}).FirstOrDefault();
}
}
catch (Exception e)
{
e.ToString();
}
return(objMMOMachineData);
}
public HttpResponseMessage SaveUpdateMachineMaintenanceOrder(object[] data)
{
string result = string.Empty;
vmPrdWeavingMachineConfigMasterDetail model = JsonConvert.DeserializeObject <vmPrdWeavingMachineConfigMasterDetail>(data[0].ToString());
vmCmnParameters objcmnParam = JsonConvert.DeserializeObject <vmCmnParameters>(data[1].ToString());
try
{
result = objMMOEntryService.SaveUpdateMachineMaintenanceOrder(model, objcmnParam);
}
catch (Exception e)
{
e.ToString();
result = "";
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public string SaveUpdateMachineMaintenanceRelease(vmPrdWeavingMachineConfigMasterDetail model, vmCmnParameters objcmnParam)
{
string result = string.Empty;
using (TransactionScope transaction = new TransactionScope())
{
GenericFactory_MntMachineMaintenanceOrder_EF = new MntMachineMaintenanceOrder_EF();
GenericFactory_WeavingMachinConfig_EF = new PrdWeavingMachinConfig_EF();
var umodel = new MntMachineMaintenanceOrder();
var uConfig = new PrdWeavingMachinConfig();
try
{
umodel = GenericFactory_MntMachineMaintenanceOrder_EF.GetAll().Where(x => x.MaintenanceID == model.MaintenanceID).FirstOrDefault();
umodel.IsReleased = true;
umodel.IsMaintenance = false;
umodel.MaintenanceEmployeeID = objcmnParam.loggeduser;
umodel.ReleaseRemarks = model.ReleaseRemarks;
umodel.ReleaseDate = model.ReleaseDate;
uConfig = GenericFactory_WeavingMachinConfig_EF.GetAll().Where(x => x.MachineConfigID == model.MachineConfigID).FirstOrDefault();
uConfig.IsMaintenance = false;
if (umodel != null)
{
GenericFactory_MntMachineMaintenanceOrder_EF.Update(umodel);
GenericFactory_MntMachineMaintenanceOrder_EF.Save();
}
if (uConfig != null)
{
GenericFactory_WeavingMachinConfig_EF.Update(uConfig);
GenericFactory_WeavingMachinConfig_EF.Save();
}
transaction.Complete();
result = umodel.MaintenanceNo;
}
catch (Exception e)
{
e.ToString();
result = "";
}
}
return(result);
}
public IHttpActionResult GetMaintenanceMachineData(object[] data)
{
vmPrdWeavingMachineConfigMasterDetail MData = null;
vmCmnParameters objcmnParam = JsonConvert.DeserializeObject <vmCmnParameters>(data[0].ToString());
try
{
MData = objMMREntryService.GetMaintenanceMachineData(objcmnParam);
}
catch (Exception e)
{
e.ToString();
}
return(Json(new
{
MData
}));
//return objDOMaster.ToList();
}
public HttpResponseMessage SaveUpdateWeavingMasterDetail(object[] data)
{
vmPrdWeavingMachineConfigMasterDetail itemMaster = JsonConvert.DeserializeObject <vmPrdWeavingMachineConfigMasterDetail>(data[0].ToString());
List <vmPrdWeavingMachineConfigMasterDetail> itemDetails = JsonConvert.DeserializeObject <List <vmPrdWeavingMachineConfigMasterDetail> >(data[1].ToString());
vmCmnParameters objcmnParam = JsonConvert.DeserializeObject <vmCmnParameters>(data[2].ToString());
string result = "";
try
{
if (ModelState.IsValid && itemMaster != null && itemDetails.Count > 0)
{
result = objweavingservice.SaveUpdateWeavingMasterDetail(itemMaster, itemDetails, objcmnParam);
}
}
catch (Exception e)
{
e.ToString();
result = "";
}
// System.Web.HttpContext.Current.Session.Add("LCReferenceNo", result);
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public string SaveUpdateWeavingMasterDetail(vmPrdWeavingMachineConfigMasterDetail Master, List <vmPrdWeavingMachineConfigMasterDetail> Detail, vmCmnParameters objcmnParam)
{
string result = string.Empty;
using (var transaction = new TransactionScope())
{
//*********************************************Start Initialize Variable*****************************************
long MasterId = 0, DetailId = 0, FirstDigit = 0, OtherDigits = 0;
//***************************************End Initialize Variable*************************************************
//**************************Start Initialize Generic Repository Based on table***********************************
GenericFactory_PrdWeavingMachinConfig_EF = new PrdWeavingMachinConfig_EF();
GenericFactory_PrdWeavingMachineConfigDetail_EF = new PrdWeavingMachineConfigDetail_EF();
//****************************End Initialize Generic Repository Based on table***********************************
//**********************************Start Create Related Table Instance to Save**********************************
var MasterItem = new PrdWeavingMachinConfig();
var DetailItem = new List <PrdWeavingMachineConfigDetail>();
var DetailItems = new List <PrdWeavingMachineConfigDetail>();
//************************************End Create Related Table Instance to Save**********************************
//*************************************Start Create Model Instance to get Data***********************************
vmPrdWeavingMachineConfigMasterDetail item = new vmPrdWeavingMachineConfigMasterDetail();
vmPrdWeavingMachineConfigMasterDetail items = new vmPrdWeavingMachineConfigMasterDetail();
PrdWeavingMachineConfigDetail itemdel = new PrdWeavingMachineConfigDetail();
//***************************************End Create Model Instance to get Data***********************************
var SDetail = Detail.Where(x => x.MachineConfigDetailID == 0).ToList();
var UDetail = Detail.Where(x => x.MachineConfigDetailID != 0).ToList();
//**************************************************Start Main Operation************************************************
if (Detail.Count > 0)
{
try
{
if (Master.MachineConfigID == 0)
{
//***************************************************Start Save Operation************************************************
//**********************************************Start Generate Master & Detail ID****************************************
MasterId = Convert.ToInt16(GenericFactory_PrdWeavingMachinConfig_EF.getMaxID("PrdWeavingMachinConfig"));
DetailId = Convert.ToInt64(GenericFactory_PrdWeavingMachineConfigDetail_EF.getMaxID("PrdWeavingMachineConfigDetail"));
FirstDigit = Convert.ToInt64(DetailId.ToString().Substring(0, 1));
OtherDigits = Convert.ToInt64(DetailId.ToString().Substring(1, DetailId.ToString().Length - 1));
//***********************************************End Generate Master & Detail ID*****************************************
MasterItem = new PrdWeavingMachinConfig
{
MachineConfigID = (int)MasterId,
MachineConfigNo = Master.MachineConfigNo,
Remarks = Master.Remarks,
DepartmentID = Master.DepartmentID,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false,
IsBook = false,
IsCorrupted = false,
IsMaintenance = false
};
for (int i = 0; i < Detail.Count; i++)
{
item = Detail[i];
var Detailitem = new PrdWeavingMachineConfigDetail
{
MachineConfigDetailID = Convert.ToInt32(FirstDigit + "" + OtherDigits),
MachineConfigID = (int)MasterId,
MachineID = (long)item.MachineID,
Description = item.Description,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false
};
DetailItem.Add(Detailitem);
OtherDigits++;
}
//***************************************************End Save Operation************************************************
}
else
{
//***********************************Start Get Data From Related Table to Update*********************************
var MasterAll = GenericFactory_PrdWeavingMachinConfig_EF.GetAll().Where(x => x.MachineConfigID == Master.MachineConfigID && x.CompanyID == objcmnParam.loggedCompany);
var DetailAll = GenericFactory_PrdWeavingMachineConfigDetail_EF.GetAll().Where(x => x.MachineConfigID == Master.MachineConfigID && x.CompanyID == objcmnParam.loggedCompany).ToArray();
//*************************************End Get Data From Related Table to Update*********************************
//***************************************************Start Update Operation********************************************
MasterItem = MasterAll.First(x => x.MachineConfigID == Master.MachineConfigID);
MasterItem.MachineConfigNo = Master.MachineConfigNo;
MasterItem.DepartmentID = Master.DepartmentID;
MasterItem.Remarks = Master.Remarks;
MasterItem.CompanyID = objcmnParam.loggedCompany;
MasterItem.UpdateBy = objcmnParam.loggeduser;
MasterItem.UpdateOn = DateTime.Now;
MasterItem.UpdatePc = HostService.GetIP();
MasterItem.IsDeleted = false;
for (int i = 0; i < UDetail.Count; i++)
{
item = UDetail[i];
foreach (PrdWeavingMachineConfigDetail d in DetailAll.Where(d => d.MachineConfigID == Master.MachineConfigID && d.MachineConfigDetailID == item.MachineConfigDetailID))
{
d.MachineID = (long)item.MachineID;
d.Description = item.Description;
d.CompanyID = objcmnParam.loggedCompany;
d.UpdateBy = objcmnParam.loggeduser;
d.UpdateOn = DateTime.Now;
d.UpdatePc = HostService.GetIP();
d.IsDeleted = false;
DetailItem.Add(d);
break;
}
}
if (SDetail != null && SDetail.Count != 0)
{
for (int i = 0; i < SDetail.Count; i++)
{
item = SDetail[i];
DetailId = Convert.ToInt64(GenericFactory_PrdWeavingMachineConfigDetail_EF.getMaxID("PrdWeavingMachineConfigDetail"));
FirstDigit = Convert.ToInt64(DetailId.ToString().Substring(0, 1));
OtherDigits = Convert.ToInt64(DetailId.ToString().Substring(1, DetailId.ToString().Length - 1));
var Detailitems = new PrdWeavingMachineConfigDetail
{
MachineConfigDetailID = Convert.ToInt32(FirstDigit + "" + OtherDigits),
MachineConfigID = (long)Master.MachineConfigID,
MachineID = (long)item.MachineID,
Description = item.Description,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false
};
DetailItems.Add(Detailitems);
GenericFactory_PrdWeavingMachineConfigDetail_EF.updateMaxID("PrdWeavingMachineConfigDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits)));
}
}
if (UDetail.Count < DetailAll.Count())
{
for (int i = 0; i < DetailAll.Count(); i++)
{
itemdel = DetailAll[i];
var delDetail = (from del in DetailItem.Where(x => x.MachineConfigDetailID == itemdel.MachineConfigDetailID) select del.MachineConfigDetailID).FirstOrDefault();
if (delDetail != itemdel.MachineConfigDetailID)
{
var tem = DetailAll.FirstOrDefault(d => d.MachineConfigID == Master.MachineConfigID && d.MachineConfigDetailID == itemdel.MachineConfigDetailID);
tem.CompanyID = objcmnParam.loggedCompany;
tem.DeleteBy = objcmnParam.loggeduser;
tem.DeleteOn = DateTime.Now;
tem.DeletePc = HostService.GetIP();
tem.IsDeleted = true;
DetailItem.Add(tem);
}
}
}
//***************************************************End Update Operation********************************************
}
if (Master.MachineConfigID > 0)
{
//***************************************************Start Update************************************************
if (MasterItem != null)
{
GenericFactory_PrdWeavingMachinConfig_EF.Update(MasterItem);
GenericFactory_PrdWeavingMachinConfig_EF.Save();
}
if (DetailItem != null && DetailItem.Count != 0)
{
GenericFactory_PrdWeavingMachineConfigDetail_EF.UpdateList(DetailItem.ToList());
GenericFactory_PrdWeavingMachineConfigDetail_EF.Save();
}
if (DetailItems != null && DetailItems.Count != 0)
{
GenericFactory_PrdWeavingMachineConfigDetail_EF.InsertList(DetailItems.ToList());
GenericFactory_PrdWeavingMachineConfigDetail_EF.Save();
}
//***************************************************End Update************************************************
}
else
{
//***************************************************Start Save************************************************
if (MasterItem != null)
{
GenericFactory_PrdWeavingMachinConfig_EF.Insert(MasterItem);
GenericFactory_PrdWeavingMachinConfig_EF.Save();
GenericFactory_PrdWeavingMachinConfig_EF.updateMaxID("PrdWeavingMachinConfig", Convert.ToInt64(MasterId));
}
if (DetailItem != null && DetailItem.Count != 0)
{
GenericFactory_PrdWeavingMachineConfigDetail_EF.InsertList(DetailItem.ToList());
GenericFactory_PrdWeavingMachineConfigDetail_EF.Save();
GenericFactory_PrdWeavingMachineConfigDetail_EF.updateMaxID("PrdWeavingMachineConfigDetail", Convert.ToInt64(FirstDigit + "" + (OtherDigits - 1)));
}
//******************************************************End Save************************************************
}
transaction.Complete();
result = MasterItem.MachineConfigNo;
}
catch (Exception e)
{
result = "";
e.ToString();
}
}
else
{
result = "";
}
}
return(result);
//**************************************************End Main Operation************************************************
}
public string SaveUpdateMachineMaintenanceOrder(vmPrdWeavingMachineConfigMasterDetail model, vmCmnParameters objcmnParam)
{
string result = string.Empty;
using (TransactionScope transaction = new TransactionScope())
{
GenericFactory_MntMachineMaintenanceOrder_EF = new MntMachineMaintenanceOrder_EF();
GenericFactory_WeavingMachinConfig_EF = new PrdWeavingMachinConfig_EF();
long MainId = 0; string CustomNo = string.Empty, MaintenanceNo = string.Empty;
var umodel = new MntMachineMaintenanceOrder();
var uConfig = new PrdWeavingMachinConfig();
try
{
if (model.MaintenanceID > 0)
{
umodel = GenericFactory_MntMachineMaintenanceOrder_EF.GetAll().Where(x => x.MaintenanceID == model.MaintenanceID).FirstOrDefault();
umodel.MachineConfigID = model.MachineConfigID;
umodel.DepartmentID = model.DepartmentID;
umodel.EmployeeID = objcmnParam.loggeduser;
umodel.Reason = model.Reason;
umodel.MaintenanceDate = model.MaintenanceDate;
umodel.CompanyID = objcmnParam.loggedCompany;
umodel.UpdateBy = objcmnParam.loggeduser;
umodel.UpdateOn = DateTime.Now;
umodel.UpdatePc = HostService.GetIP();
}
else
{
MainId = Convert.ToInt16(GenericFactory_MntMachineMaintenanceOrder_EF.getMaxID("MntMachineMaintenanceOrder"));
CustomNo = GenericFactory_MntMachineMaintenanceOrder_EF.getCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, 1, 1);
if (CustomNo == null || CustomNo == "")
{
MaintenanceNo = MainId.ToString();
}
else
{
MaintenanceNo = CustomNo;
}
umodel = new MntMachineMaintenanceOrder()
{
MaintenanceID = (int)MainId,
MaintenanceNo = MaintenanceNo,
MachineConfigID = model.MachineConfigID,
DepartmentID = model.DepartmentID,
EmployeeID = objcmnParam.loggeduser,
Reason = model.Reason,
IsMaintenance = true,
MaintenanceDate = model.MaintenanceDate,
IsDeleted = false,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP()
};
}
uConfig = GenericFactory_WeavingMachinConfig_EF.GetAll().Where(x => x.MachineConfigID == model.MachineConfigID).FirstOrDefault();
uConfig.IsMaintenance = true;
if (model.MaintenanceID > 0)
{
GenericFactory_MntMachineMaintenanceOrder_EF.Update(umodel);
GenericFactory_MntMachineMaintenanceOrder_EF.Save();
}
else
{
GenericFactory_MntMachineMaintenanceOrder_EF.Insert(umodel);
GenericFactory_MntMachineMaintenanceOrder_EF.Save();
GenericFactory_MntMachineMaintenanceOrder_EF.updateMaxID("MntMachineMaintenanceOrder", Convert.ToInt64(MainId));
GenericFactory_MntMachineMaintenanceOrder_EF.updateCustomCode(objcmnParam.menuId, DateTime.Now, objcmnParam.loggedCompany, 1, 1);
}
if (uConfig != null)
{
GenericFactory_WeavingMachinConfig_EF.Update(uConfig);
GenericFactory_WeavingMachinConfig_EF.Save();
}
transaction.Complete();
result = umodel.MaintenanceNo;
}
catch (Exception e)
{
e.ToString();
result = "";
}
}
return(result);
}
