public static void Save(string labTestPricePK, string labTestPK, string branchPK, double originalPrice, double profitMargin, int exchangePK, double discount, double sellingPrice) { clsSQL sql = new clsSQL(); bool isExisted = false; isExisted = sql.ExecuteScalar<Int32>("Select Count(*) from tblLabTestPrice where labTestPricePK=@PK", new MySqlParameter("@PK", labTestPricePK)) > 0 ? true : false; if (!isExisted) { //Insert labTestPricePK = Guid.NewGuid().ToString(); sql.ExecuteNonQuery("Insert into tblLabTestPrice(labTestPricePK,labTestPK,branchPK,originalPrice,ProfitMargin,exchangePK,discount,sellingPrice,createPK,createDate,updatePK,updateDate) values(" + "@labTestPricePK,@labTestPK,@branchPK,@originalPrice,@ProfitMargin,@exchangePK,@discount,@sellingPrice,@createPK,@createDate,@updatePK,@updateDate)", new MySqlParameter("labTestPricePK", labTestPK), new MySqlParameter("@labTestPK", labTestPK), new MySqlParameter("@branchPK", branchPK), new MySqlParameter("@originalPrice", originalPrice), new MySqlParameter("@ProfitMargin", profitMargin), new MySqlParameter("@exchangePK", exchangePK), new MySqlParameter("@discount", discount), new MySqlParameter("@sellingPrice", sellingPrice), new MySqlParameter("@createPK", "1"), new MySqlParameter("@createDate", DateTime.Now), new MySqlParameter("@updatePK", "1"), new MySqlParameter("@updateDate", DateTime.Now)); } else { //Update sql.ExecuteNonQuery("Update tblLabTestPrice set labTestPricePK=@labTestPricePK,labTestPK=@labTestPK,branchPK=@branchPK,originalPrice=@originalPrice,ProfitMargin=@ProfitMargin,exchangePK=@exchangePK,discount=@discount,sellingPrice=@sellingPrice," + "updatePK=@updatePK,updateDate=@updateDate where labTestPricePK=@labTestPricePK", new MySqlParameter("labTestPricePK", labTestPricePK), new MySqlParameter("@labTestPK", labTestPK), new MySqlParameter("@branchPK", branchPK), new MySqlParameter("@originalPrice", originalPrice), new MySqlParameter("@ProfitMargin", profitMargin), new MySqlParameter("@exchangePK", exchangePK), new MySqlParameter("@discount", discount), new MySqlParameter("@sellingPrice", sellingPrice), new MySqlParameter("@updatePK", "1"), new MySqlParameter("@updateDate", DateTime.Now)); } }
private void cmdSave_Click(object sender, EventArgs e) { if (ValidateForm() == true) { int LabCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblLabPackage WHERE labPackName=@labPackName AND isDelete=0 AND labPackPK <>@labPackPK", new MySqlParameter("@labPackName", txtName.Text.Trim()), new MySqlParameter("@labPackPK", txtName.Tag)); if (LabCnt > 0) { MessageBox.Show("Your Lab Package name is already exit. Please check your Lab Package name.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Error); txtName.Focus(); txtName.SelectAll(); } else { if (txtName.Tag.ToString().Length > 0) { int LabIDCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblLabPackage WHERE labPackPK=@labPackPK AND isDelete=0", new MySqlParameter("@labPackPK", txtName.Tag.ToString())); if (LabIDCnt > 0) { SqlDb.ExecuteQuery("UPDATE tblLabPackage SET labPackName=@labPackName,labPK=@labPK,isActive=@IsActive,updateDate=NOW(),updatePK=@UpdatePK WHERE labPackPK=@labPackPK", new MySqlParameter("@labPackPK", int.Parse(txtName.Tag.ToString())), new MySqlParameter("@labPK", cboLab.SelectedValue), new MySqlParameter("@labPackName", txtName.Text.Trim()), new MySqlParameter("@IsActive", chkIsActive.EditValue), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK.ToString())); SqlDb.ExecuteNonQuery("Delete from tblLabPackageDetail where labPackPK=@labPackPK", new MySqlParameter("@labPackPK", txtName.Tag)); for (int i = 0; i < dgvPicked.Rows.Count; i++) { SqlDb.ExecuteQuery("Insert into tblLabPackageDetail(labPackPK,labTestPK,createPK,createDate,updatePK,updateDate)" + "values(@labPackPK,@labTestPK,@createPK,NOW(),@updatePK,NOW())", new MySqlParameter("@labPackPK", txtName.Tag), new MySqlParameter("@labTestPK", dgvPicked.Rows[i].Cells[0].Value), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK), new MySqlParameter("@createPK", AppVariable.CURRENT_USER_PK) ); } sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Update Test Name."); MessageBox.Show("Update is successful.", "MediPro :: Clinic System", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { int LabID = SqlDb.ExecuteScalar <int>("Call getID ('tblLabPackage')"); int LabIDCnt = SqlDb.ExecuteScalar <int>("SELECT COUNT(*) FROM tblLabPackage WHERE labPackPK=@labPackPK AND isDelete=0", new MySqlParameter("@labPackPK", LabID)); if (LabIDCnt < 1) { SqlDb.ExecuteQuery("INSERT INTO tblLabPackage(labPackPK,labPackName,labPK,isActive,updateDate,updatePK,createDate,createPK) " + "VALUES(@labPackPK,@labPackName,@labPK,@IsActive,NOW(),@updatePK,NOW(),@createPK)", new MySqlParameter("@labPackPK", LabID), new MySqlParameter("@labPackName", txtName.Text.Trim()), new MySqlParameter("@labPK", cboLab.SelectedValue), new MySqlParameter("@IsActive", chkIsActive.EditValue), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK), new MySqlParameter("@createPK", AppVariable.CURRENT_USER_PK)); for (int i = 0; i < dgvPicked.Rows.Count; i++) { SqlDb.ExecuteQuery("Insert into tblLabPackageDetail(labPackPK,labTestPK,createPK,createDate,updatePK,updateDate)" + "values(@labPackPK,@labTestPK,@createPK,NOW(),@updatePK,NOW())", new MySqlParameter("@labPackPK", LabID), new MySqlParameter("@labTestPK", dgvPicked.Rows[i].Cells[0].Value), new MySqlParameter("@updatePK", AppVariable.CURRENT_USER_PK), new MySqlParameter("@createPK", AppVariable.CURRENT_USER_PK) ); } sysLogs.logsDetail(int.Parse(AppVariable.CURRENT_SUB_MENU.ToString()), "Add New Lab Package."); DialogResult dr = MessageBox.Show("Save is successful. Do you want to create other Package?", "MediPro :: Clinic System", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (dr == DialogResult.Yes) { txtName.Text = string.Empty; txtName.Tag = string.Empty; cboLab.SelectedIndex = -1; dgv.Rows.Clear(); dgvPicked.Rows.Clear(); DataTable dt = SqlDb.GetDataSet("Select labTestPK,labTestName from tblLabTest").Tables[0]; foreach (DataRow ddr in dt.Rows) { dgv.Rows.Add(ddr.ItemArray); } chkIsActive.EditValue = true; txtName.Focus(); } else { this.Close(); } } } } } }