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);
}
