public Int64 Insert(ProductGroupChargeDetails Details) { try { Save(Details); string SQL = "SELECT LAST_INSERT_ID();"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID"); base.MySqlDataAdapterFill(cmd, dt); Int64 iID = 0; foreach (System.Data.DataRow dr in dt.Rows) { iID = Int64.Parse(dr[0].ToString()); } return(iID); } catch (Exception ex) { throw base.ThrowException(ex); } }
public void Update(ProductGroupChargeDetails Details) { try { string SQL = "UPDATE tblProductGroupCharges SET " + "ChargeTypeID = @ChargeTypeID, "+ "ChargeAmount = @ChargeAmount, "+ "InPercent = @InPercent "+ "WHERE GroupID = @GroupID "+ "AND ChargeID = @ChargeID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@ChargeTypeID", Details.ChargeTypeID); cmd.Parameters.AddWithValue("@ChargeAmount", Details.ChargeAmount); cmd.Parameters.AddWithValue("@InPercent", Details.InPercent); cmd.Parameters.AddWithValue("@GroupID", Details.GroupID); cmd.Parameters.AddWithValue("@ChargeID", Details.ChargeID); base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 Save(ProductGroupChargeDetails Details) { try { string SQL = "CALL procSaveProductGroupCharges(@ChargeID, @GroupID, @ChargeTypeID, @ChargeAmount, @InPercent, @CreatedOn, @LastModified);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("ChargeID", Details.ChargeID); cmd.Parameters.AddWithValue("GroupID", Details.GroupID); cmd.Parameters.AddWithValue("ChargeTypeID", Details.ChargeTypeID); cmd.Parameters.AddWithValue("ChargeAmount", Details.ChargeAmount); cmd.Parameters.AddWithValue("InPercent", Details.InPercent); cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn); cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified); return(base.ExecuteNonQuery(cmd)); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int64 Insert(ProductGroupChargeDetails Details) { try { Save(Details); string SQL = "SELECT LAST_INSERT_ID();"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID"); base.MySqlDataAdapterFill(cmd, dt); Int64 iID = 0; foreach (System.Data.DataRow dr in dt.Rows) { iID = Int64.Parse(dr[0].ToString()); } return iID; } catch (Exception ex) { throw base.ThrowException(ex); } }
public ProductGroupChargeDetails Details(Int64 ChargeID) { try { string SQL = "SELECT " + "a.ChargeID, " + "a.GroupID, " + "a.ChargeTypeID, " + "b.ChargeType, " + "a.ChargeAmount, " + "a.InPercent " + "FROM tblProductGroupCharges a " + "LEFT JOIN tblChargeType b ON a.ChargeTypeID = b.ChargeTypeID " + "WHERE ChargeID = @ChargeID "; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmChargeID = new MySqlParameter("@ChargeID", MySqlDbType.Int64); prmChargeID.Value = ChargeID; cmd.Parameters.Add(prmChargeID); ProductGroupChargeDetails Details = new ProductGroupChargeDetails(); MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); while (myReader.Read()) { Details.ChargeID = myReader.GetInt64("ChargeID"); Details.GroupID = myReader.GetInt64("GroupID"); Details.ChargeTypeID = myReader.GetInt32("ChargeTypeID"); Details.ChargeType = "" + myReader["ChargeType"].ToString(); Details.ChargeAmount = myReader.GetDecimal("ChargeAmount"); Details.InPercent = myReader.GetBoolean("InPercent"); } myReader.Close(); return(Details); } catch (Exception ex) { throw base.ThrowException(ex); } }
private void SaveRecord() { ProductGroupCharges clsProductGroupCharge = new ProductGroupCharges(); ProductGroupChargeDetails clsDetails = new ProductGroupChargeDetails(); clsDetails.ChargeID = Convert.ToInt64(lblChargeID.Text); clsDetails.GroupID = Convert.ToInt64(lblProductGroupID.Text); clsDetails.ChargeTypeID = Convert.ToInt32(cboChargeType.SelectedItem.Value); clsDetails.ChargeType = cboChargeType.SelectedItem.Text; clsDetails.ChargeAmount = Convert.ToDecimal(txtChargeAmount.Text); clsDetails.InPercent = chkInPercent.Checked; clsProductGroupCharge.Update(clsDetails); clsProductGroupCharge.CommitAndDispose(); }
public void Update(ProductGroupChargeDetails Details) { try { string SQL = "UPDATE tblProductGroupCharges SET " + "ChargeTypeID = @ChargeTypeID, " + "ChargeAmount = @ChargeAmount, " + "InPercent = @InPercent " + "WHERE GroupID = @GroupID " + "AND ChargeID = @ChargeID;"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@ChargeTypeID", Details.ChargeTypeID); cmd.Parameters.AddWithValue("@ChargeAmount", Details.ChargeAmount); cmd.Parameters.AddWithValue("@InPercent", Details.InPercent); cmd.Parameters.AddWithValue("@GroupID", Details.GroupID); cmd.Parameters.AddWithValue("@ChargeID", Details.ChargeID); base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
public ProductGroupChargeDetails Details(Int64 ChargeID) { try { string SQL = "SELECT " + "a.ChargeID, " + "a.GroupID, " + "a.ChargeTypeID, " + "b.ChargeType, " + "a.ChargeAmount, " + "a.InPercent " + "FROM tblProductGroupCharges a " + "LEFT JOIN tblChargeType b ON a.ChargeTypeID = b.ChargeTypeID " + "WHERE ChargeID = @ChargeID "; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; MySqlParameter prmChargeID = new MySqlParameter("@ChargeID",MySqlDbType.Int64); prmChargeID.Value = ChargeID; cmd.Parameters.Add(prmChargeID); ProductGroupChargeDetails Details = new ProductGroupChargeDetails(); MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); while (myReader.Read()) { Details.ChargeID = myReader.GetInt64("ChargeID"); Details.GroupID = myReader.GetInt64("GroupID"); Details.ChargeTypeID = myReader.GetInt32("ChargeTypeID"); Details.ChargeType = "" + myReader["ChargeType"].ToString(); Details.ChargeAmount = myReader.GetDecimal("ChargeAmount"); Details.InPercent = myReader.GetBoolean("InPercent"); } myReader.Close(); return Details; } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int32 Save(ProductGroupChargeDetails Details) { try { string SQL = "CALL procSaveProductGroupCharges(@ChargeID, @GroupID, @ChargeTypeID, @ChargeAmount, @InPercent, @CreatedOn, @LastModified);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("ChargeID", Details.ChargeID); cmd.Parameters.AddWithValue("GroupID", Details.GroupID); cmd.Parameters.AddWithValue("ChargeTypeID", Details.ChargeTypeID); cmd.Parameters.AddWithValue("ChargeAmount", Details.ChargeAmount); cmd.Parameters.AddWithValue("InPercent", Details.InPercent); cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn); cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified); return base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }