private void btnSave_Click(object sender, EventArgs e) { slot.InStatus = cmbInOrOut.SelectedIndex == 0 ? false : true; slot.OccupaidStatus = cmbOccupaid.SelectedIndex == 0 ? false : true; slot.FK_CustomerId = entTransactions.FK_Customer; slot.FK_StaffId = cmbStaff.SelectedValue.ToInt32(); if (ORMForSDF.UpdateToDatabaseObj(slot, "Slot", "Id", slot.Id.toInt32(), Properties.Settings.Default.Connection)) { string status = string.Empty; if (cmbOccupaid.SelectedIndex == 0) { status = "Alotment Removed"; } else { if (cmbInOrOut.SelectedIndex == 0) { status = "Outed"; } else { status = "In"; } } entTransactions.FK_Staff = cmbStaff.SelectedValue.ToInt32(); entTransactions.Date = DateTime.Now; entTransactions.Status = status; if (ORMForSDF.InsertToDatabaseObj(entTransactions, "Transactions", Properties.Settings.Default.Connection)) { this.DialogResult = System.Windows.Forms.DialogResult.OK; this.Close(); } } this.DialogResult = DialogResult.OK; this.Close(); }
private void txtSearch_TextChanged(object sender, EventArgs e) { exCustomerDataGridView.DataSource = null; if (txtSearch.Text == string.Empty) { return; } List <ExCustomer> exCustomers = new List <ExCustomer>(); DataTable dt = ORMForSDF.GetDataTableWithIdParameter_SP("spGetCustomerReport", new { sText = txtSearch.Text }, Properties.Settings.Default.Connection); int iCount = 1; foreach (DataRow item in dt.Rows) { ExCustomer exCustomer = new ExCustomer(); exCustomer.SL = iCount; exCustomer.Id = item[0].ToInt32(); exCustomer.Name = item[1].ToString(); exCustomer.PanNumber = item[2].ToString(); exCustomer.Company = item[3].ToString(); exCustomer.Careof = item[4].ToString(); exCustomer.isExpaired = item[5].ToString().ToBool(); exCustomer.Staffname = item[6].ToString(); exCustomer.Expaired = exCustomer.isExpaired ? "Expaired" : "Active"; iCount++; exCustomers.Add(exCustomer); } exCustomerDataGridView.AutoGenerateColumns = false; exCustomerDataGridView.DataSource = exCustomers; }
private void GenerateReports(int iValue) { List <ExTransactions> exTransactions = new List <ExTransactions>(); exTransactions = ORMForSDF.GetList_SP <ExTransactions>("spGetTransactionForMainReport", new { Val = iValue }, Properties.Settings.Default.Connection); dgvReports.AutoGenerateColumns = false; dgvReports.DataSource = exTransactions; }
private void GenerateReports(string sText) { List <ExTransactions> exTransactions = new List <ExTransactions>(); exTransactions = ORMForSDF.GetList_SP <ExTransactions>("spGetTransactionReport", new { sText = txtSearch.Text }, Properties.Settings.Default.Connection); dgvReports.AutoGenerateColumns = false; dgvReports.DataSource = exTransactions; }
private void txtPanNo_TextChanged(object sender, EventArgs e) { dgvReports.DataSource = null; List <ExTransactions> exTransactions = new List <ExTransactions>(); exTransactions = ORMForSDF.GetList_SP <ExTransactions>("spGetTransactionReport", new { sText = txtSearch.Text }, Properties.Settings.Default.Connection); dgvReports.AutoGenerateColumns = false; dgvReports.DataSource = exTransactions; }
private void btnSave_Click(object sender, EventArgs e) { if (txtName.Text == string.Empty || txtPanNo.Text == string.Empty) { Messages.WarningMessage(); return; } var customer = new Customer { Id = iCustomerId, Name = txtName.Text, PanNumber = txtPanNo.Text, Company = txtCompany.Text, Careof = txtCareof.Text, Password = txtPassword.Text, Fk_SlotId = cmbSlot.SelectedValue.ToInt32(), Fk_StaffId = cmbStaff.SelectedValue.ToInt32(), isExpaired = cmbExpaired.SelectedIndex == 0 ? false : true }; if (iCustomerId == null || !db.Customers.Any(x => x.Id == iCustomerId)) { if (ORMForSDF.InsertToDatabaseObj(customer, "Customer", Properties.Settings.Default.Connection)) { customer = db.Customers.FirstOrDefault(x => x.Name == txtName.Text); Slot slot = db.Slots.FirstOrDefault(x => x.Id == cmbSlot.SelectedValue.ToInt32()); slot.OccupaidStatus = true; slot.InStatus = true; slot.FK_CustomerId = customer.Id; slot.FK_StaffId = cmbStaff.SelectedValue.ToInt32(); ORMForSDF.UpdateToDatabaseObj(slot, "Slot", "Id", slot.Id.toInt32(), Properties.Settings.Default.Connection); var transaction = new Transactions { Id = null, FK_Customer = slot.FK_CustomerId, FK_Slot = slot.Id, FK_Staff = cmbStaff.SelectedValue.ToInt32(), Date = DateTime.Now.Date, Status = "Allotted", Remarks = "" }; if (ORMForSDF.InsertToDatabaseObj(transaction, "Transactions", Properties.Settings.Default.Connection)) { var trans = new Transactions { Id = null, FK_Customer = slot.FK_CustomerId, FK_Slot = slot.Id, FK_Staff = cmbStaff.SelectedValue.ToInt32(), Date = DateTime.Now.Date, Status = "In", Remarks = "" }; if (ORMForSDF.InsertToDatabaseObj(trans, "Transactions", Properties.Settings.Default.Connection)) { Messages.SavedMessage(); btnClear_Click(null, null); } } } } else { if (ORMForSDF.UpdateToDatabaseObj(customer, "Customer", "Id", iCustomerId.toInt32(), Properties.Settings.Default.Connection)) { Messages.UpdateMessage(); btnClear_Click(null, null); } } }
private void btnDelete_Click(object sender, EventArgs e) { if (Messages.DeleteConfirmationMessage() && iBoxId != null) { if (ORMForSDF.DeleteFromDatabase("Slot", "FK_BoxId", iBoxId.toInt32(), Properties.Settings.Default.Connection)) { if (ORMForSDF.DeleteFromDatabase("Box", "Id", iBoxId.toInt32(), Properties.Settings.Default.Connection)) { btnClear_Click(null, null); } } } }
private void btnDelete_Click(object sender, EventArgs e) { if (Messages.DeleteConfirmationMessage() && iStaffId != null) { if (db.Transactions.Where(x => x.FK_Staff == iStaffId).ToList().Count > 0) { Messages.ReferenceExistsMessage(); return; } if (ORMForSDF.DeleteFromDatabase("Staff", "Id", iStaffId.toInt32(), Properties.Settings.Default.Connection)) { btnClear_Click(null, null); } } }
private void btnSave_Click(object sender, EventArgs e) { if (txtName.Text == string.Empty && slots.Count > 0) { Messages.ErrorMessage("Please fill the details."); return; } var box = new Box { Id = iBoxId, Name = txtName.Text, FK_StaffId = cmbStaff.SelectedValue.ToInt32(), CreatedOn = DateTime.Now.Date }; if (iBoxId == null) { if (ORMForSDF.InsertToDatabaseObj(box, "Box", Properties.Settings.Default.Connection)) { box = db.Boxes.FirstOrDefault(x => x.Name == txtName.Text); if (box.Id != null) { foreach (var item in slots) { item.FK_BoxId = box.Id.ToInt32(); } ORMForSDF.InsertToDatabase(slots.Cast <object>().ToList(), "Slot", Properties.Settings.Default.Connection); Messages.SavedMessage(); btnClear_Click(null, null); } } } else { if (ORMForSDF.UpdateToDatabaseObj(box, "Box", "Id", iBoxId.toInt32(), Properties.Settings.Default.Connection)) { if (iBoxId != null) { foreach (var item in slots) { item.FK_BoxId = iBoxId.ToInt32(); } ORMForSDF.UpdateDatabase(slots.Cast <object>().ToList(), oldSlots.Cast <object>().ToList(), "Slot", "Id", Properties.Settings.Default.Connection); Messages.UpdateMessage(); btnClear_Click(null, null); } } } }
private void btnSave_Click(object sender, EventArgs e) { if (txtName.Text == string.Empty) { Messages.ErrorMessage("Please fill the details."); return; } if (iStaffId == null || !db.Staffs.Any(x => x.Id == iStaffId)) { if (isFirstEntry) { if (ORMForSDF.InsertToDatabaseObj(new Staff { Id = null, Name = txtName.Text, Password = txtPassword.Text }, "Staff", Properties.Settings.Default.Connection)) { Login frm = new Login(); this.Hide(); frm.Show(); } } else { if (db.Staffs.FirstOrDefault(x => x.Id == User.iUserId).Name == "Admin") { if (ORMForSDF.InsertToDatabaseObj(new Staff { Id = null, Name = txtName.Text, Password = txtPassword.Text }, "Staff", Properties.Settings.Default.Connection)) { Messages.SavedMessage(); btnClear_Click(null, null); } } else { Messages.ErrorMessage("Only Admin have power to create new User."); } } } else { if (ORMForSDF.UpdateToDatabaseObj(new Staff { Id = iStaffId, Name = txtName.Text, Password = txtPassword.Text }, "Staff", "Id", iStaffId.toInt32(), Properties.Settings.Default.Connection)) { Messages.UpdateMessage(); btnClear_Click(null, null); } ; } }
private void btnDelete_Click(object sender, EventArgs e) { if (Messages.DeleteConfirmationMessage() && iCustomerId != null) { foreach (var item in db.Slots.Where(x => x.FK_CustomerId == iCustomerId)) { item.InStatus = false; item.OccupaidStatus = false; ORMForSDF.UpdateToDatabaseObj(item, "Slot", "Id", item.Id.toInt32(), Properties.Settings.Default.Connection); } ORMForSDF.DeleteFromDatabase("Transactions", "FK_Customer", iCustomerId.ToInt32(), Properties.Settings.Default.Connection); if (ORMForSDF.DeleteFromDatabase("Customer", "Id", iCustomerId.toInt32(), Properties.Settings.Default.Connection)) { btnClear_Click(null, null); } } }
private void txtSearch_TextChanged(object sender, EventArgs e) { dgDetails.DataSource = null; dgvReports.DataSource = null; AniHelper.PanelClearMethod(pnlCustomer); if (txtSearch.Text == string.Empty) { return; } List <Customer> exCustomers = new List <Customer>(); exCustomers = ORMForSDF.GetList_SP <Customer>("spGetMainCusomers", new { sText = txtSearch.Text }, Properties.Settings.Default.Connection); if (exCustomers.Count > 0) { dgDetails.AutoGenerateColumns = false; dgDetails.DataSource = exCustomers; customer = exCustomers.FirstOrDefault(); CustomerLoadMethod(); GenerateReports(txtSearch.Text); } }