public ValidationMsg Create(SysArticle objSysArticle, int userid) { var vmMsg = new ValidationMsg(); try { var tblSysArticle = new Sys_Article { ArticleID = objSysArticle.ArticleID, ArticleName = objSysArticle.ArticleName, ArticleNo = objSysArticle.ArticleNo, ArticleColor = objSysArticle.ArticleColor, ArticleChallanNo = objSysArticle.ArticleChallanNo, IsActive = objSysArticle.IsActive == "Active", ArticleCategory = objSysArticle.ArticleCategory, Remarks = objSysArticle.Remarks, SetOn = DateTime.Now, SetBy = userid, IPAddress = GetIPAddress.LocalIPAddress() }; _context.Sys_Article.Add(tblSysArticle); _context.SaveChanges(); ArticleId = tblSysArticle.ArticleID; vmMsg.Type = Enums.MessageType.Success; vmMsg.Msg = "Saved Successfully."; } catch (Exception ex) { vmMsg.Type = Enums.MessageType.Error; vmMsg.Msg = "Failed to Save."; } return(vmMsg); }
public ActionResult DeletedTargetYear(string yearId) { int yearid = Convert.ToInt16(yearId); _vmMsg = Dalobject.DeletedTargetYear(yearid); return(Json(new { msg = _vmMsg })); }
public ValidationMsg Create(SysGradeRange objSysGradeRange) { var vmMsg = new ValidationMsg(); try { var tblSysGradeRange = new Sys_GradeRange { GradeRangeID = objSysGradeRange.GradeRangeID, GradeRangeName = objSysGradeRange.GradeRangeName, Description = objSysGradeRange.Description, IsActive = objSysGradeRange.IsActive, IsDelete = objSysGradeRange.IsDelete, SetOn = DateTime.Now, SetBy = 25, ModifiedOn = DateTime.Now, ModifiedBy = 25, IPAddress = string.Empty }; _context.Sys_GradeRange.Add(tblSysGradeRange); _context.SaveChanges(); vmMsg.Type = Enums.MessageType.Success; vmMsg.Msg = "Save Successfully."; } catch (Exception ex) { vmMsg.Type = Enums.MessageType.Error; vmMsg.Msg = "Failed to update."; } return(vmMsg); }
public ValidationMsg Update(SysLeatherType objSysLeatherType, int userId) { _vmMsg = new ValidationMsg(); try { var leatherType = _context.Sys_LeatherType.FirstOrDefault(s => s.LeatherTypeID == objSysLeatherType.LeatherTypeID); if (leatherType != null) { leatherType.LeatherTypeName = objSysLeatherType.LeatherTypeName; leatherType.Description = objSysLeatherType.Description; leatherType.IsActive = objSysLeatherType.IsActive == "Active"; leatherType.ModifiedOn = DateTime.Now; leatherType.ModifiedBy = userId; } _context.SaveChanges(); _vmMsg.Type = Enums.MessageType.Update; _vmMsg.Msg = "Updated Successfully."; } catch (Exception ex) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to update."; } return(_vmMsg); }
public ActionResult DeletedYearMonthSchedulePurchase(string SchedulePurchaseID, string RecordStatus) { long schedulePurchaseID = Convert.ToInt64(SchedulePurchaseID); _vmMsg = Dalobject.DeletedYearMonthSchedulePurchase(schedulePurchaseID, RecordStatus); return(Json(new { msg = _vmMsg })); }
public ValidationMsg Delete(string currencyId, int userid) { var currencyid = string.IsNullOrEmpty(currencyId) ? 0 : Convert.ToInt32(currencyId); var vmMsg = new ValidationMsg(); try { var sysSource = _context.Sys_Currency.FirstOrDefault(s => s.CurrencyID == currencyid); if (sysSource != null) { sysSource.IsDelete = true; sysSource.ModifiedOn = DateTime.Now; sysSource.ModifiedBy = userid; } _context.SaveChanges(); vmMsg.Type = Enums.MessageType.Success; vmMsg.Msg = "Deleted Successfully."; } catch (Exception ex) { vmMsg.Type = Enums.MessageType.Error; vmMsg.Msg = "Failed to record updated."; } return(vmMsg); }
public ValidationMsg Delete(string leatherTypeID, int userid) { var typeId = string.IsNullOrEmpty(leatherTypeID) ? 0 : Convert.ToInt32(leatherTypeID); var vmMsg = new ValidationMsg(); try { var sysType = _context.Sys_LeatherType.FirstOrDefault(s => s.LeatherTypeID == typeId); if (sysType != null) { _context.Sys_LeatherType.Remove(sysType); } _context.SaveChanges(); vmMsg.Type = Enums.MessageType.Success; vmMsg.Msg = "Deleted Successfully."; } catch (SqlException se) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Cannot delete because it has already used."; } catch (Exception ex) { vmMsg.Type = Enums.MessageType.Error; vmMsg.Msg = "Failed to record updated."; } return(vmMsg); }
public ValidationMsg Delete(string BankID) { var itemid = string.IsNullOrEmpty(BankID) ? 0 : Convert.ToInt32(BankID); var vmMsg = new ValidationMsg(); try { var itemList = _context.Sys_Branch.Where(m => m.BankID == itemid).ToList(); if (itemList.Count > 0) { vmMsg.Type = Enums.MessageType.Error; vmMsg.Msg = "Child Record Found."; } else { var sysBank = _context.Sys_Bank.FirstOrDefault(s => s.BankID == itemid); _context.Sys_Bank.Remove(sysBank); _context.SaveChanges(); vmMsg.Type = Enums.MessageType.Success; vmMsg.Msg = "Deleted Successfully."; } } catch (Exception ex) { vmMsg.Type = Enums.MessageType.Error; vmMsg.Msg = "Failed to Delete."; } return(vmMsg); }
public ValidationMsg CloseLoanData(EXPBankLoan model, int userid) { _vmMsg = new ValidationMsg(); try { using (var tx = new TransactionScope()) { using (_context) { if (model.expBankLoanList[0].BankLoanID != 0 && model.RecordStatus == "NCF") { foreach (var bankLoan in model.expBankLoanList) { EXP_BankLoan tblBankLoan = SetToBankLoanEntityObject(bankLoan, userid); tblBankLoan.RunningStatus = "CLS"; _context.SaveChanges(); } } _vmMsg.Type = Enums.MessageType.Success; _vmMsg.Msg = "Loan Closed Successfully."; } } } catch { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to Close Loan."; } return(_vmMsg); }
public ActionResult Save(EXPLCOpening dataSet) { _userId = Convert.ToInt32(Session["UserID"]); _vmMsg = objDalExpLCOpening.Save(dataSet, _userId); return(Json(new { msg = _vmMsg })); }
public DalLcmPackingList() { _context = new BLC_DEVEntities(); _unit = new UnitOfWork(); _validationMsg = new ValidationMsg(); save = false; }
public EXPLCOpeningController() { _vmMsg = new ValidationMsg(); objDalExpLCOpening = new DalEXPLCOpening(); objExpPI = new DalExportPI(); repository = new UnitOfWork(); }
public ActionResult DeletedAgentCom(string AgentComID) { long?agentComID = Convert.ToInt64(AgentComID); _vmMsg = Dalobject.DeletedAgentCom(agentComID); return(Json(new { msg = _vmMsg })); }
public ValidationMsg Update(SysArticle objSysArticle, int userid) { var vmMsg = new ValidationMsg(); try { var sysArticle = _context.Sys_Article.FirstOrDefault(s => s.ArticleID == objSysArticle.ArticleID); if (sysArticle != null) { sysArticle.ArticleName = objSysArticle.ArticleName; sysArticle.ArticleNo = objSysArticle.ArticleNo; sysArticle.ArticleColor = objSysArticle.ArticleColor; sysArticle.ArticleChallanNo = objSysArticle.ArticleChallanNo; sysArticle.ArticleCategory = objSysArticle.ArticleCategory; sysArticle.Remarks = objSysArticle.Remarks; sysArticle.IsActive = objSysArticle.IsActive == "Active"; sysArticle.ModifiedOn = DateTime.Now; sysArticle.ModifiedBy = userid; } _context.SaveChanges(); vmMsg.Type = Enums.MessageType.Update; vmMsg.Msg = "Updated Successfully."; } catch (Exception ex) { vmMsg.Type = Enums.MessageType.Error; vmMsg.Msg = "Failed to Update."; } return(vmMsg); }
public ValidationMsg Update(SysSource objSysSource, int userid) { var vmMsg = new ValidationMsg(); try { var sysSource = _context.Sys_Source.FirstOrDefault(s => s.SourceID == objSysSource.SourceID); if (sysSource != null) { sysSource.SourceName = objSysSource.SourceName; sysSource.SourceAddress = objSysSource.SourceAddress; sysSource.ContactPerson = objSysSource.ContactPerson; sysSource.ContactNumber = objSysSource.ContactNumber; sysSource.IsActive = objSysSource.IsActive == "Active";// Convert.ToBoolean(objSysSource.IsActive); sysSource.ModifiedOn = DateTime.Now; sysSource.ModifiedBy = userid; } _context.SaveChanges(); vmMsg.Type = Enums.MessageType.Update; vmMsg.Msg = "Updated Successfully."; } catch (Exception ex) { vmMsg.Type = Enums.MessageType.Error; vmMsg.Msg = "Failed to Update."; } return(vmMsg); }
public ValidationMsg CheckedEXPBDV(string BDVID, int userid) { _vmMsg = new ValidationMsg(); try { using (var tx = new TransactionScope()) { using (_context) { long bdvId = Convert.ToInt64(BDVID); var originalEntityCI = _context.EXP_BankDebitVoucher.First(m => m.BDVID == bdvId); originalEntityCI.RecordStatus = "CHK"; originalEntityCI.ModifiedBy = userid; originalEntityCI.ModifiedOn = DateTime.Now; _context.SaveChanges(); tx.Complete(); _vmMsg.Type = Enums.MessageType.Success; _vmMsg.Msg = "Checked Successfully."; } } } catch { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to Checked."; } return(_vmMsg); }
public ActionResult Save(EXPDeliveryChallan dataSet) { _userId = Convert.ToInt32(Session["UserID"]); objValMssg = objDalDeliveryChallan.Save(dataSet, _userId); return(Json(new { msg = objValMssg })); }
public ActionResult Save(CnFBill dataSet) { _userId = Convert.ToInt32(Session["UserID"]); objValMssg = objDalLCMCnFBillInfo.SaveLCM_CnFBill(dataSet, _userId, "CnFBills/CnFBills"); return(Json(new { msg = objValMssg })); }
public ActionResult DeletedCrustLeatherQC(string CrustLeatherQCID) { long crustLeatherQCID = Convert.ToInt64(CrustLeatherQCID); _vmMsg = Dalobject.DeletedCrustLeatherQC(crustLeatherQCID); return(Json(new { msg = _vmMsg })); }
public ActionResult DeletedIssueItem(string itemIssueId) { int itemissueId = string.IsNullOrEmpty(itemIssueId) ? 0 : Convert.ToInt16(itemIssueId); _vmMsg = DalObj.DeletedIssueItem(itemissueId); return(Json(new { msg = _vmMsg })); }
public ValidationMsg Save(SysLeatherType objSysLeatherType, int userId) { _vmMsg = new ValidationMsg(); try { var tblSysLeatherType = new Sys_LeatherType { LeatherTypeID = objSysLeatherType.LeatherTypeID, LeatherTypeName = objSysLeatherType.LeatherTypeName, Description = objSysLeatherType.Description, IsActive = objSysLeatherType.IsActive == "Active", IsDelete = false, SetOn = DateTime.Now, SetBy = Convert.ToInt32(25), ModifiedOn = DateTime.Now, ModifiedBy = userId, IPAddress = string.Empty }; _context.Sys_LeatherType.Add(tblSysLeatherType); _context.SaveChanges(); _vmMsg.Type = Enums.MessageType.Success; _vmMsg.Msg = "Saved Successfully."; } catch (Exception ex) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to save."; } return(_vmMsg); }
public ActionResult DeletedReceiveChallan(string ReceiveChallanID) { int receiveChallanID = Convert.ToInt32(ReceiveChallanID); _vmMsg = Dalobject.DeletedReceiveChallan(receiveChallanID); return(Json(new { msg = _vmMsg })); }
public ValidationMsg Delete(string leatherStatusId, int userid) { var leatherStatusIds = string.IsNullOrEmpty(leatherStatusId) ? 0 : Convert.ToInt32(leatherStatusId); var vmMsg = new ValidationMsg(); try { var leatherStatus = _context.Sys_LeatherStatus.FirstOrDefault(s => s.LeatherStatusID == leatherStatusIds); if (leatherStatus != null) { leatherStatus.IsDelete = true; leatherStatus.ModifiedOn = DateTime.Now; leatherStatus.ModifiedBy = userid; } _context.SaveChanges(); vmMsg.Type = Enums.MessageType.Success; vmMsg.Msg = "Deleted Successfully."; } catch (Exception ex) { vmMsg.Type = Enums.MessageType.Error; vmMsg.Msg = "Failed to record updated."; } return(vmMsg); }
public ActionResult DeletedReceiveItem(string TransItemID) { long?transItemID = Convert.ToInt32(TransItemID); _vmMsg = Dalobject.DeletedReceiveItem(transItemID); return(Json(new { msg = _vmMsg })); }
public ActionResult Save(EXP_LCRetirement dataSet) { _userId = Convert.ToInt32(Session["UserID"]); objValMssg = objDalEXPLCRetirement.SaveLCM_LCRetirement(dataSet, _userId, "EXPLCRetirement/EXPLCRetirement"); return(Json(new { msg = objValMssg })); }
public ActionResult Save(EXP_CnFBill dataSet) { _userId = Convert.ToInt32(Session["UserID"]); _vmMsg = objDalEXPCnfBill.Save(dataSet, _userId, "EXPCnfBill/EXPCnfBill"); return(Json(new { msg = _vmMsg })); }
public ActionResult DeletedPeriod(string periodId, string RecordStatus) { int periodid = Convert.ToInt16(periodId); _vmMsg = Dalobject.DeletedPeriod(periodid, RecordStatus); return(Json(new { msg = _vmMsg })); }
public ValidationMsg Create(SysSource objSysSource, int userid) { var vmMsg = new ValidationMsg(); try { var tblSysSource = new Sys_Source { SourceID = objSysSource.SourceID, SourceName = objSysSource.SourceName, SourceAddress = objSysSource.SourceAddress, ContactPerson = objSysSource.ContactPerson, ContactNumber = objSysSource.ContactNumber, IsActive = objSysSource.IsActive == "Active", IsDelete = objSysSource.IsDelete, SetOn = DateTime.Now, SetBy = userid, IPAddress = string.Empty }; _context.Sys_Source.Add(tblSysSource); _context.SaveChanges(); SourceId = tblSysSource.SourceID; vmMsg.Type = Enums.MessageType.Success; vmMsg.Msg = "Saved Successfully."; } catch (Exception ex) { vmMsg.Type = Enums.MessageType.Error; vmMsg.Msg = "Failed to Save."; } return(vmMsg); }
public ValidationMsg Delete(SysGradeRange objSysGradeRange) { var vmMsg = new ValidationMsg(); try { var tblSysGradeRange = _context.Sys_GradeRange.FirstOrDefault(s => s.GradeRangeID == objSysGradeRange.GradeRangeID); if (tblSysGradeRange != null) { tblSysGradeRange.GradeRangeName = objSysGradeRange.GradeRangeName; tblSysGradeRange.Description = objSysGradeRange.Description; tblSysGradeRange.IsActive = Convert.ToBoolean(objSysGradeRange.IsActive); tblSysGradeRange.IsDelete = true; tblSysGradeRange.ModifiedOn = DateTime.Now; tblSysGradeRange.ModifiedBy = 27; } _context.SaveChanges(); vmMsg.Type = Enums.MessageType.Success; vmMsg.Msg = "Deleted Successfully."; } catch (Exception ex) { vmMsg.Type = Enums.MessageType.Error; vmMsg.Msg = "Failed to update."; } return(vmMsg); }
public ValidationMsg Update(SysLocation objSysLocation, int userid) { _vmMsg = new ValidationMsg(); try { var location = _context.Sys_Location.FirstOrDefault(s => s.LocationID == objSysLocation.LocationID); if (location != null) { location.LocationName = objSysLocation.LocationName; location.LocationAddress = objSysLocation.LocationAddress; location.ContactPerson = objSysLocation.ContactPerson; location.ContactNumber = objSysLocation.ContactNumber; location.IsActive = objSysLocation.IsActive == "Active"; location.ModifiedOn = DateTime.Now; location.ModifiedBy = userid; } _context.SaveChanges(); _vmMsg.Type = Enums.MessageType.Update; _vmMsg.Msg = "Updated Successfully."; } catch (Exception ex) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to Update."; } return(_vmMsg); }