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