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