private void Init()
{
BindData();
TblBranch branch = new TblBranch();
DataTable branchTable = branch.SelectAll();
new XtraUtils.LookupEditBuilder.BranchCodeLookupEditBuilder(branchTable, lkpEdtBranchCode.Properties);
TblCaseType casetype = new TblCaseType();
DataTable caseTypeTable = casetype.SelectAll();
new XtraUtils.LookupEditBuilder.CaseTypeLookupEditBuilder(caseTypeTable, lkpEdtCaseType.Properties);
TblCaseCategory category = new TblCaseCategory();
DataTable categoryTable = category.SelectAll();
new XtraUtils.LookupEditBuilder.CaseCategoryLookupEditBuilder(categoryTable, lkpEdtCategory.Properties);
TblDepartment department = new TblDepartment();
DataTable deptTable = department.SelectAll();
new XtraUtils.LookupEditBuilder.DepartmentLookupEditBuilder(deptTable, lkpEdtDeptID.Properties);
new XtraUtils.LookupEditBuilder.EmployeeIDLookupEditBuilder(lkpEdtStaff.Properties, false);
new XtraUtils.LookupEditBuilder.DepartmentLookupEditBuilder(deptTable, lkpEdtDeptAssignedID.Properties);
}
private void Init()
{
BindData();
TblBranch branch = new TblBranch();
DataTable branchTable = branch.SelectAll();
new XtraUtils.LookupEditBuilder.BranchCodeLookupEditBuilder(branchTable, lkpEdtBranchCode.Properties);
TblCaseType casetype = new TblCaseType();
DataTable caseTypeTable = casetype.SelectAll();
new XtraUtils.LookupEditBuilder.CaseTypeLookupEditBuilder(caseTypeTable, lkpEdtCaseType.Properties);
// TblMember member = new TblMember();
// DataTable memberTable = member.SelectAll();
// new XtraUtils.LookupEditBuilder.MemberIDLookupEditBuilder(memberTable, lkpEdtMemberID.Properties);
TblCaseCategory category = new TblCaseCategory();
DataTable categoryTable = category.SelectAll();
new XtraUtils.LookupEditBuilder.CaseCategoryLookupEditBuilder(categoryTable, lkpEdtCategory.Properties);
TblDepartment department = new TblDepartment();
DataTable deptTable = department.SelectAll();
new XtraUtils.LookupEditBuilder.DepartmentLookupEditBuilder(deptTable, lkpEdtDeptID.Properties);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["BranchEditID"] != null)
{
TblBranch obj = new TblBranch(Session["BranchEditID"]);
txtBranchName.Text = obj.BranchName;
txtPhoneNo.Text = obj.BPhoneNo;
txtAddress.Text = obj.BAddress;
ddlStatus.SelectedValue = obj.IsActive.ToString();
}
}
}
public static bool BlockMembershipID(int numberOfNonMemberID, int numberOfMemberID, string strBranchCode)
{
ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider();
TblCompany sqlCompany = new TblCompany();
TblBranch sqlBranch = new TblBranch();
try
{
sqlCompany.MainConnectionProvider = connProvider;
sqlBranch.MainConnectionProvider = connProvider;
connProvider.OpenConnection();
connProvider.BeginTransaction("BlockMembershipID");
if (numberOfNonMemberID > 0)
{
sqlCompany.UpdateBlockNonMembershipID(numberOfNonMemberID);
}
if (numberOfMemberID > 0)
{
sqlBranch.UpdateBlockMembershipID(strBranchCode, numberOfMemberID);
}
connProvider.CommitTransaction();
return(true);
}
catch (Exception)
{
connProvider.RollbackTransaction("BlockMembershipID");
throw;
}
finally
{
if (connProvider.CurrentTransaction != null)
{
connProvider.CurrentTransaction.Dispose();
}
if (connProvider.DBConnection != null)
{
if (connProvider.DBConnection.State == ConnectionState.Open)
{
connProvider.DBConnection.Close();
}
connProvider.DBConnection.Dispose();
}
sqlCompany.Dispose();
sqlBranch.Dispose();
}
}
public static void CurrentLastMembershipID(string strTerminalBranch, ref int lastNonMemberID, ref int lastMemberID)
{
ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider();
TblCompany sqlCompany = new TblCompany();
TblBranch sqlBranch = new TblBranch();
try
{
sqlCompany.MainConnectionProvider = connProvider;
sqlBranch.MainConnectionProvider = connProvider;
connProvider.OpenConnection();
connProvider.BeginTransaction("LastMembershipID");
DataTable companyTable = sqlCompany.SelectAll();
sqlBranch.StrBranchCode = strTerminalBranch;
DataTable branchTable = sqlBranch.SelectOne();
connProvider.CommitTransaction();
lastNonMemberID = ACMS.Convert.ToInt32(companyTable.Rows[0]["nNonMembershipNo"]);
lastMemberID = ACMS.Convert.ToInt32(branchTable.Rows[0]["nMembershipNo"]);
return;
}
catch (Exception)
{
connProvider.RollbackTransaction("ResetMembershipID");
throw;
}
finally
{
if (connProvider.CurrentTransaction != null)
{
connProvider.CurrentTransaction.Dispose();
}
if (connProvider.DBConnection != null)
{
if (connProvider.DBConnection.State == ConnectionState.Open)
{
connProvider.DBConnection.Close();
}
connProvider.DBConnection.Dispose();
}
sqlCompany.Dispose();
sqlBranch.Dispose();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (helper.ExecutePlainQuery("select * from tbl_Branches where BranchName='" + txtBranchName.Text + "'").Rows.Count > 0 && String.IsNullOrEmpty(Convert.ToString(Session["BranchEditID"])))
{
lblmsg.Text = helper.DisplayNotificationMessage(msgDiv, txtBranchName.Text + " already exists!", "alert alert-danger alert-icon alert-dismissible", icon, "icon mdi mdi-check");
}
else
{
string msg = "Branch has been added!";
TblBranch obj = new TblBranch();
obj.IsNew = true;
if (Session["BranchEditID"] != null)
{
obj.IsNew = false;
obj = new TblBranch(Session["BranchEditID"]);
msg = "Branch has been updated!";
}
obj.BranchName = txtBranchName.Text;
obj.BPhoneNo = txtPhoneNo.Text;
obj.BAddress = txtAddress.Text;
obj.IsActive = Convert.ToInt32(ddlStatus.SelectedValue);
obj.Save();
lblmsg.Text = helper.DisplayNotificationMessage(msgDiv, msg, "alert alert-success alert-icon alert-dismissible", icon, "icon mdi mdi-check");
helper.ClearInputs(Page.Controls);
Session["BranchEditID"] = null;
}
}
catch (Exception ex)
{
lblmsg.Text = helper.DisplayNotificationMessage(msgDiv, ex.ToString(), "alert alert-danger alert-icon alert-dismissible", icon, "icon mdi mdi-close-circle-o");
}
}
public void DeleteBranch(TblBranch bra)
{
bra.Del = 0;
_db.TblBranches.Update(bra);
_db.SaveChanges();
}
public void UpdateBranch(TblBranch bra)
{
_db.TblBranches.Update(bra);
_db.SaveChanges();
}
public void CreateBranch(TblBranch bra)
{
_db.TblBranches.Add(bra);
_db.SaveChanges();
}
public TblBranch GetBranchById(int id)
{
TblBranch bra = _db.TblBranches.FirstOrDefault(x => x.Id == id);
return(bra);
}
public TblStockInformation AddStockInformation(ERPContext context, TblInvoiceMasterReturn invoiceReturn, TblBranch _branch, TblProduct _product, decimal?qty, decimal?rate)
{
try
{
//using(ERPContext context=new ERPContext())
//{
var _stockInformation = new TblStockInformation
{
BranchId = _branch.BranchId,
BranchCode = _branch.BranchCode,
ShiftId = invoiceReturn.ShiftId,
VoucherNo = invoiceReturn.VoucherNo,
VoucherTypeId = invoiceReturn.VoucherTypeId,
InvoiceNo = invoiceReturn.InvoiceReturnNo,
ProductId = _product.ProductId,
ProductCode = _product.ProductCode,
OutwardQty = qty,
Rate = rate
};
context.TblStockInformation.Add(_stockInformation);
if (context.SaveChanges() > 0)
{
return(_stockInformation);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
private void InitLookupEdit()
{
myBranch = new TblBranch();
dtblBranchLookupEdit = myBranch.SelectAllForLookupEdit();
}
public string ConvertMember(DataRow rowMember, User aUser)
{
ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider();
TblMember sqlMember = new TblMember();
TblBranch sqlBranch = new TblBranch();
TblAudit sqlAudit = new TblAudit();
TblCardRequest sqlCardRequest = new TblCardRequest();
try
{
sqlBranch.MainConnectionProvider = connProvider;
sqlMember.MainConnectionProvider = connProvider;
sqlAudit.MainConnectionProvider = connProvider;
sqlCardRequest.MainConnectionProvider = connProvider;
connProvider.OpenConnection();
connProvider.BeginTransaction("ConvertMember");
sqlBranch.StrBranchCode = aUser.StrBranchCode();
sqlBranch.IncOne();
string newMembershipID = aUser.StrBranchCode().TrimEnd() + sqlBranch.NMembershipNo;
sqlMember.StrBranchCode = aUser.StrBranchCode();
sqlMember.ConvertMember(rowMember["strMembershipID"].ToString(), newMembershipID);
sqlMember.ConvertMemberPurchase(rowMember["strMembershipID"].ToString(), newMembershipID);
sqlAudit.UpdateAllWstrReferenceLogic(newMembershipID, rowMember["strMembershipID"].ToString());
sqlAudit.NAuditTypeID = ACMSLogic.AuditTypeID.MemberRecord;
sqlAudit.NEmployeeID = aUser.NEmployeeID();
sqlAudit.StrAuditEntry = "Convert member from " + rowMember["strMembershipID"].ToString() + " to " + newMembershipID;
sqlAudit.StrReference = newMembershipID;
sqlAudit.DtDate = DateTime.Now;
sqlAudit.Insert();
//Request print for convert non member to member
//sqlCardRequest.NEmployeeID = aUser.NEmployeeID();
//sqlCardRequest.NStatusID = (int)CardStatusType.RequestPrint;
//sqlCardRequest.StrBranchCode = aUser.StrBranchCode();
//sqlCardRequest.StrMembershipID = newMembershipID;
//sqlCardRequest.DtLastEditDate = DateTime.Now;
//sqlCardRequest.Insert();
////Audit trail for request print
//sqlAudit.NAuditTypeID = ACMSLogic.AuditTypeID.MemberCard;
//sqlAudit.NEmployeeID = aUser.NEmployeeID();
//sqlAudit.StrAuditEntry = "New member card request when create convert member.";
//sqlAudit.StrReference = newMembershipID;
//sqlAudit.DtDate = DateTime.Now;
//sqlAudit.Insert();
connProvider.CommitTransaction();
return(newMembershipID);
}
catch (Exception)
{
connProvider.RollbackTransaction("ConvertMember");
throw;
}
finally
{
if (connProvider.CurrentTransaction != null)
{
connProvider.CurrentTransaction.Dispose();
}
if (connProvider.DBConnection != null)
{
if (connProvider.DBConnection.State == ConnectionState.Open)
{
connProvider.DBConnection.Close();
}
connProvider.DBConnection.Dispose();
}
sqlBranch.Dispose();
sqlMember.Dispose();
sqlAudit.Dispose();
sqlCardRequest.Dispose();
}
}
public TblVoucherDetail AddVoucherDetails(ERPContext context, TblInvoiceMasterReturn invoiceReturn, TblBranch _branch, TblVoucherMaster _voucherMaster, TblAccountLedger _accountLedger, decimal?productRate, bool isFromInvoiceDetials = true)
{
try
{
//using(ERPContext context=new ERPContext())
//{
var _voucherDetail = new TblVoucherDetail
{
VoucherMasterId = _voucherMaster.VoucherMasterId,
VoucherDetailDate = _voucherMaster.VoucherDate,
BranchId = _branch.BranchId,
BranchCode = invoiceReturn.BranchCode,
BranchName = invoiceReturn.BranchName
};
if (isFromInvoiceDetials)
{
_voucherDetail.FromLedgerId = invoiceReturn.LedgerId;
_voucherDetail.FromLedgerCode = invoiceReturn.LedgerCode;
_voucherDetail.FromLedgerName = invoiceReturn.LedgerName;
}
//To ledger clarifiaction on selecion of product
_voucherDetail.ToLedgerId = _accountLedger.LedgerId;
_voucherDetail.ToLedgerCode = _accountLedger.LedgerCode;
_voucherDetail.ToLedgerName = _accountLedger.LedgerName;
_voucherDetail.Amount = productRate;
_voucherDetail.TransactionType = _accountLedger.CrOrDr;
_voucherDetail.CostCenter = _accountLedger.BranchCode;
_voucherDetail.ServerDate = DateTime.Now;
_voucherDetail.Narration = $"Sales Invoice {_accountLedger.LedgerName} A /c: {_voucherDetail.TransactionType}";
context.TblVoucherDetail.Add(_voucherDetail);
if (context.SaveChanges() > 0)
{
return(_voucherDetail);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
private TblVoucherDetail AddVoucherDetails(ERPContext context, TblPurchaseInvoice invoice, TblBranch _branch, TblVoucherMaster _voucherMaster, TblAccountLedger _accountLedger, decimal?productRate, bool isFromInvoiceDetials = true)
{
try
{
//using(ERPContext context=new ERPContext())
//{
var _voucherDetail = new TblVoucherDetail();
_voucherDetail.VoucherMasterId = _voucherMaster.VoucherMasterId;
_voucherDetail.VoucherDetailDate = _voucherMaster.VoucherDate;
_voucherDetail.BranchId = _branch.BranchId;
_voucherDetail.BranchCode = invoice.BranchCode;
_voucherDetail.BranchName = invoice.BranchName;
if (isFromInvoiceDetials)
{
_voucherDetail.FromLedgerId = invoice.LedgerId;
_voucherDetail.FromLedgerCode = invoice.LedgerCode;
_voucherDetail.FromLedgerName = invoice.LedgerName;
}
//To ledger clarifiaction on selecion of product
_voucherDetail.ToLedgerId = _accountLedger.LedgerId;
_voucherDetail.ToLedgerCode = _accountLedger.LedgerCode;
_voucherDetail.ToLedgerName = _accountLedger.LedgerName;
_voucherDetail.Amount = productRate;
_voucherDetail.TransactionType = _accountLedger.CrOrDr;
_voucherDetail.CostCenter = _accountLedger.BranchCode;
_voucherDetail.ServerDate = DateTime.Now;
_voucherDetail.Narration = $"Sales Invoice {_accountLedger.LedgerName} A /c: {_voucherDetail.TransactionType}";
context.TblVoucherDetail.Add(_voucherDetail);
if (context.SaveChanges() > 0)
{
return(_voucherDetail);
}
#region comment
//var _voucherDetail = new TblVoucherDetail();
//_voucherDetail.VoucherMasterId = _voucherMaster.VoucherMasterId;
//_voucherDetail.VoucherDetailDate = _voucherMaster.VoucherDate;
//_voucherDetail.BranchId = _branch.BranchId;
//_voucherDetail.BranchCode = invoice.BranchCode;
//_voucherDetail.BranchName = invoice.BranchName;
//_voucherDetail.FromLedgerId = invoice.LedgerId;
//_voucherDetail.FromLedgerCode = invoice.LedgerCode;
//_voucherDetail.FromLedgerName = invoice.LedgerName;
////To ledger clarifiaction on selecion of product
//_voucherDetail.ToLedgerId = _accountLedger.LedgerId;
//_voucherDetail.ToLedgerCode = _accountLedger.LedgerCode;
//_voucherDetail.ToLedgerName = _accountLedger.LedgerName;
//_voucherDetail.Amount = invdtl.Rate;
//_voucherDetail.TransactionType = _accountLedger.CrOrDr;
//_voucherDetail.CostCenter = _accountLedger.BranchCode;
//_voucherDetail.ServerDate = DateTime.Now;
//_voucherDetail.Narration = "Sales Invoice Product group A/c:" + _voucherDetail.TransactionType;
//repo.TblVoucherDetail.Add(_voucherDetail);
//repo.SaveChanges();
#endregion
return(null);
// }
}
catch (Exception ex)
{
throw ex;
}
}
public TblVoucherDetail AddVoucherDetails(ERPContext context, TblBankReceiptMaster bankReceiptMaster, TblBranch _branch, TblVoucherMaster _voucherMaster, TblAccountLedger _accountLedger, decimal?productRate, decimal?ledgerId, string ledgerCode, bool isFromCashDetials = true)
{
try
{
var _voucherDetail = new TblVoucherDetail();
var ledgerName = GetAccountLedgerList().Where(al => al.LedgerCode == ledgerCode).FirstOrDefault();
_voucherDetail.VoucherMasterId = _voucherMaster.VoucherMasterId;
_voucherDetail.VoucherDetailDate = _voucherMaster.VoucherDate;
_voucherDetail.BranchId = _branch.BranchId;
_voucherDetail.BranchCode = bankReceiptMaster.BranchCode;
_voucherDetail.BranchName = bankReceiptMaster.BranchName;
if (isFromCashDetials == true)
{
_voucherDetail.FromLedgerId = bankReceiptMaster.BankLedgerId;
_voucherDetail.FromLedgerCode = bankReceiptMaster.BankLedgerCode;
_voucherDetail.FromLedgerName = bankReceiptMaster.BankLedgerName;
_voucherDetail.ToLedgerId = ledgerName.LedgerId;
_voucherDetail.ToLedgerCode = ledgerCode;
_voucherDetail.ToLedgerName = ledgerName.LedgerName;
_voucherDetail.Amount = productRate;
_voucherDetail.TransactionType = "Debit";
_voucherDetail.CostCenter = bankReceiptMaster.BranchCode;
_voucherDetail.ServerDate = DateTime.Now;
_voucherDetail.Narration = "Bank Receipt Detail";
}
//To ledger clarifiaction on selecion of product
else
{
_voucherDetail.FromLedgerId = ledgerName.LedgerId;
_voucherDetail.FromLedgerCode = ledgerCode;
_voucherDetail.FromLedgerName = ledgerName.LedgerName;
_voucherDetail.ToLedgerId = bankReceiptMaster.BankLedgerId;
_voucherDetail.ToLedgerCode = bankReceiptMaster.BankLedgerCode;
_voucherDetail.ToLedgerName = bankReceiptMaster.BankLedgerName;
_voucherDetail.Amount = productRate;
_voucherDetail.TransactionType = "Credit";
_voucherDetail.CostCenter = bankReceiptMaster.BranchCode;
_voucherDetail.ServerDate = DateTime.Now;
_voucherDetail.Narration = "Bank Receipt Detail";
}
context.TblVoucherDetail.Add(_voucherDetail);
if (context.SaveChanges() > 0)
{
return(_voucherDetail);
}
#region comment
//var _voucherDetail = new TblVoucherDetail();
//_voucherDetail.VoucherMasterId = _voucherMaster.VoucherMasterId;
//_voucherDetail.VoucherDetailDate = _voucherMaster.VoucherDate;
//_voucherDetail.BranchId = _branch.BranchId;
//_voucherDetail.BranchCode = invoice.BranchCode;
//_voucherDetail.BranchName = invoice.BranchName;
//_voucherDetail.FromLedgerId = invoice.LedgerId;
//_voucherDetail.FromLedgerCode = invoice.LedgerCode;
//_voucherDetail.FromLedgerName = invoice.LedgerName;
////To ledger clarifiaction on selecion of product
//_voucherDetail.ToLedgerId = _accountLedger.LedgerId;
//_voucherDetail.ToLedgerCode = _accountLedger.LedgerCode;
//_voucherDetail.ToLedgerName = _accountLedger.LedgerName;
//_voucherDetail.Amount = invdtl.Rate;
//_voucherDetail.TransactionType = _accountLedger.CrOrDr;
//_voucherDetail.CostCenter = _accountLedger.BranchCode;
//_voucherDetail.ServerDate = DateTime.Now;
//_voucherDetail.Narration = "Sales Invoice Product group A/c:" + _voucherDetail.TransactionType;
//repo.TblVoucherDetail.Add(_voucherDetail);
//repo.SaveChanges();
#endregion
return(null);
// }
}
catch (Exception ex)
{
throw ex;
}
}
public TblVoucherMaster AddVoucherMaster(ERPContext context, TblBankReceiptMaster bankReceiptMaster, TblBranch branch, decimal?voucherTypeId, string paymentType)
{
try
{
decimal shifId = Convert.ToDecimal(new UserManagmentHelper().GetShiftId(bankReceiptMaster.UserId ?? 0, null));
var _voucherMaster = new TblVoucherMaster
{
BranchCode = bankReceiptMaster.BranchCode,
BranchName = branch.BranchName,
VoucherDate = bankReceiptMaster.BankReceiptDate,
VoucherTypeIdMain = voucherTypeId,
VoucherTypeIdSub = 37,
VoucherNo = bankReceiptMaster.VoucherNo,
Amount = bankReceiptMaster.TotalAmount,
PaymentType = "Cheque",
Narration = "Bank Receipt",
ServerDate = DateTime.Now,
UserId = bankReceiptMaster.UserId,
UserName = bankReceiptMaster.UserName,
EmployeeId = -1,
ShiftId = shifId
};
context.TblVoucherMaster.Add(_voucherMaster);
if (context.SaveChanges() > 0)
{
return(_voucherMaster);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public TblVoucherDetail AddVoucherDetails(ERPContext context, TblJournalVoucherMaster journalVoucherMaster, TblBranch _branch, TblVoucherMaster _voucherMaster, TblAccountLedger _accountLedger, decimal?productRate, decimal?ledgerId, string ledgerCode, bool isFromCashDetials = true)
{
try
{
var _voucherDetail = new TblVoucherDetail();
var ledgerName = GetAccountLedgerList().Where(al => al.LedgerCode == ledgerCode).FirstOrDefault();
_voucherDetail.VoucherMasterId = _voucherMaster.VoucherMasterId;
_voucherDetail.VoucherDetailDate = _voucherMaster.VoucherDate;
_voucherDetail.BranchId = _branch.BranchId;
_voucherDetail.BranchCode = journalVoucherMaster.BranchCode;
_voucherDetail.BranchName = journalVoucherMaster.BranchName;
if (isFromCashDetials == true)
{
_voucherDetail.FromLedgerId = journalVoucherMaster.FromLedgerId;
_voucherDetail.FromLedgerCode = journalVoucherMaster.FromLedgerCode;
_voucherDetail.FromLedgerName = journalVoucherMaster.FromLedgerName;
_voucherDetail.ToLedgerId = ledgerName.LedgerId;
_voucherDetail.ToLedgerCode = ledgerCode;
_voucherDetail.ToLedgerName = ledgerName.LedgerName;
_voucherDetail.Amount = productRate;
_voucherDetail.TransactionType = "Debit";
_voucherDetail.CostCenter = journalVoucherMaster.BranchCode;
_voucherDetail.ServerDate = DateTime.Now;
_voucherDetail.Narration = "Journal Voucher";
}
//To ledger clarifiaction on selecion of product
else
{
_voucherDetail.FromLedgerId = ledgerName.LedgerId;
_voucherDetail.FromLedgerCode = ledgerCode;
_voucherDetail.FromLedgerName = ledgerName.LedgerName;
_voucherDetail.ToLedgerId = journalVoucherMaster.FromLedgerId;
_voucherDetail.ToLedgerCode = journalVoucherMaster.FromLedgerCode;
_voucherDetail.ToLedgerName = journalVoucherMaster.FromLedgerName;
_voucherDetail.Amount = productRate;
_voucherDetail.TransactionType = "Credit";
_voucherDetail.CostCenter = journalVoucherMaster.BranchCode;
_voucherDetail.ServerDate = DateTime.Now;
_voucherDetail.Narration = "Journal Voucher";
}
context.TblVoucherDetail.Add(_voucherDetail);
if (context.SaveChanges() > 0)
{
return(_voucherDetail);
}
return(null);
// }
}
catch (Exception ex)
{
throw ex;
}
}
public AddClientBranchRegisterDTO AddNewCBR(TblStaff staff, TblClient client, TblBranch branch)
{
// create AddClientBranchRegisterDTO
return(new AddClientBranchRegisterDTO
{
StaffNo = staff.StaffNo,
BranchNo = branch.BranchNo,
ClientNo = client.ClientNo
});
}
private TblVoucherMaster AddVoucherMaster(ERPContext context, TblPurchaseInvoice purchaseinvoice, TblBranch branch, decimal?voucherTypeId, string paymentType)
{
try
{
var _voucherMaster = new TblVoucherMaster();
_voucherMaster.BranchCode = purchaseinvoice.BranchCode;
_voucherMaster.BranchName = branch.BranchName;
_voucherMaster.VoucherDate = purchaseinvoice.PurchaseInvDate;
_voucherMaster.VoucherTypeIdMain = voucherTypeId;
_voucherMaster.VoucherTypeIdSub = 35;
_voucherMaster.VoucherNo = purchaseinvoice.PurchaseInvNo;
_voucherMaster.Amount = purchaseinvoice.GrandTotal;
_voucherMaster.PaymentType = paymentType;//accountLedger.CrOrD
_voucherMaster.Narration = "Purchase Invoice";
_voucherMaster.ServerDate = DateTime.Now;
_voucherMaster.UserId = purchaseinvoice.UserId;
_voucherMaster.UserName = purchaseinvoice.UserName;
_voucherMaster.EmployeeId = -1;
context.TblVoucherMaster.Add(_voucherMaster);
if (context.SaveChanges() > 0)
{
return(_voucherMaster);
}
#region comment
//var _voucherMaster = new TblVoucherMaster();
//_voucherMaster.BranchCode = invoice.BranchCode;
//_voucherMaster.BranchName = _branch.BranchName;
//_voucherMaster.VoucherDate = invoice.InvoiceDate;
//_voucherMaster.VoucherTypeIdMain = _vouchertType.VoucherTypeId;
//_voucherMaster.VoucherTypeIdSub = 35;
//_voucherMaster.VoucherNo = invoice.InvoiceNo;
//_voucherMaster.Amount = invoice.GrandTotal;
//_voucherMaster.PaymentType = _accountLedger.CrOrDr;
//_voucherMaster.Narration = "Sales Invoice";
//_voucherMaster.ServerDate = DateTime.Now;
//_voucherMaster.UserId = invoice.UserId;
//_voucherMaster.UserName = invoice.UserName;
//_voucherMaster.EmployeeId = -1;
//repo.TblVoucherMaster.Add(_voucherMaster);
//if(!(repo.SaveChanges() > 0))
//{
// dbTransaction.Rollback();
// return false;
//}
#endregion
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Include member or non member
/// </summary>
/// <param name="isMember"></param>
/// <param name="branchCode"></param>
/// <param name="name"></param>
/// <param name="isSingaporean"></param>
/// <param name="NRIC"></param>
/// <param name="nSignUpID"></param>
/// <param name="dob"></param>
/// <param name="aUser"></param>
///
/// 0705
public string AddNewMember(bool isMember, string branchCode, string name, bool isSingaporean, string NRIC, int nSignUpID,
DateTime dob, User aUser, bool isFemale, int nmediaSource)
{
string membershipID = string.Empty;
TblMember sqlMember = new TblMember();
sqlMember.FMember = isMember;
sqlMember.StrMemberName = name;
sqlMember.FFemale = isFemale;
if (name.Length >= 19)
{
sqlMember.StrCardName = name.Substring(0, 19);
}
else
{
sqlMember.StrCardName = name;
}
sqlMember.StrNRICFIN = NRIC;
sqlMember.DtDOB = dob;
sqlMember.StrBranchCode = branchCode;
sqlMember.FSingaporean = isSingaporean;
sqlMember.NMediaSourceID = nmediaSource;
TblCardRequest sqlCardRequest = new TblCardRequest();
TblAudit sqlAudit = new TblAudit();
if (!isMember)
{
ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider();
TblCompany sqlCompany = new TblCompany();
try
{
sqlCompany.MainConnectionProvider = connProvider;
sqlMember.MainConnectionProvider = connProvider;
sqlCardRequest.MainConnectionProvider = connProvider;
sqlAudit.MainConnectionProvider = connProvider;
connProvider.OpenConnection();
connProvider.BeginTransaction("AddNewNonMember");
sqlCompany.IncOne();
sqlMember.NMembershipNo = sqlCompany.NNonMembershipNo;
sqlMember.NStatus = 1;
sqlMember.NSignupID = nSignUpID;
sqlMember.StrMembershipID = "NMC" + sqlCompany.NNonMembershipNo;
sqlMember.DtSignupDate = DateTime.Now;
//sqlMember.NCardStatusID = (int)CardStatusType.RequestPrint;
sqlMember.NLoyaltyStatusID = 1;
sqlMember.Insert();
membershipID = "NMC" + sqlCompany.NNonMembershipNo;
connProvider.CommitTransaction();
}
catch (Exception)
{
connProvider.RollbackTransaction("AddNewNonMember");
throw;
}
finally
{
if (connProvider.CurrentTransaction != null)
{
connProvider.CurrentTransaction.Dispose();
}
if (connProvider.DBConnection != null)
{
if (connProvider.DBConnection.State == ConnectionState.Open)
{
connProvider.DBConnection.Close();
}
connProvider.DBConnection.Dispose();
}
sqlCompany.MainConnactionIsCreatedLocal = true;
sqlMember.MainConnactionIsCreatedLocal = true;
sqlCardRequest.MainConnactionIsCreatedLocal = true;
}
}
else
{
ACMSDAL.ConnectionProvider connProvider = new ConnectionProvider();
TblBranch sqlBranch = new TblBranch();
try
{
sqlBranch.MainConnectionProvider = connProvider;
sqlMember.MainConnectionProvider = connProvider;
sqlCardRequest.MainConnectionProvider = connProvider;
sqlAudit.MainConnectionProvider = connProvider;
connProvider.OpenConnection();
connProvider.BeginTransaction("AddNewNonMember");
sqlBranch.StrBranchCode = branchCode;
//sqlBranch.StrBranchCode = "PM";
sqlBranch.IncOne();
sqlMember.NMembershipNo = sqlBranch.NMembershipNo;
sqlMember.NStatus = 1;
sqlMember.NSignupID = nSignUpID;
sqlMember.StrMembershipID = branchCode.TrimEnd() + sqlBranch.NMembershipNo;
// sqlMember.StrMembershipID = "PM" + sqlBranch.NMembershipNo;
sqlMember.DtSignupDate = DateTime.Now;
sqlMember.NCardStatusID = (int)CardStatusType.RequestPrint;
sqlMember.StrCardBranchCode = "HQ";
sqlMember.NLoyaltyStatusID = 1;
sqlMember.Insert();
//Request print for member --now only for fitness member
// sqlCardRequest.NEmployeeID = aUser.NEmployeeID();
// sqlCardRequest.NStatusID = (int)CardStatusType.RequestPrint;
// sqlCardRequest.StrBranchCode = aUser.StrBranchCode();
// sqlCardRequest.StrMembershipID = branchCode.TrimEnd() +sqlBranch.NMembershipNo;
// sqlCardRequest.DtLastEditDate = DateTime.Now;
// sqlCardRequest.Insert();
//Audit trail for request print
// sqlAudit.NAuditTypeID = ACMSLogic.AuditTypeID.MemberCard;
// sqlAudit.NEmployeeID = aUser.NEmployeeID();
// sqlAudit.StrAuditEntry = "New member card request when create new member.";
// sqlAudit.StrReference = branchCode.TrimEnd() +sqlBranch.NMembershipNo;
// sqlAudit.DtDate = DateTime.Now;
// sqlAudit.Insert();
membershipID = branchCode.TrimEnd() + sqlBranch.NMembershipNo;
connProvider.CommitTransaction();
}
catch (Exception)
{
connProvider.RollbackTransaction("AddNewNonMember");
throw;
}
finally
{
if (connProvider.CurrentTransaction != null)
{
connProvider.CurrentTransaction.Dispose();
}
if (connProvider.DBConnection != null)
{
if (connProvider.DBConnection.State == ConnectionState.Open)
{
connProvider.DBConnection.Close();
}
connProvider.DBConnection.Dispose();
}
sqlBranch.Dispose();
sqlMember.Dispose();
sqlCardRequest.Dispose();
}
}
return(membershipID);
}
private TblStockInformation AddStockInformation(ERPContext context, TblPurchaseInvoice invoice, TblBranch _branch, TblProduct _product, decimal?qty, decimal?rate)
{
try
{
//using(ERPContext context=new ERPContext())
//{
var _stockInformation = new TblStockInformation();
_stockInformation.BranchId = _branch.BranchId;
_stockInformation.BranchCode = _branch.BranchCode;
_stockInformation.ShiftId = invoice.ShiftId;
_stockInformation.VoucherNo = invoice.VoucherNo;
_stockInformation.VoucherTypeId = invoice.VoucherTypeId;
_stockInformation.InvoiceNo = invoice.PurchaseInvNo;
_stockInformation.ProductId = _product.ProductId;
_stockInformation.ProductCode = _product.ProductCode;
_stockInformation.InwardQty = qty;
_stockInformation.Rate = rate;
context.TblStockInformation.Add(_stockInformation);
if (context.SaveChanges() > 0)
{
return(_stockInformation);
}
#region Comment
//var _stockInformation = new TblStockInformation();
//_stockInformation.BranchId = _branch.BranchId;
//_stockInformation.BranchCode = _branch.BranchCode;
//_stockInformation.ShiftId = invoice.ShiftId;
//_stockInformation.VoucherNo = invoice.VoucherNo;
//_stockInformation.VoucherTypeId = invoice.VoucherTypeId;
//_stockInformation.InvoiceNo = invoice.InvoiceNo;
//_stockInformation.ProductId = _product.ProductId;
//_stockInformation.ProductCode = _product.ProductCode;
//_stockInformation.OutwardQty = invdtl.Qty > 0 ? invdtl.Qty : invdtl.FQty;
//_stockInformation.Rate = invdtl.Rate;
//repo.TblStockInformation.Add(_stockInformation);
//repo.SaveChanges();
#endregion
return(null);
// }
}
catch (Exception ex)
{
throw ex;
}
}
public TblVoucherMaster AddVoucherMaster(ERPContext context, TblInvoiceMasterReturn invoiceReturn, TblBranch branch, decimal?voucherTypeId, string paymentType)
{
try
{
var _voucherMaster = new TblVoucherMaster
{
BranchCode = invoiceReturn.BranchCode,
BranchName = branch.BranchName,
VoucherDate = invoiceReturn.InvoiceDate,
VoucherTypeIdMain = voucherTypeId,
VoucherTypeIdSub = 35,
VoucherNo = invoiceReturn.InvoiceReturnNo,
Amount = invoiceReturn.GrandTotal,
PaymentType = paymentType,//accountLedger.CrOrD
Narration = "Sales Invoice Return",
ServerDate = DateTime.Now,
UserId = invoiceReturn.UserId,
UserName = invoiceReturn.UserName,
EmployeeId = -1
};
context.TblVoucherMaster.Add(_voucherMaster);
if (context.SaveChanges() > 0)
{
return(_voucherMaster);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
