protected void btnLogin_Click(object sender, EventArgs e)
{
Classes.CUsers cu = new Classes.CUsers();
int UserId = cu.GetUserIdByName(txtLoginUserId.Text);
Models.MUsers mu = new Models.MUsers();
string WareHouseId = string.Empty;
mu.name = txtLoginUserId.Text;
mu.password = txtLoginPassword.Text;
int retVal = cu.ValidateUser(mu);
if (retVal == -1)
{
lblShow.Text = "Invalid User ID or Password";
}
else if (retVal == -2)
{
Response.Redirect("~/Pages/SetFiscalYear.aspx");
}
else
{
Session["UserId"] = cu.GetUserIdByName(txtLoginUserId.Text);
Session["User"] = txtLoginUserId.Text;
Session["FiscalYear"] = retVal;
Session["WareHouse"] = ReturnWareHouseId(UserId.ToString());
Response.Redirect("~/Pages/Main.aspx");
}
}
private string BuildMenu()
{
string Menu = string.Empty;
string UserName = Session["User"].ToString();
Classes.CUsers cu = new Classes.CUsers();
Menu = "<ul class=\"nav navbar-nav\" > <li class=\"home-link\"> <a href=\"Main.aspx\"><i class=\"fa fa-home\"></i><span class=\"hidden\">Home</span></a></li>";
int UserId = cu.GetUserIdByName(UserName);
List <string> Permissions = cu.ParsePermissions(UserId);
#region setup
Menu += " <li class=\"dropdown \">";
Menu += "<a href=\"#\" class=\"dropdown-toggle\" data-toggle=\"dropdown\" data-hover=\"dropdown\">Setup Forms +</a>";
Menu += "<ul class=\"dropdown-menu\" role=\"menu\" aria-labelledby=\"pages-drop\" >";
Menu += this.RetrunSetupMenu(Permissions);
Menu += "</ul></li>";
#endregion
#region management
Menu += " <li class=\"dropdown \">";
Menu += "<a href=\"#\" class=\"dropdown-toggle\" id=\"pages-drop\" data-toggle=\"dropdown\" data-hover=\"dropdown\">Managemnt +</a>";
Menu += "<ul class=\"dropdown-menu\" role=\"menu\" aria-labelledby=\"pages-drop\" >";
Menu += this.RetrunManagementMenu(Permissions);
Menu += "</ul></li>";
#endregion
#region transactions
Menu += " <li class=\"dropdown \">";
Menu += "<a href=\"#\" class=\"dropdown-toggle\" id=\"pages-drop\" data-toggle=\"dropdown\" data-hover=\"dropdown\">Transactions +</a>";
Menu += "<ul class=\"dropdown-menu\" role=\"menu\" aria-labelledby=\"pages-drop\" >";
Menu += RetrunTransactionsMenu(Permissions);
Menu += "</ul></li>";
#endregion
#region reports
Menu += " <li class=\"dropdown \">";
Menu += "<a href=\"#\" class=\"dropdown-toggle\" id=\"pages-drop\" data-toggle=\"dropdown\" data-hover=\"dropdown\">Inventory Control +</a>";
Menu += "<ul class=\"dropdown-menu\" role=\"menu\" aria-labelledby=\"pages-drop\" >";
Menu += this.RetrunInventoryControlMenu(Permissions);
Menu += "</ul></li>";
#endregion
#region accounts
Menu += " <li class=\"dropdown \">";
Menu += "<a href=\"#\" class=\"dropdown-toggle\" id=\"pages-drop\" data-toggle=\"dropdown\" data-hover=\"dropdown\">Accounts +</a>";
Menu += "<ul class=\"dropdown-menu\" role=\"menu\" aria-labelledby=\"pages-drop\" >";
Menu += this.RetrunAccountsMenu(Permissions);
Menu += "</ul></li>";
#endregion
Menu += "</ul>";
return(Menu);
}
public int isAdmin(string UserName)
{
Classes.CUsers cu = new Classes.CUsers();
int UserId = cu.GetUserIdByName(UserName);
List <string> Permissions = cu.ParsePermissions(UserId);
if (Permissions.Contains("33") || Permissions.Contains("-33") || Permissions.Contains("33-"))
{
return(1);
}
return(-1);
}
protected void Page_Load(object sender, EventArgs e)
{
Classes.CUsers cu = new Classes.CUsers();
string LoggedInUserId = string.Empty;
string FiscalYear = string.Empty;
string WareHouseName = string.Empty;
LoggedInUserId = Session["User"].ToString();
FiscalYear = ReturnFiscalYear();
int UserId = cu.GetUserIdByName(LoggedInUserId);
WareHouseName = ReturnWareHouseName(UserId.ToString());
lblLoggedIn.Text = LoggedInUserId;
lblFiscalYear.Text = FiscalYear;
lblWareHouse.Text = WareHouseName;
menu.InnerHtml = BuildMenu();
}
private int ProcessPayments(string PaymentId, string OrderId, string totalCost, string CurrentAmountPaid,
string AccountId, float AmountRemaining, string RemainingAmount, string DatePaid, string Type, string Cheque)
{
if (Page.IsValid)
{
Classes.CBankOfAccount cba = new Classes.CBankOfAccount();
Classes.CAccountTransaction cat = new Classes.CAccountTransaction();
Classes.CCashAccount cha = new Classes.CCashAccount();
Classes.CCashTransaction cht = new Classes.CCashTransaction();
Classes.CPayment cp = new Classes.CPayment();
Classes.CPaymentLine cpl = new Classes.CPaymentLine();
Classes.CSaleTransations cs = new Classes.CSaleTransations();
Models.MAccountTransaction mat = new Models.MAccountTransaction();
Models.MPayments mp = new Models.MPayments();
Models.PaymentLine mpl = new Models.PaymentLine();
Models.MCashTransactions mht = new Models.MCashTransactions();
Models.MCashAccount mha = new Models.MCashAccount();
#region Payments
mp.Paid = (Convert.ToSingle(totalCost) - AmountRemaining).ToString();
if (cp.UpdateAmountPaid(Convert.ToInt32(PaymentId), mp.Paid) < 0)
{
return(-1);
}
#endregion
#region PaymentLine
mpl.PaymentId = Convert.ToInt32(PaymentId);
mpl.BankId = Convert.ToInt32(AccountId);
mpl.Date = DatePaid;
mpl.PaidAmount = CurrentAmountPaid;
mpl.RemainingAmount = RemainingAmount;
mpl.CumulativeAmount = (Convert.ToSingle(cpl.LastPaidAmount(mpl.PaymentId))
+ Convert.ToSingle(CurrentAmountPaid)).ToString();
int OptionValue = Convert.ToInt32(ddlOption.SelectedValue);
mpl.Cheque = Cheque;
switch (OptionValue)
{
case -1:
{
return(-1);
}
case 1:
{
#region Account Transactions
mpl.ModeOfPayment = Common.Constants.ModeOfPayment.Cheque.ToString();
float AccountTotal = cba.ReturnTotalOfAccountById(Convert.ToInt32(AccountId));
mat.AccountId = AccountId;
if (Type.Contains("Vendor"))
{
mat.Description = "Payment Of Order Id[" + OrderId + "] Paid, Amount ["
+ CurrentAmountPaid + "]";
mat.Debit = CurrentAmountPaid;
mat.Credit = "0";
mat.Total = (AccountTotal - Convert.ToSingle(CurrentAmountPaid)).ToString();
mat.CurrentTransaction = cs.GetIdByOrderId(Convert.ToInt32(OrderId)).ToString();
mat.Transactiontype = "Debit";
mat.FiscalYearId = Session["FiscalYear"].ToString();
mat.eDate = Convert.ToDateTime(DatePaid);
}
else if (Type.Contains("Client"))
{
mat.Description = "Payment Of Order Id[" + OrderId + "] Recieved, Amount ["
+ CurrentAmountPaid + "]";
mat.Debit = "0";
mat.Credit = CurrentAmountPaid;
mat.CurrentTransaction = cs.GetIdByOrderId(Convert.ToInt32(OrderId)).ToString();
mat.Total = (AccountTotal + Convert.ToSingle(CurrentAmountPaid)).ToString();
mat.Transactiontype = "Credit";
mat.FiscalYearId = Session["FiscalYear"].ToString();
mat.eDate = Convert.ToDateTime(DatePaid);
}
else
{
return(-3);
}
if (cat.Save(mat) < 0)
{
return(-4);
}
if (cba.SetNewAccountTotal(Convert.ToInt32(AccountId), Convert.ToSingle(mat.Total)) < 0)
{
return(-5);
}
#endregion
break;
}
case 2:
{
#region Cash Transaction
mpl.ModeOfPayment = Common.Constants.ModeOfPayment.Cash.ToString();
mpl.Cheque = "-";
float AccountTotal = cha.ReturnTotalOfCashAccount(Convert.ToInt32(AccountId));
mht.CashAccountId = Convert.ToInt32(AccountId);
if (Type.Contains("Vendor"))
{
mht.Credit = "0";
mht.Debit = CurrentAmountPaid;
mht.Description = "Payment Of Order Id[" + OrderId + "] Paid, Amount ["
+ CurrentAmountPaid + "]";
mht.eDate = (DatePaid);
mht.FiscalYearId = Convert.ToInt32(Session["FiscalYear"].ToString());
mht.OrderId = Convert.ToInt32(OrderId);
mht.Total = totalCost;
mht.TransactionId = -1;
mht.TransactionType = "Debit";
string UserName = Session["User"].ToString();
Classes.CUsers cu = new Classes.CUsers();
string UserId = cu.GetUserIdByName(UserName).ToString();
mht.UserId = Session["User"].ToString();
mht.WareHouseId = Convert.ToInt32(Session["WareHouse"].ToString());
}
else if (Type.Contains("Client"))
{
mht.Credit = CurrentAmountPaid;
mht.Debit = "0";
mht.Description = "Payment Of Order Id[" + OrderId + "] Recieved, Amount ["
+ CurrentAmountPaid + "]";
mht.eDate = (DatePaid);
mht.FiscalYearId = Convert.ToInt32(Session["FiscalYear"].ToString());
mht.OrderId = Convert.ToInt32(OrderId);
mht.Total = totalCost;
mht.TransactionId = -1;
mht.TransactionType = "Debit";
string UserName = Session["User"].ToString();
Classes.CUsers cu = new Classes.CUsers();
string UserId = cu.GetUserIdByName(UserName).ToString();
mht.UserId = Session["User"].ToString();
mht.WareHouseId = Convert.ToInt32(Session["WareHouse"].ToString());
}
else
{
return(-3);
}
if (cht.Save(mht) < 0)
{
return(-4);
}
if (cha.SetNewAccountTotal(Convert.ToInt32(AccountId), Convert.ToSingle(mat.Total)) < 0)
{
return(-5);
}
#endregion
break;
}
default:
return(-1);
}
if (cpl.Save(mpl) < 0)
{
return(-2);
}
#endregion
#region Accounts
if (Convert.ToSingle(mp.Paid) > 0)
{
if (Type == "Vendor")
{
Classes.CJournal cj = new Classes.CJournal();
Models.MJournal mj = new Models.MJournal();
mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.MerchandiseInventory).ToString();
mj.amount = mp.Paid;
mj.des = "Payment Recieved of Order id [" + OrderId + "]";
mj.e_date = (DatePaid);
mj.type = Common.Constants.Accounts.Type.Debit.ToString();
cj.Save(mj);
mj = new Models.MJournal();
mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.AccountsPayable).ToString();
mj.amount = mp.Paid;
mj.des = "Payment Recieved of Order id [" + OrderId + "]";
mj.e_date = (DatePaid);
mj.type = Common.Constants.Accounts.Type.Credit.ToString();
cj.Save(mj);
}
else if (Type == "Client")
{
Classes.CJournal cj = new Classes.CJournal();
Models.MJournal mj = new Models.MJournal();
mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.CostOfGoodsSold).ToString();
mj.amount = mp.Paid;
mj.des = "Payment Recieved of Order id [" + OrderId + "]";
mj.e_date = (DatePaid);
mj.type = Common.Constants.Accounts.Type.Debit.ToString();
cj.Save(mj);
mj = new Models.MJournal();
mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.MerchandiseInventory).ToString();
mj.amount = mp.Paid;
mj.des = "Payment Recieved of Order id [" + OrderId + "]";
mj.e_date = (DatePaid);
mj.type = Common.Constants.Accounts.Type.Credit.ToString();
cj.Save(mj);
cj = new Classes.CJournal();
mj = new Models.MJournal();
mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.AccountsRecievalbes).ToString();
mj.amount = mp.Paid;
mj.des = "Payment Recieved of Order id [" + OrderId + "]";
mj.e_date = (DatePaid);
mj.type = Common.Constants.Accounts.Type.Debit.ToString();
cj.Save(mj);
mj = new Models.MJournal();
mj.acc_id = Convert.ToInt32(Common.Constants.Accounts.ChartOfAccounts.Sales).ToString();
mj.amount = mp.Paid;
mj.des = "Payment Recieved of Order id [" + OrderId + "]";
mj.e_date = (DatePaid);
mj.type = Common.Constants.Accounts.Type.Credit.ToString();
cj.Save(mj);
}
}
#endregion
}
lblPurchaseAmountRemaining.Text = AmountRemaining.ToString();
lblPurchaseAmountPaid.Text = (Convert.ToSingle(totalCost) - AmountRemaining).ToString();
return(1);
}