public void Update(ProductSubGroupChargeDetails Details) { try { string SQL = "UPDATE tblProductSubGroupCharges SET " + "ChargeTypeID = @ChargeTypeID, "+ "ChargeAmount = @ChargeAmount, "+ "InPercent = @InPercent "+ "WHERE SubGroupID = @SubGroupID "+ "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("@SubGroupID", Details.SubGroupID); cmd.Parameters.AddWithValue("@ChargeID", Details.ChargeID); base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
public Int64 Insert(ProductSubGroupChargeDetails 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 Int64 Insert(ProductSubGroupChargeDetails 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 Int32 Save(ProductSubGroupChargeDetails Details) { try { string SQL = "CALL procSaveProductSubGroupCharges(@ChargeID, @SubGroupID, @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("SubGroupID", Details.SubGroupID); 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 ProductSubGroupChargeDetails Details(Int64 ChargeID) { try { string SQL = "SELECT " + "a.ChargeID, " + "a.SubGroupID, " + "a.ChargeTypeID, " + "b.ChargeType, " + "a.ChargeAmount, " + "a.InPercent " + "FROM tblProductSubGroupCharges 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); ProductSubGroupChargeDetails Details = new ProductSubGroupChargeDetails(); MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); while (myReader.Read()) { Details.ChargeID = myReader.GetInt64("ChargeID"); Details.SubGroupID = myReader.GetInt64("SubGroupID"); 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 void Update(ProductSubGroupChargeDetails Details) { try { string SQL = "UPDATE tblProductSubGroupCharges SET " + "ChargeTypeID = @ChargeTypeID, " + "ChargeAmount = @ChargeAmount, " + "InPercent = @InPercent " + "WHERE SubGroupID = @SubGroupID " + "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("@SubGroupID", Details.SubGroupID); cmd.Parameters.AddWithValue("@ChargeID", Details.ChargeID); base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
public ProductSubGroupChargeDetails Details(Int64 ChargeID) { try { string SQL = "SELECT " + "a.ChargeID, " + "a.SubGroupID, " + "a.ChargeTypeID, " + "b.ChargeType, " + "a.ChargeAmount, " + "a.InPercent " + "FROM tblProductSubGroupCharges 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); ProductSubGroupChargeDetails Details = new ProductSubGroupChargeDetails(); MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult); while (myReader.Read()) { Details.ChargeID = myReader.GetInt64("ChargeID"); Details.SubGroupID = myReader.GetInt64("SubGroupID"); 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(ProductSubGroupChargeDetails Details) { try { string SQL = "CALL procSaveProductSubGroupCharges(@ChargeID, @SubGroupID, @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("SubGroupID", Details.SubGroupID); 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); } }