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)); } }
public static DataTable GetAllLabTestPrice() { clsSQL sql = new clsSQL(); return(sql.GetDataSet("Select labtest.labTestPK,labTest.labTestCode,labTest.labTestName, tbllabtestprice.* from tblLabTest labtest left join tblLabTestPrice on labtest.labTestPK=tblLabTestPrice.labTestPK").Tables[0]); }
public static DataTable GetAllLabTest() { clsSQL sql = new clsSQL(); return sql.GetDataSet("select * from tblLabTest").Tables[0]; }