private void saveAddDetails(String sid, String bid, String did, string stime, string etime, String aGen, String atten) { try { if (clsDatabase_Connection.ExecuteQuery("Insert into tblClassTimes values ('" + sid + "','" + bid + "','" + did + "','" + stime + "','" + etime + "','" + getTimeDuration() + "','" + aGen + "','" + atten + "','True','" + IMS_System.Properties.Settings.Default.current_staff_id + "',GETDATE())") == true) { MainScreen.SucessMessageShow("Sucessfully Added", "INFO"); } else { new frmMessageBox("error", "Insert", "You can not add this. Some errors occurred!", false, MainScreen).ShowDialog(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void saveAddDetails(string des, string mtd, string mode, string amount) { try { if (clsDatabase_Connection.ExecuteQuery("Insert into tblAccounts values ('" + des + "','" + mtd + "','" + amount + "','" + mode + "',GETDATE(),'" + IMS_System.Properties.Settings.Default.current_staff_id + "',GETDATE(),'True')") == true) { MainScreen.SucessMessageShow("Sucessfully Added", "INFO"); } else { new frmMessageBox("error", "Insert", "You can not add this. Some errors occurred!", false, MainScreen).ShowDialog(); } } catch (Exception ex) { MessageBox.Show("1" + ex.Message); } }
private void AddBatchDetails(String BatchName) { try { if (clsDatabase_Connection.ExecuteQuery("Insert into tblBatch values ('" + BatchName + "','True','" + IMS_System.Properties.Settings.Default.current_staff_id + "',GETDATE())") == true) { MainScreen.SucessMessageShow("Sucessfully Added", "INFO"); } else { new frmMessageBox("error", "Insert", "You can not add this. Some errors occurred!", false, MainScreen).ShowDialog(); } Add_Details_to_Datagridview(); txtValue.Text = ""; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void AddBatchDetails(int subjectid, int batchid, string amount) { try { Clipboard.SetText(("Insert into tblSubjectAmount values ('" + subject_id[subjectid] + "','" + batch_id[batchid] + "','" + amount + "','True','" + IMS_System.Properties.Settings.Default.current_staff_id + "',GETDATE(),'" + checkBox2.CheckState + "')")); if (clsDatabase_Connection.ExecuteQuery("Insert into tblSubjectAmount values ('" + subject_id[subjectid] + "','" + batch_id[batchid] + "','" + amount + "','True','" + IMS_System.Properties.Settings.Default.current_staff_id + "',GETDATE(),'" + checkBox2.CheckState + "')") == true) { MainScreen.SucessMessageShow("Sucessfully Added", "INFO"); } else { new frmMessageBox("error", "Insert", "You can not add this. Some errors occurred!", false, MainScreen).ShowDialog(); } Add_Details_to_Datagridview(); txtValue.Text = ""; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void UpdateStudentDetails() { try { if (!txtBarcode.Text.Equals(currentBarcode[0])) { UpdateBarcode(txtBarcode.Text.Trim()); } updateOtherDetails(); UpdateAdditionalDetails(); SaveSelectedBatches(); Save_Details(); MainScreen.SucessMessageShow("Sucessfully Changed", "INFO"); Dispose(); } catch (Exception ex) { MessageBox.Show("UP " + ex.Message); } }
private void UpdateActivation(String Value, string selectedIndex) { try { if (Value.Equals("True")) { if (clsDatabase_Connection.ExecuteQuery("update tblClassTimes set TimeStatus='" + Value + "',CreatedBy='" + IMS_System.Properties.Settings.Default.current_staff_id + "',CreatedDate=GETDATE() where ClassId='" + selectedIndex + "'") == true) { MainScreen.SucessMessageShow("Sucessfully Activated", "INFO"); } else { new frmMessageBox("error", "Activate", "You can not Activate this. Some errors occurred!", false, MainScreen).ShowDialog(); } } else { if (clsDatabase_Connection.ExecuteQuery("update tblClassTimes set TimeStatus='" + Value + "',CreatedBy='" + IMS_System.Properties.Settings.Default.current_staff_id + "',CreatedDate=GETDATE() where ClassId='" + selectedIndex + "'") == true) { MainScreen.SucessMessageShow("Sucessfully Deactivated", "INFO"); } else { new frmMessageBox("error", "Deactivate", "You can not Deactivate this. Some errors occurred!", false, MainScreen).ShowDialog(); } } Add_Details_to_Datagridview(DgvQuery); button1.Enabled = false; } catch (Exception ex) { MessageBox.Show(ex.Message); } }