private void GenerateDataWithOutNoOfLeaves()
{
try
{
int employeeid = Convert.ToInt32(Session["currentpayslipemployeeid"]);
lblDeductionForLeaves.Text = "";
lblNetSalary.Text = "";
if (txtNoOfLeaves.Text.Length <= 0)
{
txtNoOfLeaves.Text = "0";
}
int noofleaves = Convert.ToInt32(txtNoOfLeaves.Text);
if (noofleaves >= 0 && noofleaves <= 31)
{
DataTable dt1 = BusinessAccessLayer.Query("select * from employees e,levels l where e.levelid=l.levelid and employeeid=" + employeeid);
decimal basicsalary = Convert.ToDecimal(dt1.Rows[0]["basicsalary"]);
int daysinmonth = DateTime.DaysInMonth(Convert.ToInt32(dropYear.SelectedItem.Text), dropMonth.SelectedIndex + 1);
decimal salaryperday = basicsalary / daysinmonth;
decimal deductionforleaves = noofleaves * salaryperday;
decimal netsalary = basicsalary - deductionforleaves;
lblSalaryPerDay.Text = Math.Round(salaryperday, 2).ToString();
lblDeductionForLeaves.Text = Math.Round(deductionforleaves, 2).ToString();
lblNetSalary.Text = Math.Round(netsalary, 2).ToString();
}
txtNoOfLeaves.Focus();
}
catch (Exception ex)
{
lblError.Text = "Error: " + ex.Message;
}
}
void RefreshData()
{
UserSource.DataSource = BusinessAccessLayer.GetEntity().User_tbl;
DBSource.DataSource = BusinessAccessLayer.GetEntity().DB_tbl;
SubPrivSource.DataSource = BusinessAccessLayer.GetEntity().Sub_Priv_tbl;
PrivelegeSource.DataSource = BusinessAccessLayer.GetEntity().Privilege_tbl;
}
private void btnSave_Click(object sender, EventArgs e)
{
var checkAdd = checkBox1.Checked;
var checkedit = checkBox2.Checked;
var checkDelete = checkBox3.Checked;
var checkView = checkBox4.Checked;
var selectDB = int.Parse(comboBox1.SelectedValue.ToString());
AsyncHelper.TaskAwaiter(() =>
{
var user = (User_tbl)UserSource.Current;
var priv = user.Privilege_tbl.Where(x => x.DbID == selectDB);
if (priv.Count() <= 0)
{
var subpriv = new Sub_Priv_tbl
{
Add = checkAdd,
Edit = checkedit,
Delete = checkDelete,
View = checkView
};
var privNew = new Privilege_tbl();
privNew.DbID = selectDB;
privNew.Sub_Priv_tbl = subpriv;
user.Privilege_tbl.Add(privNew);
}
BusinessAccessLayer.GetEntity().SaveChanges();
return(true);
});
}
private void btnSave_Click(object sender, EventArgs e)
{
BusinessAccessLayer.GetEntity().SaveChanges();
modRefreshData("");
Close();
Dispose();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Page.IsPostBack == false)
{
for (int i = DateTime.Now.Year; i >= 1950; i--)
{
dropYear.Items.Add(i.ToString());
}
int employeeid = Convert.ToInt32(Session["currentpayslipemployeeid"]);
DataTable dt = BusinessAccessLayer.Query("select * from employees e,levels l where e.levelid=l.levelid and employeeid=" + employeeid);
if (dt.Rows.Count > 0)
{
lblEmployee.Text = Convert.ToString(dt.Rows[0]["name"]);
lblBasicSalary.Text = Convert.ToString(dt.Rows[0]["basicsalary"]);
DateTime date = DateTime.Now.AddMonths(-1);
dropMonth.SelectedIndex = date.Month - 1;
dropYear.SelectedIndex = dropYear.Items.IndexOf(new ListItem(date.Year.ToString()));
GenerateData();
txtNoOfLeaves.Focus();
}
else
{
Response.Redirect("payslips.aspx", false);
}
}
}
catch (Exception ex)
{
lblError.Text = "Error: " + ex.Message;
}
}
private void Show()
{
try
{
lnkGeneratePayslip.Visible = false;
gridPayslips.DataSource = null;
gridPayslips.DataBind();
lblMessage.Text = "";
if (dropEmployee.SelectedIndex > 0)
{
lnkGeneratePayslip.Visible = true;
string employeename = dropEmployee.SelectedItem.Text;
int employeeid = Convert.ToInt32(BusinessAccessLayer.Query("select employeeid from employees where name='" + employeename + "'").Rows[0]["employeeid"]);
DataTable dt = BusinessAccessLayer.Query("select payslipid,monthname + ' ' + convert(varchar,year) 'MonthAndYear',generatedon,basicsalary,noofleaves,salaryperday,deductionforleaves,netsalary from payslips ps where employeeid=" + employeeid + " order by year desc,ps.month desc");
if (dt.Rows.Count > 0)
{
gridPayslips.DataSource = dt;
gridPayslips.DataBind();
}
else
{
lblMessage.Text = "No payslips found.";
}
}
dropEmployee.Focus();
}
catch (Exception ex)
{
lblError.Text = "Error: " + ex.Message;
}
}
public void RefreshData(string msg)
{
var entity = BusinessAccessLayer.GetEntity();
entity.CreateDatabaseScript();
SupplierSource.DataSource = entity.Suppliers;
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Convert.ToString(Session["currentusertype"]) != "Administrator")
{
Response.Redirect("welcome.aspx");
}
if (Page.IsPostBack == false)
{
dropLevel.Items.Clear();
DataTable dt = BusinessAccessLayer.Query("select * from levels order by levelid");
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
dropLevel.Items.Add(Convert.ToString(dt.Rows[i]["levelid"]));
}
dropLevel.SelectedIndex = 0;
}
else
{
Response.Redirect("welcome.aspx", false);
}
int newemployeeid = BusinessAccessLayer.GetNextID("employees", "employeeid");
lblEmployeeID.Text = Convert.ToString(newemployeeid);
txtName.Focus();
}
}
catch (Exception ex)
{
lblError.Text = "Error: " + ex.Message;
}
}
private void textBox1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
var products = BusinessAccessLayer.GetEntity().Products.Where(x => x.ProductName.Contains(textBox1.Text.Trim()));
if (products.Count() <= 0)
{
MessageBox.Show("Product Barcode not available", "invalid", MessageBoxButtons.OK,
MessageBoxIcon.Information);
return;
}
_orderDetails = new Order_Detail();
_orderDetails.Quantity = 1;
_orderDetails.UnitPrice = products.First().UnitPrice;
_orderDetails.ProductID = products.First().ProductID;
_orderDetails.IsVoid = false;
_orderDetails.IsReturn = false;
OrderDetailSource.Add(_orderDetails);
CalculateSumAmount();
textBox11.Clear();
textBox11.Focus();
}
}
private void button3_Click(object sender, EventArgs e)
{
if (txtGrandtotal.Text.Trim() == "")
{
return;
}
var result = MessageBox.Show(
"You must save the transaction before you cant generate Invoice\nDo you want to save transaction?",
"Saving transaction", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (result == DialogResult.Yes)
{
_order.CustomerID = int.Parse(cmbBillto.SelectedValue.ToString() ?? "0");
_order.IsPaid = false;
_order.OrderDate = DateTime.Now;
_order.BillingDate = dtpTransDate.Value.AddDays(30);
_order.DeliveryAddress = txtAddress.Text;
_order.DeliveryDate = dtpTransDate.Value;
_order.Term = 30;
foreach (var orderDetail in OrderDetailSource.OfType <Order_Detail>())
{
_order.Order_Details.Add(orderDetail);
}
BusinessAccessLayer.GetEntity().Orders.AddObject(_order);
BusinessAccessLayer.GetEntity().SaveChanges();
GenerateInvoice();
Close();
}
}
public frmTransactionBilling()
{
InitializeComponent();
_order = new Order();
OrderSource.DataSource = BusinessAccessLayer.GetEntity().Orders;
CustomerSource.DataSource = BusinessAccessLayer.GetEntity().Customers;
ProductSource.DataSource = BusinessAccessLayer.GetEntity().Products;
}
public frmTransactionDelivery()
{
InitializeComponent();
_order = new Order();
OrderSource.DataSource = BusinessAccessLayer.GetEntity().Orders;
CustomerSource.DataSource = BusinessAccessLayer.GetEntity().Customers;
ProductSource.DataSource = BusinessAccessLayer.GetEntity().Products;
textBox11.Focus();
}
private frmCustomerDataEntry(int id = 0)
{
InitializeComponent();
if (id <= 0)
{
CustomerSource.DataSource = BusinessAccessLayer.GetEntity().Products;
}
else
{
CustomerSource.DataSource = BusinessAccessLayer.GetEntity().Customers.Where(e => e.ID == id);
}
}
private frmProductDataEntry(int id = 0)
{
InitializeComponent();
bindingSupplier.DataSource = BusinessAccessLayer.GetEntity().Suppliers;
if (id <= 0)
{
bindingProduct.DataSource = BusinessAccessLayer.GetEntity().Products;
}
else
{
bindingProduct.DataSource = BusinessAccessLayer.GetEntity().Products.Where(e => e.ProductID == id);
}
}
private frmSupplierDataEntry(int id = 0)
{
InitializeComponent();
if (id <= 0)
{
SupplierSource.DataSource = BusinessAccessLayer.GetEntity().Suppliers;
}
else
{
SupplierSource.DataSource = BusinessAccessLayer.GetEntity().Suppliers.Where(e => e.SupplierID == id);
}
}
protected void gridMessages_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
int messageid = Convert.ToInt32(gridMessages.Rows[e.RowIndex].Cells[0].Text);
string sqlstr = "update messages set active=0 where messageid=" + messageid;
BusinessAccessLayer.NonQuery(sqlstr);
Show();
}
catch (Exception ex)
{
lblError.Text = "Error: " + ex.Message;
}
}
protected void gridPayslips_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
try
{
int payslipid = Convert.ToInt32(gridPayslips.Rows[e.RowIndex].Cells[0].Text);
string sqlstr = "delete from payslips where payslipid=" + payslipid;
BusinessAccessLayer.NonQuery(sqlstr);
Show();
}
catch (Exception ex)
{
lblError.Text = "Error: " + ex.Message;
}
}
private void OnChangeDataSelect()
{
var user = (User_tbl)UserSource.Current;
var Dbtbl = (DB_tbl)DBSource.Current;
var checkAdd = checkBox1.Checked;
var checkedit = checkBox2.Checked;
var checkDelete = checkBox3.Checked;
var checkView = checkBox4.Checked;
var selectDB = int.Parse(comboBox1.SelectedValue.ToString());
var dataAwaiter = AsyncHelper.TaskAwaiter(() =>
{
var privList =
BusinessAccessLayer.GetEntity().Privilege_tbl.Where(x => x.UserID == user.ID && x.DbID == Dbtbl.ID);
if (privList.Count() <= 0)
{
var subpriv = new Sub_Priv_tbl
{
Add = checkAdd,
Edit = checkedit,
Delete = checkDelete,
View = checkView
};
var privNew = new Privilege_tbl();
privNew.DbID = selectDB;
privNew.Sub_Priv_tbl = subpriv;
user.Privilege_tbl.Add(privNew);
BusinessAccessLayer.GetEntity().SaveChanges();
privList =
BusinessAccessLayer.GetEntity().Privilege_tbl.Where(x => x.UserID == user.ID && x.DbID == Dbtbl.ID);
}
return(privList);
});
dataAwaiter.OnCompleted(() =>
{
var privList = dataAwaiter.GetResult();
if (privList.Count() > 0)
{
SubPrivSource.DataSource = privList.First().Sub_Priv_tbl;
}
});
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
//if (Convert.ToString(Session["currentusertype"]) != "Manager")
// Response.Redirect("welcome.aspx");
DataTable dt = BusinessAccessLayer.Query("select * from employees order by employeeid");
gridEmployees.DataSource = dt;
gridEmployees.DataBind();
}
catch (Exception ex)
{
lblError.Text = "Error: " + ex.Message;
}
}
protected void lnkYes_Click(object sender, EventArgs e)
{
try
{
int employeeid = Convert.ToInt32(Session["deletingemployeeid"]);
string sqlstr = "delete from employees where employeeid=" + employeeid;
BusinessAccessLayer.NonQuery(sqlstr);
Session["deletingemployeeid"] = null;
Response.Redirect("employees.aspx", false);
}
catch (Exception ex)
{
lblError.Text = "Error: " + ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Convert.ToString(Session["currentusertype"]) != "Manager")
{
Response.Redirect("welcome.aspx");
}
if (Page.IsPostBack == false)
{
dropTo.Focus();
dropTo.Items.Clear();
dropTo.Items.Add("---Select---");
DataTable dt = BusinessAccessLayer.Query("select * from employees order by levelid");
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
dropTo.Items.Add(Convert.ToString(dt.Rows[i]["name"]));
}
dropTo.SelectedIndex = 0;
if (Session["replyemployeename"] != null && Convert.ToString(Session["replyemployeename"]) != "")
{
int n = 0;
for (int i = 0; i < dropTo.Items.Count; i++)
{
if (Convert.ToString(Session["replyemployeename"]) == dropTo.Items[i].Text)
{
n = i;
}
}
Session["replyemployeename"] = null;
dropTo.SelectedIndex = n;
txtMessage.Focus();
}
}
else
{
Response.Redirect("welcome.aspx", false);
}
}
}
catch (Exception ex)
{
lblError.Text = "Error: " + ex.Message;
}
}
protected void lnkGeneratePayslip_Click(object sender, EventArgs e)
{
try
{
if (dropEmployee.SelectedIndex > 0)
{
string employeename = dropEmployee.SelectedItem.Text;
int employeeid = Convert.ToInt32(BusinessAccessLayer.Query("select employeeid from employees where name='" + employeename + "'").Rows[0]["employeeid"]);
Session["currentpayslipemployeeid"] = employeeid;
Response.Redirect("generatepayslip.aspx", false);
}
}
catch (Exception ex)
{
lblError.Text = "Error: " + ex.Message;
}
}
private void Show()
{
gridMessages.DataSource = null;
gridMessages.DataBind();
lblMessage.Text = "";
DataTable dt = BusinessAccessLayer.Query("select * from messages where messagefrom='" + from + "' order by date desc");
if (dt.Rows.Count > 0)
{
gridMessages.DataSource = dt;
gridMessages.DataBind();
}
else
{
lblMessage.Text = "No Messages.";
}
}
//Use to validate user login entry
private void sValidate()
{
var user =
BusinessAccessLayer.GetEntity().User_tbl.Where(
e => e.UserID == txtUsername.Text && e.Password == txtPassword.Text);
if (user.Count() > 0)
{
isvalid = true;
User = txtUsername.Text;
Close();
return;
}
MessageBox.Show("Invalid username or password", "invalid", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
public frmRemittance(int id = 0)
{
InitializeComponent();
UserSource.DataSource = BusinessAccessLayer.GetEntity().User_tbl;
var ordersPaid =
BusinessAccessLayer.GetEntity().Orders.ToList().Where(
e => (e.OrderDate >= DateTime.Now.AddHours(-8) && e.OrderDate <= DateTime.Now) ||
(e.DeliveryDate >= DateTime.Now.AddHours(-8) && e.DeliveryDate <= DateTime.Now));
decimal?totalRemit = null;
totalRemit = ordersPaid.Sum(e => e.Payments.Sum(x => x.AmountPaid));
label3.Text = (totalRemit ?? 0).ToString("#,###.00");
}
public frmManageUser()
{
InitializeComponent();
var userCount = BusinessAccessLayer.GetEntity().User_tbl.Count();
if (userCount <= 0)
{
var user = new User_tbl();
user.UserID = "Admin";
user.Password = "******";
BusinessAccessLayer.GetEntity().User_tbl.AddObject(user);
BusinessAccessLayer.GetEntity().SaveChanges();
}
RefreshData();
comboBox1.SelectedValueChanged += comboBox1_SelectedValueChanged;
}
private void Show()
{
gridMessages.DataSource = null;
gridMessages.DataBind();
lblMessage.Text = "";
int to = Convert.ToInt32(Session["currentemployeeid"]);
DataTable dt = BusinessAccessLayer.Query("select * from messages where messagefrom='Manager' and employeeid=" + to + " and active=1 order by date desc");
if (dt.Rows.Count > 0)
{
gridMessages.DataSource = dt;
gridMessages.DataBind();
}
else
{
lblMessage.Text = "No Messages.";
}
}
private void btnSave_Click(object sender, EventArgs e)
{
var remitttance = new Remittance();
remitttance.DateRemit = DateTime.Now;
remitttance.UserID = int.Parse(comboBox1.SelectedValue.ToString());
foreach (var remittanceDetail in RemitDetailSource.OfType <RemittanceDetail>())
{
remitttance.RemittanceDetails.Add(remittanceDetail);
}
BusinessAccessLayer.GetEntity().Remittances.AddObject(remitttance);
BusinessAccessLayer.GetEntity().SaveChanges();
Close();
Dispose();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
string date, messagefrom, messageto, message;
int employeeid;
date = DateTime.Now.ToString();
messagefrom = Convert.ToString(Session["currentemployeename"]);
messageto = "Manager";
message = txtMessage.Text;
employeeid = Convert.ToInt32(Session["currentemployeeid"]);
string sqlstr = "insert into messages values('" + date + "','" + messagefrom + "','" + messageto + "','" + message + "'," + employeeid + ",1)";
BusinessAccessLayer.NonQuery(sqlstr);
Response.Redirect("employeemessageoutbox.aspx", false);
}
catch (Exception ex)
{
lblError.Text = "Error: " + ex.Message;
}
}
public frmTransactionBilling(int id)
{
InitializeComponent();
_order = new Order();
if (BusinessAccessLayer.GetEntity().Orders.Where(e => e.OrderID == id).Count() <= 0)
{
MessageBox.Show("Order Transaction doesnt exist", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
_order = BusinessAccessLayer.GetEntity().Orders.Where(e => e.OrderID == id).First();
OrderSource.DataSource = _order;
CustomerSource.DataSource = _order.Customer;
ProductSource.DataSource = BusinessAccessLayer.GetEntity().Products;
OrderDetailSource.DataSource = _order.Order_Details;
CalculateSumAmount();
}
