public void SaveLiftingLimit(LiftingLimitDTO liftingLimitDetails) { liftinglimit liftinglimitEntity = new liftinglimit(); AutoMapper.Mapper.Map(liftingLimitDetails, liftinglimitEntity); if (liftingLimitDetails.LiftingLimit_ID == 0) { using (TransactionScope ts = new TransactionScope(TransactionScopeOption.Required, TimeSpan.MaxValue)) { ESalesUnityContainer.Container.Resolve<IGenericRepository<liftinglimit>>().Save(liftinglimitEntity); IList<LiftingLimitDTO> lifitinglimitActivelist = GetLimitList(); if (lifitinglimitActivelist.Count > 0) { foreach (LiftingLimitDTO liftinglimitdata in lifitinglimitActivelist) { if (liftinglimitdata.LiftingLimit_ID != liftinglimitEntity.LiftingLimit_ID && liftinglimitdata.LiftingLimit_BusinessTypeID == liftinglimitEntity.LiftingLimit_BusinessTypeID) { liftinglimit limitEntity = new liftinglimit(); liftinglimitdata.LiftingLimit_IsActive = false; AutoMapper.Mapper.Map(liftinglimitdata, limitEntity); ESalesUnityContainer.Container.Resolve<IGenericRepository<liftinglimit>>().TransactionalUpdate<liftinglimit>(limitEntity); } } ESalesUnityContainer.Container.Resolve<IGenericRepository<liftinglimit>>().SaveChanges(); } List<customermaterialmap> custmoerlist = ESalesUnityContainer.Container.Resolve<IGenericRepository<customermaterialmap>>() .GetQuery().Where(data => data.customer.Cust_BusinessType == liftingLimitDetails.LiftingLimit_BusinessTypeID).ToList(); if (custmoerlist.Count > 0) { foreach (customermaterialmap customermaterialdata in custmoerlist) { customermaterialdata.Cust_Mat_LiftingLimit = liftingLimitDetails.LiftingLimit_Limit; customermaterialdata.Cust_Mat_Timeinterval = liftingLimitDetails.LiftingLimit_Timeinterval; ESalesUnityContainer.Container.Resolve<IGenericRepository<customermaterialmap>>().TransactionalUpdate<customermaterialmap>(customermaterialdata); } ESalesUnityContainer.Container.Resolve<IGenericRepository<customermaterialmap>>().SaveChanges(); } ts.Complete(); } } }
public int UpdateLiftingLimit(LiftingLimitDTO liftingLimitDetails) { liftinglimit LiftingLimitEntity = new liftinglimit(); liftinglimit_history LiftingLimithistoryEntity = new liftinglimit_history(); int LiftingLimitid; using (TransactionScope transactionScope = new TransactionScope()) { AutoMapper.Mapper.Map(liftingLimitDetails, LiftingLimitEntity); ESalesUnityContainer.Container.Resolve<IGenericRepository<liftinglimit>>().Update(LiftingLimitEntity); LiftingLimitid = liftingLimitDetails.LiftingLimit_ID; liftingLimitDetails.LiftingLimit_ID = 0; AutoMapper.Mapper.Map(liftingLimitDetails, LiftingLimithistoryEntity); ESalesUnityContainer.Container.Resolve<IGenericRepository<liftinglimit_history>>().Save(LiftingLimithistoryEntity); transactionScope.Complete(); } return LiftingLimitid; }
public LiftingLimitDTO GetLiftingLimitById(int liftingLimit_ID) { LiftingLimitDTO liftingLimitDetails = new LiftingLimitDTO(); AutoMapper.Mapper.Map(ESalesUnityContainer.Container.Resolve<IGenericRepository<liftinglimit>>() .GetSingle(item => item.LiftingLimit_ID == liftingLimit_ID), liftingLimitDetails); liftingLimitDetails.truckregtype = null; return liftingLimitDetails; }
public void DeleteLiftingLimit(int LiftingLimit_ID) { using (TransactionScope transactionScope = new TransactionScope()) { LiftingLimitDTO liftingLimitDetails = new LiftingLimitDTO(); liftingLimitDetails = ESalesUnityContainer.Container.Resolve<ILiftingLimit>() .GetLiftingLimitById(LiftingLimit_ID); liftingLimitDetails.LiftingLimit_IsActive = false; UpdateLiftingLimit(liftingLimitDetails); transactionScope.Complete(); } }
protected void grdCustCautionLstMaster_RowUpdating(object sender, GridViewUpdateEventArgs e) { LiftingLimitDTO liftingLimitDetails = new LiftingLimitDTO(); liftingLimitDetails = ESalesUnityContainer.Container.Resolve<ILiftingLimit>() .GetLiftingLimitById(Convert.ToInt32(grdCustCautionLstMaster.DataKeys[e.RowIndex].Value)); liftingLimitDetails.Annual_LiftingLimit_Limit = Convert.ToInt32(((TextBox)grdCustCautionLstMaster.Rows[e.RowIndex].FindControl("txtBookingLimit")).Text); liftingLimitDetails.LiftingLimit_Business_Name = ((DropDownList)grdCustCautionLstMaster.Rows[e.RowIndex].FindControl("txtBusinessType")).SelectedItem.Text; liftingLimitDetails.LiftingLimit_BusinessTypeID = Convert.ToInt32(((DropDownList)grdCustCautionLstMaster.Rows[e.RowIndex].FindControl("txtBusinessType")).SelectedValue); liftingLimitDetails.LiftingLimit_LastUpdated = DateTime.Now; liftingLimitDetails.LiftingLimit_Limit = Convert.ToInt32(((DropDownList)grdCustCautionLstMaster.Rows[e.RowIndex].FindControl("ddlLiftingLimit")).SelectedValue); liftingLimitDetails.LiftingLimit_Timeinterval = Convert.ToInt32(((DropDownList)grdCustCautionLstMaster.Rows[e.RowIndex].FindControl("ddlTimeInterval")).SelectedValue); liftingLimitDetails.LiftingLimit_TruckRegType_Id = Convert.ToInt32(((DropDownList)grdCustCautionLstMaster.Rows[e.RowIndex].FindControl("ddlTruckType")).SelectedValue); liftingLimitDetails.LiftingLimit_TruckRegType_Name = ((DropDownList)grdCustCautionLstMaster.Rows[e.RowIndex].FindControl("ddlTruckType")).SelectedItem.Text; liftingLimitDetails.liftinginterval.liftinginterval_Id = Convert.ToInt32(((DropDownList)grdCustCautionLstMaster.Rows[e.RowIndex].FindControl("ddlLiftingLimit")).SelectedValue); //liftingLimitDetails.truckregtype.TruckRegType_IsDeleted = true; //liftingLimitDetails.truckregtype.TruckRegType_Id = Convert.ToInt32(((DropDownList)grdCustCautionLstMaster.Rows[e.RowIndex].FindControl("ddlTruckType")).SelectedValue); UpdateLiftingIntervalByBusinessTypeId(liftingLimitDetails.LiftingLimit_BusinessTypeID, liftingLimitDetails.Annual_LiftingLimit_Limit, liftingLimitDetails.LiftingLimit_Limit, liftingLimitDetails.LiftingLimit_Timeinterval, liftingLimitDetails.LiftingLimit_TruckRegType_Id); int liftingLimitId = ESalesUnityContainer.Container.Resolve<ILiftingLimit>().UpdateLiftingLimit(liftingLimitDetails); ucMessageBoxForGrid.ShowMessage("Lifting Details Saved Successfully"); }
protected void grdCustCautionLstMaster_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals(Globals.GridCommandEvents.ADDNEW)) { if (Page.IsValid) { //To add customer in caution list GridViewRow gvRow = (GridViewRow)((Button)e.CommandSource).NamingContainer; LiftingLimitDTO lifitinglimit = new LiftingLimitDTO(); lifitinglimit.LifitingLimit_Date = DateTime.Now.Date; lifitinglimit.LiftingLimit_IsActive = true; lifitinglimit.LiftingLimit_CreatedDate = DateTime.Now; lifitinglimit.LiftingLimit_LastUpdated = DateTime.Now; lifitinglimit.LiftingLimit_CreatedBy = GetCurrentUserId(); lifitinglimit.LiftingLimit_BusinessTypeID = Convert.ToInt32(((DropDownList)gvRow.FindControl("ddlBusinessType")).SelectedValue); lifitinglimit.LiftingLimit_TruckRegType_Id = Convert.ToInt32(((DropDownList)gvRow.FindControl("ddlTruckType")).SelectedValue); lifitinglimit.Annual_LiftingLimit_Limit = Convert.ToInt32(((TextBox)gvRow.FindControl("tbBookingLimit")).Text); ; lifitinglimit.LiftingLimit_Timeinterval = Convert.ToInt32(((DropDownList)gvRow.FindControl("ddlTimeInterval")).SelectedValue); lifitinglimit.LiftingLimit_Limit = Convert.ToInt32(((DropDownList)gvRow.FindControl("ddlLiftingLimit")).SelectedValue); lifitinglimit.LiftingLimit_IntervalId = Convert.ToInt32(((DropDownList)gvRow.FindControl("ddlTimeInterval")).SelectedValue); ESalesUnityContainer.Container.Resolve<ILiftingLimit>().SaveLiftingLimit(lifitinglimit); GetActivelimit(); PopulateLiftingLimitHistory(); ucMessageBoxForGrid.ShowMessage(Resources.Messages.Liftinglimitadd); } } }