public async Task <IHttpActionResult> SaveUpdateHeadOfficeSalesDeliveryOrder(object[] data)
{
vmSalHDOMaster model = JsonConvert.DeserializeObject <vmSalHDOMaster>(data[0].ToString());
UserCommonEntity commonEntity = JsonConvert.DeserializeObject <UserCommonEntity>(data[1].ToString());
string result = string.Empty;
//int recordsTotal = 0;
try
{
result = await objDOService.SaveUpdateHeadOfficeSalesDeliveryOrder(model, commonEntity);
NotificationHubs.BroadcastData(new NotificationEntity()); // for sending notification
}
catch (Exception e)
{
e.ToString();
result = "";
}
return(Json(new
{
//recordsTotal,
result
}));
//return objDOMaster.ToList();
}
public HttpResponseMessage SaveUpdateMrrMasterNdetails(object[] data)
{
InvMrrMaster mrrMaster = JsonConvert.DeserializeObject <InvMrrMaster>(data[0].ToString());
List <InvMrrDetail> mrrDetails = JsonConvert.DeserializeObject <List <InvMrrDetail> >(data[1].ToString());
int menuID = Convert.ToInt16(data[2]);
UserCommonEntity commonEntity = JsonConvert.DeserializeObject <UserCommonEntity>(data[3].ToString());
string result = "";
try
{
if (ModelState.IsValid && mrrMaster != null && mrrMaster.MrrDate.ToString() != "" && mrrDetails.Count > 0 && menuID != 0)
{
result = objMRR.SaveUpdateMrrMasterNdetails(mrrMaster, mrrDetails, menuID, commonEntity).Result;
NotificationHubs.BroadcastData(new NotificationEntity());
}
else
{
result = "";
}
}
catch (Exception e)
{
e.ToString();
result = "";
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public HttpResponseMessage SaveRequisitionMasterDetails(object[] data)
{
InvRequisitionMaster RequisitionMaster = JsonConvert.DeserializeObject <InvRequisitionMaster>(data[0].ToString());
List <vmRequisitionDetails> RequisitionDetails = JsonConvert.DeserializeObject <List <vmRequisitionDetails> >(data[1].ToString());
// int menuID = Convert.ToInt16(data[2]);
UserCommonEntity commonEntity = JsonConvert.DeserializeObject <UserCommonEntity>(data[2].ToString());
ArrayList fileNames = JsonConvert.DeserializeObject <ArrayList>(data[3].ToString());
string result = "";
try
{
if (ModelState.IsValid && RequisitionMaster != null && RequisitionDetails.Count > 0 && commonEntity != null)
{
result = objRequisitionService.SaveRequisitionMasterDetails(RequisitionMaster, RequisitionDetails, commonEntity, fileNames);
NotificationHubs.BroadcastData(new NotificationEntity());
SPRNo = result;
TransactionTypeID = RequisitionMaster.RequisitionTypeID;
}
else
{
result = "";
}
}
catch (Exception e)
{
e.ToString();
result = "";
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
/// <summary>
/// Save Data To Database
/// <para>Use it when save data through a stored procedure</para>
/// </summary>
public int UpdateCompany(CmnCompany model, UserCommonEntity commonEntity)
{
GenericFactoryFor_Company = new CmnCompany_GF();
int result = 0;
try
{
Hashtable ht = new Hashtable();
ht.Add("CompanyID", model.CompanyID);
ht.Add("CustomCode", model.CustomCode);
ht.Add("CompanyShortName", model.CompanyShortName);
ht.Add("CompanyName", model.CompanyName);
ht.Add("LoggedCompanyID", commonEntity.loggedCompnyID);
ht.Add("LoggedUser", commonEntity.loggedUserID);
string spQuery = "[Put_CmnCompany]";
result = GenericFactoryFor_Company.ExecuteCommand(spQuery, ht);
}
catch (Exception ex)
{
ErrorLog.Log(ex);
ex.ToString();
}
return(result);
}
public IHttpActionResult SaveOperationSetup(object[] data)
{
int result = 0;
List <PrdDyingOperationSetup> masterList = JsonConvert.DeserializeObject <List <PrdDyingOperationSetup> >(data[0].ToString());
#region Shared Entity
UserCommonEntity commonEntity = JsonConvert.DeserializeObject <UserCommonEntity>(data[1].ToString());
var loggedCompnyID = commonEntity.loggedCompnyID;
var loggedUserID = commonEntity.loggedUserID;
var MenuID = commonEntity.currentMenuID;
var loggedUserBranchID = commonEntity.loggedUserBranchID;
var currentModuleID = commonEntity.currentModuleID;
var TransactionTypeID = commonEntity.currentTransactionTypeID;
List <CmnMenu> menuList = JsonConvert.DeserializeObject <List <CmnMenu> >(commonEntity.MenuList.ToString());
List <CmnMenu> ChildMenues = JsonConvert.DeserializeObject <List <CmnMenu> >(commonEntity.ChildMenues.ToString());
#endregion Shared Entity
try
{
result = objOperationSetup.SaveOperationSetup(masterList, commonEntity);
}
catch (Exception e)
{
e.ToString();
result = 0;
}
return(Json(new
{
result
}));
}
public int SaveOperationSetup(List <PrdDyingOperationSetup> masterList, UserCommonEntity commonEntity)
{
GFactory_EF_PrdDyingOperationSetup = new PrdDyingOperationSetup_EF();
List <PrdDyingOperationSetup> listInsertion = new List <PrdDyingOperationSetup>();
List <PrdDyingOperationSetup> listUpDate = new List <PrdDyingOperationSetup>();
int masterID = (int)masterList.FirstOrDefault().OperationSetupID;
int result = 0;
try
{
listInsertion = masterList.Where(x => x.OperationSetupID == 0 && x.IsDeleted == false).ToList();
listUpDate = masterList.Where(x => x.OperationSetupID != 0).ToList();
Int64 ID = Convert.ToInt64(GFactory_EF_PrdDyingOperationSetup.getMaxID("PrdDyingOperationSetup"));
Int64 LastID = ID + listInsertion.Count();
GFactory_EF_PrdDyingOperationSetup.updateMaxID("PrdDyingOperationSetup", Convert.ToInt64(LastID));
for (int num = 0; num < listInsertion.Count(); num++)
{
listInsertion[num].OperationSetupID = ID + num;
if (listInsertion[num].ChemicalItemID == 0)
{
listInsertion[num].ChemicalItemID = null;
}
listInsertion[num].CompanyID = (int)commonEntity.loggedCompnyID;
}
for (int num = 0; num < listUpDate.Count(); num++)
{
if (listUpDate[num].ChemicalItemID == 0)
{
listUpDate[num].ChemicalItemID = null;
}
listUpDate[num].CompanyID = (int)commonEntity.loggedCompnyID;
}
if (listInsertion.ToList().Count > 0)
{
GFactory_EF_PrdDyingOperationSetup.InsertList(listInsertion);
GFactory_EF_PrdDyingOperationSetup.Save();
}
if (listUpDate.Count > 0)
{
GFactory_EF_PrdDyingOperationSetup.UpdateList(listUpDate);
GFactory_EF_PrdDyingOperationSetup.Save();
}
result = 1;
}
catch (Exception ex)
{
ex.Message.ToString();
}
return(result);
}
public int ExecuteTransactionProcess(vmCmnWorkFlowMaster master, UserCommonEntity ent)
{
int result = 0;
try
{
int process = (int)WorkFlowTranProcess.insert;
Hashtable ht = new Hashtable();
ht.Add("InTEAMID", master.UserTeamID ?? 0);
ht.Add("InMENUID", ent.currentMenuID);
ht.Add("InWFMID", master.WorkFlowID);
ht.Add("Inprocess", process);
ht.Add("InTransactionID", master.WorkFlowTranCustomID);
ht.Add("InloggedUserID", ent.loggedUserID);
ht.Add("InloggedCompanyID", ent.loggedCompnyID);
ht.Add("InSequence", 1);
string spQuery = "[SPInsCmnWorkFlowTransaction]";
ERP_Entities _dbctx = new ERP_Entities();
using (_dbctx.Database.Connection)
{
_dbctx.Database.Connection.Open();
DbCommand cmd = _dbctx.Database.Connection.CreateCommand();
cmd.CommandText = spQuery;
cmd.CommandType = CommandType.StoredProcedure;
foreach (object obj in ht.Keys)
{
string str = Convert.ToString(obj);
SqlParameter parameter = new SqlParameter("@" + str, ht[obj]);
cmd.Parameters.Add(parameter);
}
IDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
result = dr.GetInt32(0);
}
cmd.Parameters.Clear();
}
}
catch (Exception ex)
{
result = 0;
ex.Message.ToString();
}
return(result);
}
public int SaveMRRSet(List <vmProductionPrdSetSetupDDL> masterList, UserCommonEntity commonEntity)
{
int result = (int)ResponseMessage.Error;
try
{
PrdDyingMRRSet entity = GenerateSetup(masterList, commonEntity);
GenericFactoryEF_PrdDyingMRRSet.Insert(entity);
GenericFactoryEF_PrdDyingMRRSet.Save();
result = (int)entity.DyingSetID;
}
catch (Exception ex)
{
ex.Message.ToString();
result = (int)ResponseMessage.Exception;
}
return(result);
}
public HttpResponseMessage DeleteCompany(object[] data)
{
int result = 0;
try
{
var id = JsonConvert.DeserializeObject <int>(data[0].ToString());
UserCommonEntity commonEntity = JsonConvert.DeserializeObject <UserCommonEntity>(data[1].ToString());
result = objComService.DeleteCompany(id, commonEntity);
}
catch (Exception e)
{
e.ToString();
result = 0;
}
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public int SaveTeam(vCmnUserTeam master, List <vCmnuserTeamDetail> Details, UserCommonEntity commonEntity)
{
int returnValue = 0;
try
{
GenericFactoryEF_CmnUserTeam = new CmnUserTeam_EF();
if (master.EntityMode == "Inserted")
{
CmnUserTeam returnModel = this.InsertionModelBinding(master, Details, commonEntity);
GenericFactoryEF_CmnUserTeam.Insert(returnModel);
GenericFactoryEF_CmnUserTeam.Save();
returnValue = 1;
}
else if (master.EntityMode == "Updated" && !Details.Any(x => x.EntityMode == "Inserted"))
{
CmnUserTeam returnModel = this.InsertionModelBinding(master, Details, commonEntity);
GenericFactoryEF_CmnUserTeam.Update(returnModel);
GFactory_EF_CmnuserTeamDetail = new CmnuserTeamDetail_EF();
GFactory_EF_CmnuserTeamDetail.UpdateList(this.UpdateDetailsBinding(Details, commonEntity));
GenericFactoryEF_CmnUserTeam.Save();
GFactory_EF_CmnuserTeamDetail.Save();
returnValue = 2;
}
else
{
CmnUserTeam returnModel = this.InsertionModelBinding(master, Details, commonEntity);
GenericFactoryEF_CmnUserTeam.Update(returnModel);
GFactory_EF_CmnuserTeamDetail = new CmnuserTeamDetail_EF();
GFactory_EF_CmnuserTeamDetail.UpdateList(this.UpdateDetailsBinding(Details.Where(x => x.EntityMode == "Updated").ToList(), commonEntity));
GFactory_EF_CmnuserTeamDetail.InsertList(this.InsertionList(master, Details.Where(x => x.EntityMode == "Inserted").ToList(), commonEntity));
GenericFactoryEF_CmnUserTeam.Save();
GFactory_EF_CmnuserTeamDetail.Save();
returnValue = 2;
}
}
catch (Exception ex)
{
throw;
}
return(returnValue);
}
public int GetWorkFlowBeginner(UserCommonEntity ent)
{
int beginnerID = 0;
try
{
using (ERP_Entities dbContext = new ERP_Entities())
{
beginnerID = (from WFM in dbContext.CmnWorkFlowMasters
join WFD in dbContext.CmnWorkFlowDetails on WFM.WorkFlowID equals WFD.WorkFlowID
where WFM.MenuID == ent.currentMenuID && WFM.CompanyID == ent.loggedCompnyID && WFD.Sequence == 1 && WFM.IsActive == true && WFD.IsDeleted == false
select WFD.EmployeeID).FirstOrDefault();
}
}
catch (Exception ex)
{
}
return(beginnerID);
}
//IN CASE OF SAVE
//REQUIRD MENUID, COMPANYID, TARGET USERID AS TARGET USERID, USER AS CURRENT USERID,TRANSACTION ID AS MASTERID(INSERTED) ,STATUSID 1
//IS APPROVED 0, IS DELETE 0, IS UPDATE 0 , @APPROVALCUSTOMCODE = ''
public Hashtable SetProcedureParam(UserCommonEntity ent, int targetUserID, int masterID, int IsApprove, string Comment, int IsUpdate, int IsDelete, int statusID, string approvalCustomCode, int IsDeclained, string Message)
{
Hashtable ht = new Hashtable();
ht.Add("MenuID", ent.currentMenuID);
ht.Add("UserID", ent.loggedUserID);
ht.Add("TargetUserID", targetUserID);
ht.Add("CompanyID", ent.loggedCompnyID);
ht.Add("CreatePc", HostService.GetIP());
ht.Add("TransactionID", masterID);
ht.Add("TransactionDate", DateTime.Now);
ht.Add("IsApprove", IsApprove);
ht.Add("Comment", Comment);
ht.Add("IsUpdate", IsUpdate);
ht.Add("IsDelete", IsDelete);
ht.Add("STATUSID", statusID);
ht.Add("APPROVALCUSTOMCODE", approvalCustomCode);
ht.Add("IsDeclained", IsDeclained);
ht.Add("MessageName", Message);
return(ht);
}
public IHttpActionResult DeleteTeam(object[] data)
{
int result = 0;
vCmnUserTeam master = JsonConvert.DeserializeObject <vCmnUserTeam>(data[0].ToString());
UserCommonEntity commonEntity = JsonConvert.DeserializeObject <UserCommonEntity>(data[2].ToString());
try
{
result = objService.DeleteTeam(master, commonEntity);
}
catch (Exception e)
{
e.ToString();
result = 0;
}
return(Json(new
{
result
}));
//return _finishGoodes;
}
public int DeleteTeam(vCmnUserTeam master, UserCommonEntity commonEntity)
{
int returnValue = 0;
try
{
GenericFactoryEF_CmnUserTeam = new CmnUserTeam_EF();
CmnUserTeam returnModel = GenericFactoryEF_CmnUserTeam.FindBy(x => x.TeamID == master.TeamID).FirstOrDefault();
returnModel.IsDeleted = true;
returnModel.DeleteBy = commonEntity.loggedUserID;
returnModel.DeleteOn = DateTime.Now;
returnModel.DeletePc = HostService.GetIP();
GenericFactoryEF_CmnUserTeam.Update(returnModel);
GenericFactoryEF_CmnUserTeam.Save();
returnValue = 3;
}
catch (Exception)
{
throw;
}
return(returnValue);
}
public List <vmCmnWorkFlowMaster> GetWorkFlowMasterListByMenu(UserCommonEntity ent)
{
List <vmCmnWorkFlowMaster> list = new List <vmCmnWorkFlowMaster>();
try
{
using (ERP_Entities dbContext = new ERP_Entities())
{
list = (from WFM in dbContext.CmnWorkFlowMasters
where WFM.MenuID == ent.currentMenuID && WFM.CompanyID == ent.loggedCompnyID && WFM.IsActive == true && WFM.IsDeleted == false
select new vmCmnWorkFlowMaster
{
WorkFlowID = WFM.WorkFlowID,
MenuID = WFM.MenuID,
BranchID = WFM.BranchID,
UserTeamID = WFM.UserTeamID,
IsActive = WFM.IsActive,
CompanyID = WFM.CompanyID,
DBID = WFM.DBID,
CreateBy = WFM.CreateBy,
CreateOn = WFM.CreateOn,
CreatePc = WFM.CreatePc,
UpdateBy = WFM.UpdateBy,
UpdateOn = WFM.UpdateOn,
UpdatePc = WFM.UpdatePc,
IsDeleted = WFM.IsDeleted,
DeleteBy = WFM.DeleteBy,
DeleteOn = WFM.DeleteOn,
DeletePc = WFM.DeletePc,
Transfer = WFM.Transfer
}).ToList();
}
}
catch (Exception ex)
{
throw new Exception("PleaseCheckMethod:GetWorkFlowMasterListByMenu" + ex.Message.ToString());
}
return(list);
}
/// <summary>
/// Update Delete From Database
/// <para>Use it when delete data through a stored procedure</para>
/// </summary>
public int DeleteCompany(int?CompanyID, UserCommonEntity commonEntity)
{
GenericFactoryFor_Company = new CmnCompany_GF();
int result = 0;
try
{
Hashtable ht = new Hashtable();
ht.Add("CompanyID", CompanyID);
ht.Add("LoggedCompanyID", commonEntity.loggedCompnyID);
ht.Add("LoggedUser", commonEntity.loggedUserID);
string spQuery = "[Delete_CmnCompany]";
result = GenericFactoryFor_Company.ExecuteCommand(spQuery, ht);
}
catch (Exception ex)
{
ErrorLog.Log(ex);
ex.ToString();
}
return(result);
}
public IHttpActionResult SaveCompanyParam(object[] data)
{
int result = 0;
CmnCompany modelFirst = JsonConvert.DeserializeObject <CmnCompany>(data[0].ToString());
#region Shared Entity
UserCommonEntity commonEntity = JsonConvert.DeserializeObject <UserCommonEntity>(data[1].ToString());
var loggedCompnyID = commonEntity.loggedCompnyID;
var loggedUserID = commonEntity.loggedUserID;
var MenuID = commonEntity.currentMenuID;
var loggedUserBranchID = commonEntity.loggedUserBranchID;
var currentModuleID = commonEntity.currentModuleID;
var TransactionTypeID = commonEntity.currentTransactionTypeID;
List <CmnMenu> menuList = JsonConvert.DeserializeObject <List <CmnMenu> >(commonEntity.MenuList.ToString());
List <CmnMenu> ChildMenues = JsonConvert.DeserializeObject <List <CmnMenu> >(commonEntity.ChildMenues.ToString());
#endregion Shared Entity
try
{
// result = objComService.SaveCompany(modelFirst);
result = objComService.SaveCompanyParam(modelFirst, commonEntity);
// NotificationHubs.BroadcastData();
NotificationHubs.BroadcastData(new NotificationEntity());
result = 1;
}
catch (Exception e)
{
e.ToString();
result = 0;
}
return(Json(new
{
result
}));
//return _finishGoodes;
}
public IHttpActionResult SaveMRRSet(object[] data)
{
int result = 0;
List <vmProductionPrdSetSetupDDL> masterList = JsonConvert.DeserializeObject <List <vmProductionPrdSetSetupDDL> >(data[0].ToString());
#region Shared Entity
UserCommonEntity commonEntity = JsonConvert.DeserializeObject <UserCommonEntity>(data[1].ToString());
#endregion Shared Entity
try
{
DyingChemicalConsumptionMgt service = new DyingChemicalConsumptionMgt();
result = service.SaveMRRSet(masterList, commonEntity);
}
catch (Exception e)
{
e.ToString();
result = 0;
}
return(Json(new
{
result
}));
}
public IHttpActionResult SaveMRR(object[] data)
{
int result = 0;
vmPrdDyingMRRMaster master = JsonConvert.DeserializeObject <vmPrdDyingMRRMaster>(data[0].ToString());
List <vmPrdDyingMRRDetail> DetailsList = JsonConvert.DeserializeObject <List <vmPrdDyingMRRDetail> >(data[1].ToString());
#region Shared Entity
UserCommonEntity commonEntity = JsonConvert.DeserializeObject <UserCommonEntity>(data[2].ToString());
#endregion Shared Entity
try
{
DyingChemicalConsumptionMgt service = new DyingChemicalConsumptionMgt();
result = service.SaveMRR(master, DetailsList, commonEntity);
}
catch (Exception e)
{
e.ToString();
result = 0;
}
return(Json(new
{
result
}));
}
public IHttpActionResult SaveChemicalPrepartion(object[] data)
{
int result = 0;
PrdDyingChemicalSetup master = JsonConvert.DeserializeObject <PrdDyingChemicalSetup>(data[0].ToString());
List <PrdDyingChemicalSetupDetail> Details = JsonConvert.DeserializeObject <List <PrdDyingChemicalSetupDetail> >(data[1].ToString());
#region Shared Entity
UserCommonEntity commonEntity = JsonConvert.DeserializeObject <UserCommonEntity>(data[2].ToString());
var loggedCompnyID = commonEntity.loggedCompnyID;
var loggedUserID = commonEntity.loggedUserID;
var MenuID = commonEntity.currentMenuID;
var loggedUserBranchID = commonEntity.loggedUserBranchID;
var currentModuleID = commonEntity.currentModuleID;
var loggedUserDepartmentID = commonEntity.loggedUserDepartmentID;
var TransactionTypeID = commonEntity.currentTransactionTypeID;
List <CmnMenu> menuList = JsonConvert.DeserializeObject <List <CmnMenu> >(commonEntity.MenuList.ToString());
List <CmnMenu> ChildMenues = JsonConvert.DeserializeObject <List <CmnMenu> >(commonEntity.ChildMenues.ToString());
#endregion Shared Entity
try
{
result = objChemicalService.SaveChemicalPrepartion(master, Details, commonEntity);
// result = 1;
}
catch (Exception e)
{
e.ToString();
result = 0;
}
return(Json(new
{
result
}));
//return _finishGoodes;
}
public IHttpActionResult Save(object[] data)
{
int result = 0;
PrdDyingConsumptionMaster master = JsonConvert.DeserializeObject <PrdDyingConsumptionMaster>(data[0].ToString());
List <PrdDyingConsumptionDetail> DetailsList = JsonConvert.DeserializeObject <List <PrdDyingConsumptionDetail> >(data[1].ToString());
#region Shared Entity
UserCommonEntity commonEntity = JsonConvert.DeserializeObject <UserCommonEntity>(data[2].ToString());
#endregion Shared Entity
try
{
businessObject = new DyingPRDChemicalConsumptionMgt();
result = businessObject.SaveChemicalConsumption(master, DetailsList, commonEntity);
}
catch (Exception e)
{
e.ToString();
result = 0;
}
return(Json(new
{
result
}));
}
public int SaveChemicalPrepartion(PrdDyingChemicalSetup model, List <PrdDyingChemicalSetupDetail> details, UserCommonEntity commonEntity)
{
GFactory_EF_PrdDyingChemicalSetup = new PrdDyingChemicalSetup_EF();
GenericFactory_EF_PrdDyingChemicalSetupDetail = new PrdDyingChemicalSetupDetail_EF();
int masterID = (int)model.ChemicalSetupID;
PrdDyingChemicalSetup modelBase = new PrdDyingChemicalSetup();
List <Int32> UpdatedIDs = new List <Int32>();
List <PrdDyingChemicalSetupDetail> detailsList = new List <PrdDyingChemicalSetupDetail>();
List <PrdDyingChemicalSetupDetail> detailsInsertionList = new List <PrdDyingChemicalSetupDetail>();
int result = 0;
try
{
modelBase = ModelBinding(model, details);
foreach (var item in modelBase.PrdDyingChemicalSetupDetails)
{
if (item.EntryStateStatus == "Modified")
{
PrdDyingChemicalSetupDetail detailsEntity = new PrdDyingChemicalSetupDetail();
detailsEntity = DetailsBinding(modelBase.PrdDyingChemicalSetupDetails.Where(x => x.ChemicalSetupDetailID == item.ChemicalSetupDetailID).FirstOrDefault());
detailsList.Add(detailsEntity);
UpdatedIDs.Add((int)detailsEntity.ChemicalSetupDetailID);
}
if (item.EntryStateStatus == "Add" && masterID > 0)
{
PrdDyingChemicalSetupDetail detailsEntity = new PrdDyingChemicalSetupDetail();
detailsEntity = DetailsBinding(modelBase.PrdDyingChemicalSetupDetails.Where(x => x.ChemicalSetupDetailID == item.ChemicalSetupDetailID).FirstOrDefault());
detailsInsertionList.Add(detailsEntity);
}
}
foreach (var item in UpdatedIDs)
{
modelBase.PrdDyingChemicalSetupDetails.Remove(modelBase.PrdDyingChemicalSetupDetails.Where(x => x.ChemicalSetupDetailID == item).FirstOrDefault());
}
if (masterID == 0)
{
GFactory_EF_PrdDyingChemicalSetup.Insert(modelBase);
GFactory_EF_PrdDyingChemicalSetup.Save();
}
else
{
GFactory_EF_PrdDyingChemicalSetup.Update(model);
GenericFactory_EF_PrdDyingChemicalSetupDetail.UpdateList(detailsList);
GenericFactory_EF_PrdDyingChemicalSetupDetail.InsertList(detailsInsertionList);
GFactory_EF_PrdDyingChemicalSetup.Save();
GenericFactory_EF_PrdDyingChemicalSetupDetail.Save();
}
result = 1;
}
catch (Exception ex)
{
ex.Message.ToString();
}
return(result);
}
public async Task <string> SaveUpdateSetSetupMasterDetail(vmSetSetupMasterDetail ModelMaster, List <vmSetSetupMasterDetail> ModelDetail, vmCmnParameters objcmnParam)
{
string result = string.Empty;
long TransactionID = 0;
using (var transaction = new TransactionScope())
{
GFactory_EF_PrdSetMaster = new PrdSetMaster_EF();
GFactory_EF_PrdSetSetup = new PrdSetSetup_EF();
string SetNo = string.Empty; int SetMasterId = 0, SetDetailId = 0;
long SetFirstDigit = 0, SetOtherDigits = 0;
var Masteritem = new PrdSetMaster();
var SetDetail = new List <PrdSetSetup>();
vmSetSetupMasterDetail item = new vmSetSetupMasterDetail();
vmSetSetupMasterDetail items = new vmSetSetupMasterDetail();
//-------------------END----------------------
if (ModelDetail.Count() > 0)
{
try
{
using (_ctxCmn = new ERP_Entities())
{
if (ModelMaster.SetMasterID == 0)
{
SetMasterId = Convert.ToInt16(GFactory_EF_PrdSetMaster.getMaxID("PrdSetMaster"));
SetDetailId = Convert.ToInt16(GFactory_EF_PrdSetSetup.getMaxID("PrdSetSetup"));
SetFirstDigit = Convert.ToInt64(SetDetailId.ToString().Substring(0, 1));
SetOtherDigits = Convert.ToInt64(SetDetailId.ToString().Substring(1, SetDetailId.ToString().Length - 1));
//CustomNo = GFactory_EF_PrdSetSetup.getCustomCode(MenuId, DateTime.Now, CompanyId, 1, 1);
//if (CustomNo == null || CustomNo == "")
//{
// SetNo = SetDetailId.ToString();
//}
//else
//{
// SetNo = CustomNo;
//}
TransactionID = SetMasterId;
Masteritem = new PrdSetMaster
{
SetMasterID = SetMasterId,
BuyerID = ModelMaster.BuyerID,
Description = ModelMaster.Description,
ItemID = (long)ModelMaster.ItemID,
PIID = ModelMaster.PIID,
PIItemlength = ModelMaster.PIItemlength,
RefSetDate = ModelMaster.RefSetDate,
RefSetID = ModelMaster.RefSetID,
SetDate = ModelMaster.SetDate,
SupplierID = ModelMaster.SupplierID,
StatusID = ModelMaster.StatusID,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false
};
for (int i = 0; i < ModelDetail.Count(); i++)
{
item = ModelDetail[i];
var Detailitem = new PrdSetSetup
{
SetID = Convert.ToInt64(SetFirstDigit + "" + SetOtherDigits),
YarnID = (long)item.YarnID,
WarpYarnID = item.YarnID,
WeftYarnID = item.WeftYarnID,
Weave = item.Weave,
BuyerID = item.BuyerID,
ColorID = item.ColorID,
Description = item.Description,
EndsPerCreel = item.EndsPerCreel,
LeaseReapet = item.LeaseRepeat,
MachineSpeed = item.MachineSpeed,
SetDate = item.SetDate,
ItemID = (long)item.ItemID,
PIID = item.PIID,
SetLength = (long)item.SetLength,
SetMasterID = SetMasterId,
SetNo = item.SetNo,
SupplierID = item.SupplierID,
TotalEnds = item.TotalEnds,
YarnCount = item.YarnCount,
YarnRatio = item.YarnRatio,
YarnRatioLot = item.YarnRatioLot,
NoOfBall = item.NoOfBall,
CompanyID = objcmnParam.loggedCompany,
CreateBy = objcmnParam.loggeduser,
CreateOn = DateTime.Now,
CreatePc = HostService.GetIP(),
IsDeleted = false
};
//***************************************END*******************************************
SetDetail.Add(Detailitem);
SetOtherDigits++;
}
}
else
{
var SetMasterAll = GFactory_EF_PrdSetMaster.GetAll().Where(x => x.SetMasterID == ModelMaster.SetMasterID);
var SetDetailAll = GFactory_EF_PrdSetSetup.GetAll().Where(x => x.SetMasterID == ModelMaster.SetMasterID);
Masteritem = SetMasterAll.FirstOrDefault(x => x.SetMasterID == ModelMaster.SetMasterID);
Masteritem.BuyerID = ModelMaster.BuyerID;
Masteritem.Description = ModelMaster.Description;
Masteritem.ItemID = (long)ModelMaster.ItemID;
Masteritem.PIID = ModelMaster.PIID;
Masteritem.PIItemlength = ModelMaster.PIItemlength;
Masteritem.RefSetDate = ModelMaster.RefSetDate;
Masteritem.RefSetID = ModelMaster.RefSetID;
Masteritem.SetDate = ModelMaster.SetDate;
Masteritem.SupplierID = ModelMaster.SupplierID;
Masteritem.StatusID = ModelMaster.StatusID;
Masteritem.CompanyID = objcmnParam.loggedCompany;
Masteritem.UpdateBy = objcmnParam.loggeduser;
Masteritem.UpdateOn = DateTime.Now;
Masteritem.UpdatePc = HostService.GetIP();
Masteritem.IsDeleted = false;
for (int i = 0; i < ModelDetail.Count(); i++)
{
item = ModelDetail[i];
foreach (PrdSetSetup d in SetDetailAll.Where(d => d.SetMasterID == ModelMaster.SetMasterID && d.SetID == item.SetID))
{
d.YarnID = (long)item.YarnID;
d.WarpYarnID = item.YarnID;
d.WeftYarnID = item.WeftYarnID;
d.Weave = item.Weave;
d.BuyerID = item.BuyerID;
d.ColorID = item.ColorID;
d.Description = item.Description;
d.EndsPerCreel = item.EndsPerCreel;
d.LeaseReapet = item.LeaseRepeat;
d.MachineSpeed = item.MachineSpeed;
d.SetDate = item.SetDate;
d.ItemID = (long)item.ItemID;
d.PIID = item.PIID;
d.SetLength = (long)item.SetLength;
d.SetNo = item.SetNo;
d.SupplierID = item.SupplierID;
d.TotalEnds = item.TotalEnds;
d.YarnCount = item.YarnCount;
d.YarnRatio = item.YarnRatio;
d.YarnRatioLot = item.YarnRatioLot;
d.NoOfBall = item.NoOfBall;
d.CompanyID = objcmnParam.loggedCompany;
d.UpdateBy = objcmnParam.loggeduser;
d.UpdateOn = DateTime.Now;
d.UpdatePc = HostService.GetIP();
d.IsDeleted = false;
SetDetail.Add(d);
break;
}
}
}
if (ModelMaster.SetMasterID > 0)
{
if (Masteritem != null)
{
GFactory_EF_PrdSetMaster.Update(Masteritem);
GFactory_EF_PrdSetMaster.Save();
}
if (SetDetail != null && SetDetail.Count != 0)
{
GFactory_EF_PrdSetSetup.UpdateList(SetDetail.ToList());
GFactory_EF_PrdSetSetup.Save();
}
}
else
{
if (Masteritem != null)
{
GFactory_EF_PrdSetMaster.Insert(Masteritem);
GFactory_EF_PrdSetMaster.Save();
GFactory_EF_PrdSetMaster.updateMaxID("PrdSetMaster", Convert.ToInt64(SetMasterId));
}
if (SetDetail != null && SetDetail.Count != 0)
{
GFactory_EF_PrdSetSetup.InsertList(SetDetail.ToList());
GFactory_EF_PrdSetSetup.Save();
GFactory_EF_PrdSetSetup.updateMaxID("PrdSetSetup", Convert.ToInt64(SetFirstDigit + "" + (SetOtherDigits - 1)));
}
}
transaction.Complete();
result = "1";
}
}
catch (Exception e)
{
result = "";
e.ToString();
}
}
else
{
result = "";
throw new Exception();
}
}
// Approval Code
#region WorkFlow Transaction Entry and email sending
if (ModelMaster.SetMasterID == 0)
{
UserCommonEntity commonEntity = new UserCommonEntity();
commonEntity.currentMenuID = objcmnParam.menuId;
commonEntity.loggedCompnyID = objcmnParam.loggedCompany;
commonEntity.loggedUserID = objcmnParam.loggeduser;
int workflowID = 0;
List <vmCmnWorkFlowMaster> listWorkFlow = new WorkFLowMgt().GetWorkFlowMasterListByMenu(commonEntity);
foreach (vmCmnWorkFlowMaster itemWFM in listWorkFlow)
{
int userTeamID = itemWFM.UserTeamID ?? 0;
if (new WorkFLowMgt().checkUserValidation(commonEntity.loggedUserID ?? 0, itemWFM.WorkFlowID) && userTeamID > 0)
{
itemWFM.WorkFlowTranCustomID = (Int16)TransactionID;
workflowID = new WorkFLowMgt().ExecuteTransactionProcess(itemWFM, commonEntity);
}
if (userTeamID == 0)
{
itemWFM.WorkFlowTranCustomID = (Int16)TransactionID;
workflowID = new WorkFLowMgt().ExecuteTransactionProcess(itemWFM, commonEntity);
}
}
int mail = 0;
foreach (vmCmnWorkFlowMaster itemWFM in listWorkFlow)
{
NotificationEntity notification = new NotificationEntity();
notification.WorkFlowID = itemWFM.WorkFlowID;
notification.TransactionID = (Int16)TransactionID;
List <vmNotificationMail> nModel = new WorkFLowMgt().GetNotificationMailObjectList(notification, "Created");
foreach (var mailModel in nModel)
{
mail = await new EmailService().NotificationMail(mailModel);
}
}
}
#endregion WorkFlow Transaction Entry and email sending
return(result);
}
private List <CmnuserTeamDetail> UpdateDetailsBinding(List <vCmnuserTeamDetail> details, UserCommonEntity commonEntity)
{
List <CmnuserTeamDetail> list = new List <CmnuserTeamDetail>();
foreach (vCmnuserTeamDetail Item in details)
{
CmnuserTeamDetail entity = new CmnuserTeamDetail();
entity.TeamDetailID = Item.TeamDetailID;
entity.TeamID = Item.TeamID;
entity.UserID = Item.UserID;
entity.Sequence = Item.Sequence;
entity.CompanyID = Item.CompanyID;
entity.IsDeleted = Item.IsDeleted;
if (Item.IsDeleted == false)
{
entity.UpdateBy = commonEntity.loggedUserID;
entity.UpdateOn = DateTime.Now;
entity.UpdatePc = HostService.GetIP();
}
else
{
entity.DeleteBy = commonEntity.loggedUserID;
entity.DeleteOn = DateTime.Now;
entity.DeletePc = HostService.GetIP();
}
list.Add(entity);
}
return(list);
}
public PrdDyingMRRMaster GenerateMrrSave(vmPrdDyingMRRMaster master, List <vmPrdDyingMRRDetail> details, UserCommonEntity commonEntity)
{
PrdDyingMRRMaster MRR = new PrdDyingMRRMaster();
DateTime serverDate = DateTime.Now;
String HostID = HostService.GetIP();
ERP_Entities context = new ERP_Entities();
serverDate = context.Database.SqlQuery <DateTime>("SELECT getdate()").AsEnumerable().First();
Int64 MasterID = 0; long detialsID = 0;
MasterID = context.Database.SqlQuery <Int64>(" Select ISNULL(max(DyingMRRID), 0) +1 from PrdDyingMRRMaster").AsEnumerable().First();
detialsID = context.Database.SqlQuery <Int64>(" Select ISNULL(max(DyingMRRDetailID), 0) +1 from PrdDyingMRRDetail").AsEnumerable().First();
string startTime = "7:00 AM";
TimeSpan ts;
TimeSpan.TryParse(startTime, out ts);
try
{
MRR.DyingMRRID = MasterID;
MRR.DyingMRRNo = MRR.DyingMRRID.ToString();
MRR.DyingSetNo = master.DyingSetNo;
MRR.MachineID = master.MachineID;
MRR.ItemID = master.ItemID;
MRR.KGPreMin = master.KGPreMin;
MRR.Moiture = master.Moiture;
MRR.Speed = master.Speed;
MRR.TotalLength = master.TotalLength;
MRR.ShiftID = master.ShiftID;
MRR.EndTime = master.EndTime == null?TimeSpan.Parse("0:00") : master.EndTime;
MRR.StartTime = master.StartTime == null?TimeSpan.Parse("0:00") : master.StartTime;
MRR.Description = master.Description;
MRR.Description = "";
MRR.BuyerID = master.BuyerID;
MRR.RefSetID = (int)master.RefSetID;
MRR.RefSetDate = master.RefSetDate;
MRR.Date = master.Date;
MRR.CompanyID = commonEntity.loggedCompnyID ?? 0;
MRR.CreateBy = commonEntity.loggedUserID;
MRR.CreateOn = master.CreateOn;
MRR.CreatePc = HostID;
//MRR.UpdateBy = master.UpdateBy;
//MRR.UpdateOn = master.UpdateOn;
//MRR.UpdatePc = master.UpdatePc;
MRR.IsDeleted = master.IsDeleted;
//MRR.DeleteBy = master.DeleteBy;
//MRR.DeleteOn = master.DeleteOn;
//MRR.DeletePc = master.DeletePc;
foreach (vmPrdDyingMRRDetail item in details)
{
PrdDyingMRRDetail detail = new PrdDyingMRRDetail();
detail.DyingMRRDetailID = ++detialsID;
detail.DyingMRRID = MRR.DyingMRRID;
detail.DyingProcessID = item.DyingProcessID;
detail.Time = item.Time;
detail.OperationID = item.OperationID;
detail.Quantity = item.Quantity;
detail.UnitID = item.UnitID;
detail.CompanyID = commonEntity.loggedCompnyID ?? 0;;
detail.CreateBy = commonEntity.loggedUserID;
detail.CreateOn = serverDate;
detail.CreatePc = HostID;
//detail.UpdateBy = item.UpdateBy;
//detail.UpdateOn = item.UpdateOn;
//detail.UpdatePc = item.UpdatePc;
detail.IsDeleted = item.IsDeleted;
//detail.DeleteBy = item.DeleteBy;
//detail.DeleteOn = item.DeleteOn;
//detail.DeletePc = item.DeletePc;
MRR.PrdDyingMRRDetails.Add(detail);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
return(MRR);
}
public PrdDyingMRRMaster GenerateMrrUpdate(vmPrdDyingMRRMaster master, List <vmPrdDyingMRRDetail> details, UserCommonEntity commonEntity)
{
PrdDyingMRRMaster MRR = new PrdDyingMRRMaster();
DateTime serverDate = DateTime.Now;
String HostID = HostService.GetIP();
ERP_Entities context = new ERP_Entities();
PrdDyingMRRMaster masterDatafromdb = context.PrdDyingMRRMasters.Where(X => X.DyingMRRID == master.DyingMRRID).FirstOrDefault();
serverDate = context.Database.SqlQuery <DateTime>("SELECT getdate()").AsEnumerable().First();
Int64 MasterID = 0; long detialsID = 0;
MasterID = context.Database.SqlQuery <Int64>(" Select ISNULL(max(DyingMRRID), 0) +1 from PrdDyingMRRMaster").AsEnumerable().First();
detialsID = context.Database.SqlQuery <Int64>(" Select ISNULL(max(DyingMRRDetailID), 0) +1 from PrdDyingMRRDetail").AsEnumerable().First();
PrdDyingMRRDetail_IEF = new PrdDyingMRRDetail_EF();
List <PrdDyingMRRDetail> insertionList = new List <PrdDyingMRRDetail>();
try
{
MRR.DyingMRRID = master.DyingMRRID;
MRR.DyingMRRNo = MRR.DyingMRRID.ToString();
MRR.DyingSetNo = master.DyingSetNo;
MRR.MachineID = master.MachineID;
MRR.ItemID = master.ItemID;
MRR.KGPreMin = master.KGPreMin;
MRR.Moiture = master.Moiture;
MRR.Speed = master.Speed;
MRR.TotalLength = master.TotalLength;
MRR.ShiftID = master.ShiftID;
MRR.EndTime = master.EndTime == null?TimeSpan.Parse("0:00") : master.EndTime;
MRR.StartTime = master.StartTime == null?TimeSpan.Parse("0:00") : master.StartTime;
MRR.Description = master.Description;
MRR.Description = "";
MRR.BuyerID = master.BuyerID;
MRR.RefSetID = (int)master.RefSetID;
MRR.RefSetDate = master.RefSetDate;
MRR.Date = master.Date;
MRR.CompanyID = commonEntity.loggedCompnyID ?? 0;
if (master.EntityState == "Insert")
{
MRR.CreateBy = commonEntity.loggedUserID;
MRR.CreateOn = serverDate;
MRR.CreatePc = HostID;
}
if (master.EntityState == "Update")
{
MRR.CreateBy = masterDatafromdb.CreateBy;
MRR.CreateOn = masterDatafromdb.CreateOn;
MRR.CreatePc = masterDatafromdb.CreatePc;
MRR.UpdateBy = commonEntity.loggedUserID;
MRR.UpdateOn = serverDate;
MRR.UpdatePc = HostID;
}
MRR.IsDeleted = master.IsDeleted;
if (MRR.IsDeleted)
{
MRR.DeleteBy = commonEntity.loggedUserID;
MRR.DeleteOn = serverDate;
MRR.DeletePc = HostID;
}
foreach (vmPrdDyingMRRDetail item in details)
{
PrdDyingMRRDetail detail = new PrdDyingMRRDetail();
if (item.EntityState == "Insert")
{
detail.DyingMRRDetailID = ++detialsID;
}
else
{
detail.DyingMRRDetailID = item.DyingMRRDetailID;
}
detail.DyingMRRID = MRR.DyingMRRID;
detail.DyingProcessID = item.DyingProcessID;
detail.Time = item.Time;
detail.OperationID = item.OperationID;
detail.Quantity = item.Quantity;
detail.UnitID = item.UnitID;
detail.CompanyID = commonEntity.loggedCompnyID ?? 0;
if (item.EntityState == "Insert")
{
detail.CreateBy = commonEntity.loggedUserID;
detail.CreateOn = serverDate;
detail.CreatePc = HostID;
}
if (item.EntityState == "Update")
{
detail.CreateBy = item.CreateBy;
detail.CreateOn = item.CreateOn;
detail.CreatePc = item.CreatePc;
detail.UpdateBy = commonEntity.loggedUserID;
detail.UpdateOn = serverDate;
detail.UpdatePc = HostID;
}
detail.IsDeleted = item.IsDeleted;
if (detail.IsDeleted)
{
detail.DeleteBy = commonEntity.loggedUserID;
detail.DeleteOn = serverDate;
detail.DeletePc = HostID;
}
if (item.EntityState == "Update")
{
MRR.PrdDyingMRRDetails.Add(detail);
}
else
{
insertionList.Add(detail);
}
}
if (insertionList.Count > 0)
{
PrdDyingMRRDetail_IEF.InsertList(insertionList);
PrdDyingMRRDetail_IEF.Save();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
return(MRR);
}
public int SaveMRR(vmPrdDyingMRRMaster master, List <vmPrdDyingMRRDetail> details, UserCommonEntity commonEntity)
{
int result = (int)ResponseMessage.Error;
try
{
PrdDyingMRRMaster entity = new PrdDyingMRRMaster();
PrdDyingMRRMaster_IEF = new PrdDyingMRRMaster_EF();
if (master.EntityState == "Insert")
{
entity = GenerateMrrSave(master, details, commonEntity);
PrdDyingMRRMaster_IEF.Insert(entity);
PrdDyingMRRMaster_IEF.Save();
}
else
{
entity = GenerateMrrUpdate(master, details, commonEntity);
PrdDyingMRRMaster_IEF.Update(entity);
if (entity.PrdDyingMRRDetails.Count() > 0)
{
PrdDyingMRRDetail_IEF = new PrdDyingMRRDetail_EF();
PrdDyingMRRDetail_IEF.UpdateList(entity.PrdDyingMRRDetails);
PrdDyingMRRDetail_IEF.Save();
}
PrdDyingMRRMaster_IEF.Save();
}
result = (int)entity.DyingMRRID;
}
catch (Exception ex)
{
ex.Message.ToString();
result = (int)ResponseMessage.Exception;
}
return(result);
}
private List <CmnuserTeamDetail> InsertionList(vCmnUserTeam model, List <vCmnuserTeamDetail> details, UserCommonEntity commonEntity)
{
List <CmnuserTeamDetail> list = new List <CmnuserTeamDetail>();
GenericFactoryEF_CmnUserTeam = new CmnUserTeam_EF();
Int64 NextID = GenericFactoryEF_CmnUserTeam.getMaxVal_int64("TeamDetailID", "CmnuserTeamDetail");
foreach (vCmnuserTeamDetail Item in details)
{
CmnuserTeamDetail entity = new CmnuserTeamDetail();
entity.TeamDetailID = NextID++;
entity.TeamID = model.TeamID;
entity.UserID = Item.UserID;
entity.Sequence = Item.Sequence;
entity.CompanyID = Item.CompanyID;
entity.CreateBy = Item.CreateBy;
entity.CreateOn = DateTime.Now;
entity.CreatePc = HostService.GetIP();
entity.UpdateBy = Item.UpdateBy;
entity.UpdateOn = Item.UpdateOn;
entity.UpdatePc = Item.UpdatePc;
entity.IsDeleted = Item.IsDeleted;
entity.DeleteBy = Item.DeleteBy;
entity.DeleteOn = Item.DeleteOn;
entity.DeletePc = Item.DeletePc;
list.Add(entity);
}
return(list);
}
public PrdDyingMRRSet GenerateSetup(List <vmProductionPrdSetSetupDDL> masterList, UserCommonEntity commonEntity)
{
PrdDyingMRRSet mRRSet = new PrdDyingMRRSet();
try
{
bool isDeleted = false;
DateTime serverDate = DateTime.Now;
List <vmPrdSetSetup> listSetup = new List <vmPrdSetSetup>();
using (ERP_Entities context = new ERP_Entities())
{
var dateQuery = context.Database.SqlQuery <DateTime>("SELECT getdate()");
serverDate = dateQuery.AsEnumerable().First();
foreach (vmProductionPrdSetSetupDDL item in masterList)
{
vmPrdSetSetup setupEntity = (from setup in context.PrdSetSetups
join pi in context.SalPIMasters on setup.PIID equals pi.PIID into leftPIgroup
from lfg in leftPIgroup.DefaultIfEmpty()
where setup.SetID == item.id
select new vmPrdSetSetup
{
SetID = setup.SetID,
SetNo = setup.SetNo,
SetMasterID = setup.SetMasterID,
ItemID = setup.ItemID,
YarnID = setup.YarnID,
YarnCount = setup.YarnCount,
YarnRatioLot = setup.YarnRatioLot,
YarnRatio = setup.YarnRatio,
SetTrackingNo = setup.SetTrackingNo,
NoOfBall = setup.NoOfBall,
SetLength = setup.SetLength,
MachineSpeed = setup.MachineSpeed,
TotalEnds = setup.TotalEnds,
Weave = setup.Weave,
EndsPerRope = setup.EndsPerRope,
EndsPerCreel = setup.EndsPerCreel,
LeaseReapet = setup.LeaseReapet,
PIID = setup.PIID,
PINo = lfg.PINO,
SupplierID = setup.SupplierID,
BuyerID = setup.BuyerID,
ColorID = setup.ColorID,
WeftYarnID = setup.WeftYarnID,
WarpYarnID = setup.WarpYarnID,
Description = setup.Description,
SetDate = setup.SetDate,
CompanyID = setup.CompanyID,
CreateBy = setup.CreateBy,
CreateOn = setup.CreateOn,
CreatePc = setup.CreatePc,
UpdateBy = setup.UpdateBy,
UpdateOn = setup.UpdateOn,
UpdatePc = setup.UpdatePc,
IsDeleted = setup.IsDeleted,
DeleteBy = setup.DeleteBy,
DeleteOn = setup.DeleteOn,
DeletePc = setup.DeletePc
}).FirstOrDefault();
listSetup.Add(setupEntity);
}
}
GenericFactoryEF_PrdDyingMRRSet = new PrdDyingMRRSet_EF();
mRRSet.DyingSetID = Convert.ToInt16(GenericFactoryEF_PrdDyingMRRSet.getMaxID("PrdDyingMRRSet"));
GenericFactoryEF_PrdDyingMRRSet.updateMaxID("PrdDyingMRRSet", Convert.ToInt64(mRRSet.DyingSetID));
mRRSet.DyingPINo = null;
bool firstRow = true;
foreach (vmPrdSetSetup item in listSetup)
{
mRRSet.ItemID = item.ItemID;
if (string.IsNullOrEmpty(mRRSet.DyingPINo))
{
mRRSet.DyingPINo = "0";
}
if (firstRow)
{
mRRSet.DyingSetNo = item.SetNo;
mRRSet.TotalSetLength = item.SetLength ?? 0;
}
else
{
mRRSet.DyingSetNo = mRRSet.DyingSetNo + "," + item.SetNo;
mRRSet.TotalSetLength = mRRSet.TotalSetLength + item.SetLength ?? 0;
}
mRRSet.DyingPINo = mRRSet.DyingPINo + mRRSet.DyingPINo ?? "0";
mRRSet.CompanyID = commonEntity.loggedCompnyID ?? 0;
mRRSet.IsDeleted = isDeleted;
mRRSet.CreateBy = commonEntity.loggedUserID;
mRRSet.CreatePc = HostService.GetIP();
mRRSet.CreateOn = serverDate;
PrdDyingMRRSetDetail mrrSetDetails = new PrdDyingMRRSetDetail();
GenericFactoryEF_PrdDyingMRRSetDetail = new PrdDyingMRRSetDetail_EF();
mrrSetDetails.DyingSetIDDetailID = Convert.ToInt16(GenericFactoryEF_PrdDyingMRRSetDetail.getMaxID("PrdDyingMRRSetDetail"));
GenericFactoryEF_PrdDyingMRRSetDetail.updateMaxID("PrdDyingMRRSetDetail", Convert.ToInt64(mrrSetDetails.DyingSetIDDetailID));
mrrSetDetails.DyingSetID = mRRSet.DyingSetID;
mrrSetDetails.PIID = item.PIID;
mrrSetDetails.SetLength = item.SetLength ?? 0;
mrrSetDetails.SetID = item.SetID;
mrrSetDetails.CompanyID = commonEntity.loggedCompnyID ?? 0;
mrrSetDetails.IsDeleted = isDeleted;
mrrSetDetails.CreateBy = mRRSet.CreateBy;
mrrSetDetails.CreatePc = mRRSet.CreatePc;
mrrSetDetails.CreateOn = mRRSet.CreateOn;
mRRSet.PrdDyingMRRSetDetails.Add(mrrSetDetails);
firstRow = false;
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
return(mRRSet);
}
private CmnUserTeam InsertionModelBinding(vCmnUserTeam model, List <vCmnuserTeamDetail> details, UserCommonEntity commonEntity)
{
GenericFactoryEF_CmnUserTeam = new CmnUserTeam_EF();
try
{
Int64 NextID = GenericFactoryEF_CmnUserTeam.getMaxVal_int64("TeamID", "CmnUserTeam");
CmnUserTeam returnModel = new CmnUserTeam();
returnModel.TeamID = model.TeamID == 0 ? NextID : model.TeamID;
returnModel.TeamName = model.TeamName;
returnModel.DepartmentID = model.DepartmentID;
returnModel.CompanyID = model.CompanyID;
if (model.EntityMode == "Inserted")
{
returnModel.CreateBy = commonEntity.loggedUserID;
returnModel.CreateOn = DateTime.Now;
returnModel.CreatePc = HostService.GetIP();
}
else
{
returnModel.UpdateBy = commonEntity.loggedUserID;
returnModel.UpdateOn = DateTime.Now;
returnModel.UpdatePc = HostService.GetIP();
}
returnModel.IsDeleted = model.IsDeleted;
if (returnModel.IsDeleted == true)
{
returnModel.DeleteBy = commonEntity.loggedUserID;
returnModel.DeleteOn = DateTime.Now;
returnModel.DeletePc = HostService.GetIP();
}
NextID = GenericFactoryEF_CmnUserTeam.getMaxVal_int64("TeamDetailID", "CmnuserTeamDetail");
foreach (vCmnuserTeamDetail Item in details)
{
CmnuserTeamDetail entity = new CmnuserTeamDetail();
entity.TeamDetailID = NextID++;
if (Item.EntityMode != "Inserted")
{
entity.TeamDetailID = Item.TeamDetailID;
}
entity.TeamID = returnModel.TeamID;
entity.UserID = Item.UserID;
entity.Sequence = Item.Sequence;
entity.CompanyID = Item.CompanyID;
entity.CreateBy = Item.CreateBy;
entity.CreateOn = DateTime.Now;
entity.CreatePc = HostService.GetIP();
entity.UpdateBy = Item.UpdateBy;
entity.UpdateOn = Item.UpdateOn;
entity.UpdatePc = Item.UpdatePc;
entity.IsDeleted = Item.IsDeleted;
entity.DeleteBy = Item.DeleteBy;
entity.DeleteOn = Item.DeleteOn;
entity.DeletePc = Item.DeletePc;
returnModel.CmnuserTeamDetails.Add(entity);
}
return(returnModel);
}
catch (Exception ex)
{
ex.Message.ToString();
throw;
}
}
