private void button1_Click(object sender, EventArgs e) { try { if (isUpdate) { DialogResult drResult = MessageBox.Show("Are you sure you want to update the entry?", "Saving Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (drResult == DialogResult.Yes) { string Query = "Update tbl_CONDO_FloorInfo set FloorName = '" + tbFloorName.Text + "',FloorDescription='" + tbDescription.Text + "',LastUpdateUser="******",LastDateDefined='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' where sysID=" + ForUpdate_SysID; bool isUpdateSuccess = dtrans.InsertData(Query); if (isUpdateSuccess) { MessageBox.Show("Entry successfully updated.", "Update Done", MessageBoxButtons.OK); tbDescription.Text = string.Empty; tbFloorName.Text = string.Empty; isUpdate = false; } } button2.Enabled = true; return; } if (dataGridView1.Rows.Count > 0) { DialogResult drResult = MessageBox.Show("Are you sure you want to save the following entries?", "Saving Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (drResult == DialogResult.Yes) { foreach (DataGridViewRow dgrow in dataGridView1.Rows) { Thread.Sleep(100); string Query = "Insert into tbl_CONDO_FloorInfo(FloorName,FloorDescription,userid) values('" + dgrow.Cells["FloorName"].Value.ToString() + "','" + dgrow.Cells["FloorDescription"].Value.ToString() + "',-1)"; dgrow.Cells["IsSaved"].Value = dtrans.InsertData(Query); } MessageBox.Show("Data Entry was successfully saved.", "Save Done", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } else { MessageBox.Show("Error: No Information to Saved.", "Saved Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message.ToString(), "Unexpected Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button2_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(tbYear.Text)) { MessageBox.Show("Error: Invalid Year. Please check your year", "Year Invalid.", MessageBoxButtons.OK, MessageBoxIcon.Error); tbYear.Focus(); return; } if (!cv.isInteger(tbYear.Text)) { MessageBox.Show("Error: Invalid Year. Please check your year", "Year Invalid.", MessageBoxButtons.OK, MessageBoxIcon.Error); tbYear.Focus(); return; } if (dtStart.Value > dtEnd.Value) { MessageBox.Show("Error: Date End must be greater than Date Start. Please check your Covered Date", "Year Invalid.", MessageBoxButtons.OK, MessageBoxIcon.Error); dtStart.Focus(); return; } DialogResult drSaveConfirm = MessageBox.Show("Are you sure you want to save this cutoff for month : " + cbMonth.Text + " " + tbYear.Text + "?", "Confirm to Save Cut-off for " + cbMonth.Text + " " + tbYear.Text + "?", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (drSaveConfirm == DialogResult.Yes) { string PrimaryKey = tbYear.Text + ":" + cbMonth.Text; //(int.Parse(cbMonth.SelectedIndex.ToString()) + 1); string QueryInsert = "Insert into tbl_condo_cutoffinfo(PrimaryKey,Year,Month,BillStart,BillEnd,DueDate,isEnabled,CreatedBy)values('" + PrimaryKey + "'," + tbYear.Text + "," + (cbMonth.SelectedIndex + 1) + ",'" + dtStart.Value.ToString("yyyy-MM-dd 00:00:00") + "','" + dtEnd.Value.ToString("yyyy-MM-dd 00:00:00") + "','" + dtDueDate.Value.ToString("yyyy-MM-dd 00:00:00") + "'," + (cbIsEnabled.Checked ? 1 : 0) + "," + UserID + ")"; dtrans.InsertData(QueryInsert); LoadRecords(); } }
private bool CheckandInjectCode(clsVariableSettings cvs) { bool result = false; try { string SQLSelectSystemInfo = "select Count(*) from tbl_system_info where isEnabled = 1 and ProgramCode='" + cv.Crypt(programname) + "' and LicenseCode = '" + cvs.LicenseCode + "' and ActivationCode = '" + cvs.ActivationCode + "'"; cdt = new clsDatabaseTransactions(); DataTable dtResult = cdt.SelectData(SQLSelectSystemInfo); int RowAffected = dtResult.Rows.Count; RowAffected = RowAffected == 1 ? int.Parse(dtResult.Rows[0][0].ToString()) : 0; if (RowAffected == 0) { string SQLInsertSystemInfo = "Insert into tbl_system_info(ProgramCode,LicenseCode,ActivationCode)" + " Values ('" + cv.Crypt(programname) + "','" + cvs.LicenseCode + "','" + cvs.ActivationCode + "')"; result = cdt.InsertData(SQLInsertSystemInfo); } else { result = true; } } catch { } return(result); }
private void button1_Click(object sender, EventArgs e) { if (dataGridView1.Rows.Count == 0) { MessageBox.Show("Error: Cannot save record. Please check your entry.", "No Record to add", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (isUpdate) { DialogResult drResult = MessageBox.Show("Are you sure you want to update the entry?", "Saving Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (drResult == DialogResult.Yes) { string Query = "Update tbl_CONDO_UnitInfo set UnitName = '" + tbUnitName.Text + "',UnitDescription='" + tbDescription.Text + "',FloorAssociate=" + cbFloorList.SelectedValue + ",AreaSQM=" + tbArea.Text + ",MonthlyDue=" + tbMonthlyDue.Text + ",IsMonthlyDueComputed=" + (checkBox1.Checked ? 1:0).ToString() + ",LastUpdateUser="******",LastDateDefined='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' where sysID=" + ForUpdate_SysID; bool isUpdateSuccess = dtrans.InsertData(Query); if (isUpdateSuccess) { MessageBox.Show("Entry successfully updated.", "Update Done", MessageBoxButtons.OK); tbDescription.Text = string.Empty; tbUnitName.Text = string.Empty; isUpdate = false; } } button2.Enabled = true; return; } foreach (DataGridViewRow dgrow in dataGridView1.Rows) { int FloorID = int.Parse(dtrans.SelectData("Select sysID from tbl_CONDO_FloorInfo where Floorname='" + dgrow.Cells["FloorName"].Value.ToString() + "'").Rows[0][0].ToString()); string Query = "Insert into tbl_CONDO_UnitInfo(UnitName,FloorAssociate,Description,AreaSQM,isMontlyDueComputed,MonthlyDue,TotalDue,CreatedBy)Values('" + dgrow.Cells["UnitName"].Value.ToString() + "'," + FloorID + ",'" + dgrow.Cells["UnitDescription"].Value.ToString() + "'," + dgrow.Cells["Size"].Value.ToString() + "," + (dgrow.Cells["MonthlyDueSQM"].Value.ToString() != "0" ? 1:0) + "," + dgrow.Cells["MonthlyDueSQM"].Value.ToString() + "," + dgrow.Cells["TotalDue"].Value.ToString() + "," + UserID + ")"; if (dtrans.InsertData(Query)) { MessageBox.Show("Record successfully saved. ", "Record Saved", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else { MessageBox.Show("Error: Unable to insert record. Kindly Check your entry", "Saving Record Failed", MessageBoxButtons.OK, MessageBoxIcon.Error); break; } } }
private bool SaveCustomer() { bool result = false; try { string PrimaryName = checkBox1.Checked ? tbAlias.Text : tbLastname.Text + "_" + tbFirstname.Text + "_" + tbMiddleName.Text; int isAlias = checkBox1.Checked ? 1:0; string InsertQuery = "insert into tbl_CONDO_CustomerInfo(PrimaryNames,Lastname,FirstName,MiddleName,Alias,UseAlias,ContactNumber,UnitNo,PhotoPath,Notes,CreatedBy) Values ('" + PrimaryName + "','" + tbLastname.Text + "','" + tbFirstname.Text + "','" + tbMiddleName.Text + "','" + tbAlias.Text + "'," + isAlias + ",'" + tbContact.Text + "'," + cbUnit.SelectedValue.ToString() + ",'" + lblPicPath.Text + "','" + tbNotes.Text + "'," + UserID + ")"; if (dtrans.InsertData(InsertQuery)) { MessageBox.Show("Customer Information saved.", "Done Saving Information", MessageBoxButtons.OK, MessageBoxIcon.Information); result = true; } } catch (Exception ex) { MessageBox.Show("Error:" + ex.Message.ToString(), "Error Saving Customer", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(result); }
private void button1_Click(object sender, EventArgs e) { clsValidation cv = new clsValidation(); if (dataGridView1.Rows.Count == 0) { MessageBox.Show("Error: No Details to save on this Billing. Please check", "Cannot save Billing Information", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (cbCutoff.Text == "") { MessageBox.Show("Error: No Cut-off defined on this Billing. Please check", "Cannot save Billing Information", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } DialogResult dr = MessageBox.Show("Are you sure you want to save this Billing Information?", "Confirm Saving Billing Information", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { string PrimaryKey = GetLastIDofBilling().ToString("000000000000"); string checkUnitCutoff = "SELECT * FROM tbl_condo_billinginfo WHERE cutoffID = " + cv.GetSysID("where PrimaryKey ='" + cbCutoff.Text.ToString() + "'", "tbl_condo_cutoffinfo") + " AND unitno = " + cbUnitNo.SelectedValue; bool isUnitCheckAgainstCutoff = dtrans.SelectData(checkUnitCutoff).Rows.Count > 0 ? true : false; if (isUnitCheckAgainstCutoff) { MessageBox.Show("Error: Cannot save details for this cut-off. Please check", "Cut-off already exists", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } string BillingInfoQuery = "Insert into tbl_condo_billinginfo(PrimaryKey,CutoffID,CustomerID,UnitNo,TotalAmountDue,PreviousBalanceAsOf,CurrentCharges,CreatedBy)Values('" + PrimaryKey + "'," + cv.isInteger(cv.GetSysID("where PrimaryKey ='" + cbCutoff.Text.ToString() + "'", "tbl_condo_cutoffinfo").ToString()) + "," + lblCustomerID.Text + "," + cbUnitNo.SelectedValue + "," + tbTotalAmount.Text + "," + PreviousBalance + "," + lblCurrenttotal.Text + "," + UserID + ")"; bool isErrorFound = false; if (dtrans.InsertData(BillingInfoQuery)) { if (dataGridView1.Rows.Count > 0) { string GetSySID = cv.GetSysID("where PrimaryKey='" + PrimaryKey + "'", "tbl_condo_billinginfo").ToString(); if (GetSySID == "0") { MessageBox.Show("Error: Cannot save billing. Please check", "Error Saving", MessageBoxButtons.OK, MessageBoxIcon.Error); string DeleteDetails = "Delete from tbl_condo_billinginfo where primarykey='" + PrimaryKey + "'"; dtrans.InsertData(DeleteDetails); isErrorFound = true; return; } foreach (DataGridViewRow dgrow in dataGridView1.Rows) { string GetManualNotes = string.IsNullOrEmpty(dgrow.Cells["ManualNotes"].Value.ToString()) ? dgrow.Cells["ManualNotes"].Value.ToString() : string.Empty; string BillingRefID = GetLastIDofBillingDetails(GetSySID).ToString(); string BillingDetailsQuery = "Insert into tbl_condo_billingdetails(PrimaryKey,BillingRefID,BillingDescription,BillingAmount,BillingNotes,CreatedBy)values('" + PrimaryKey + "_" + BillingRefID + "'," + GetSySID + ",'" + dgrow.Cells["Transaction"].Value.ToString() + "'," + dgrow.Cells["Amount"].Value.ToString() + ",'" + GetManualNotes + "'," + UserID + ")"; if (!dtrans.InsertData(BillingDetailsQuery)) { MessageBox.Show("Error: Cannot save billing details. Please check", "Error Saving", MessageBoxButtons.OK, MessageBoxIcon.Error); string DeleteDetails = "Delete from tbl_condo_billingdetails where billingRefID=" + GetSySID; dtrans.InsertData(DeleteDetails); isErrorFound = true; break; } } } if (!isErrorFound) { MessageBox.Show("Billing information saved", "Done Saving", MessageBoxButtons.OK, MessageBoxIcon.Information); } TransactionTable(); dataGridView1.DataSource = dtTransactions; } } }