private void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (txtName.Text != "" && txtNo.Text != "")
{
var ExpType = new ExpenseType()
{
TypeNo = int.Parse(txtNo.Text),
Name = txtName.Text
};
ctx.ExpenseTypes.Add(ExpType);
ctx.SaveChanges();
lblError.Text = "Expense Type Created Successfully!";
lblError.ForeColor = Color.Lime;
}
else
{
lblError.Text = "Name field cannot be empty!";
lblError.ForeColor = Color.Yellow;
}
loadExpType();
}
catch (Exception)
{
lblError.Text = "Database Error has occurred!!!";
lblError.ForeColor = Color.Yellow;
}
}
private void chgPw()
{
try
{
User cuser = ctx.Users.FirstOrDefault(u => u.Id == Form1.userId);
if (GetMd5Sum(txtCpw.Text) == cuser.Password)
{
cuser.Password = GetMd5Sum(txtPw1.Text);
ctx.SaveChanges();
lblError.Text = "Password change successful!";
lblError.ForeColor = Color.Lime;
txtCpw.Clear();
txtPw1.Clear();
txtPw2.Clear();
}
else
{
lblError.Text = "Incorrect user password!";
}
}
catch (Exception)
{
lblError.Text = "Database error has occurred!";
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (txtCost.Text != "" && txtModelNo.Text != "" && txtProductName.Text != "" && txtQty.Text != "" && txtSelling.Text != "" && cboProdType.Text != "")
{
var query = from p in ctx.Products where p.ModelNo == txtModelNo.Text.ToUpper() select p;
if (query.Count() == 0)
{
var product = new Product()
{
ModelNo = txtModelNo.Text.ToUpper(),
ProductName = txtProductName.Text,
Cost = decimal.Parse(txtCost.Text),
Sale = decimal.Parse(txtSelling.Text),
Quantity = int.Parse(txtQty.Text),
ProdTypeId = ctx.ProductTypes.FirstOrDefault(p => p.Name == cboProdType.Text).Id,
CreatedBy = Form1.userId,
CreatedOn = System.DateTime.Now,
ModifiedBy = Form1.userId,
ModifiedOn = System.DateTime.Now
};
ctx.Products.Add(product);
ctx.SaveChanges();
lblMsg.Text = "Product Added Successfully!";
lblMsg.ForeColor = Color.Lime;
clear();
loadProducts();
}
else
{
lblMsg.Text = "Product already exists!";
}
}
else
{
lblMsg.Text = "No field must be empty!";
}
}
catch (Exception)
{
lblMsg.Text = "Database error has occurred!";
lblMsg.ForeColor = Color.Yellow;
}
}
private void addRole()
{
try
{
tblRole role = new tblRole()
{
RoleName = txtRolename.Text,
Role1 = (chkProdTypeMgt.Checked ? 1 : 0),
Role2 = (chkProdMgt.Checked ? 1 : 0),
Role3 = (chkSalesMgt.Checked ? 1 : 0),
Role4 = (chkPartPay.Checked ? 1 : 0),
Role5 = (chkReturnSales.Checked ? 1 : 0),
Role6 = (chkExpType.Checked ? 1 : 0),
Role7 = (chkPostExp.Checked ? 1 : 0),
Role8 = (chkCompany.Checked ? 1 : 0),
Role9 = (chkRoleMgt.Checked ? 1 : 0),
Role10 = (chkUser.Checked ? 1 : 0),
Role11 = (chkBackup.Checked ? 1 : 0),
Role12 = (chkFinancial.Checked ? 1 : 0),
Role13 = (chkProdList.Checked ? 1 : 0),
Role14 = (chkSalesHistory.Checked ? 1 : 0),
Role15 = (chkExpHistory.Checked ? 1 : 0),
Role16 = (chkProdSold.Checked ? 1 : 0),
Role17 = (chkRetHistory.Checked ? 1 : 0),
Role18 = (chkProdReturn.Checked ? 1 : 0),
CreatedBy = Form1.userId,
CreatedOn = System.DateTime.Now
};
ctx.tblRoles.Add(role);
ctx.SaveChanges();
lblError.Text = "Role added successfully!";
clear();
}
catch (Exception)
{
lblError.Text = "Database error has occurred!";
lblError.ForeColor = Color.Yellow;
}
}
private void addUser()
{
try
{
var query = from u in ctx.Users
where u.Username == txtUsername.Text.ToLower()
select u;
if (query.Count() == 0)
{
User post = new User()
{
Display = txtDisplayName.Text,
Username = txtUsername.Text.ToLower(),
Password = GetMd5Sum(txtPassword.Text),
Status = (chkStatus.Checked ? 1 : 0),
RoleId = ctx.tblRoles.FirstOrDefault(r => r.RoleName == cboRole.Text).Id,
CreatedOn = System.DateTime.Now
};
ctx.Users.Add(post);
ctx.SaveChanges();
lblError.Text = "User successfully added!";
lblError.ForeColor = Color.Lime;
clearall();
getUsers();
}
else
{
lblError.Text = "Username already exist!";
lblError.ForeColor = Color.Yellow;
}
}
catch (Exception)
{
lblError.Text = "An error has occurred!";
lblError.ForeColor = Color.Yellow;
}
}
private void saveSales()
{
try
{
SalesOrder sale = new SalesOrder()
{
Salesno = salesno,
PaymentMode = (rdCash.Checked ? 1 : (rdPOS.Checked ? 2 : (rdCheck.Checked ? 3 : (rdBank.Checked ? 4 : 0)))),
Total = decimal.Parse(txtTotal.Text),
Discount = decimal.Parse(txtDist.Text),
Amt_Tendered = decimal.Parse(txtTendered.Text),
Createdby = Form1.userId,
Createdon = System.DateTime.Now
};
ctx.SalesOrders.Add(sale);
ctx.SaveChanges();
}
catch (Exception)
{
label6.Text = "Database error has occurred!";
label6.ForeColor = Color.Yellow;
}
}
private void ReturnSales()
{
try
{
SalesReturn post = new SalesReturn()
{
SalesId = Id,
Percentage = 0,
TotalValue = total,
CreatedBy = Form1.userId,
CreatedOn = System.DateTime.Now,
RequestType = (rdRefund.Checked ? 1 : 2)
};
ctx.SalesReturns.Add(post);
ctx.SaveChanges();
lastReturnID = ctx.SalesReturns.OrderByDescending(s => s.Id).FirstOrDefault().Id;
}
catch (Exception)
{
label6.Text = "Database error has occurred!";
label6.ForeColor = Color.Yellow;
}
}
private void postExp()
{
try
{
ExpenseTran post = new ExpenseTran()
{
ExpTypeId = expId,
PostingDate = dateTimePicker1.Value.Date,
Amount = decimal.Parse(txtAmount.Text),
CreatedBy = Form1.userId,
CreatedOn = System.DateTime.Now,
Description = txtExpType.Text + " : " + txtDescription.Text
};
ctx.ExpenseTrans.Add(post);
ctx.SaveChanges();
expId = 0;
}
catch (Exception)
{
lblError.Text = "Database error has occurred!";
lblError.ForeColor = Color.Yellow;
}
}
