public Int32 Save(DiscountDetails Details)
{
try
{
string SQL = "CALL procSaveDiscount(@DiscountID, @DiscountCode, @DiscountType, @DiscountPrice, @InPercent, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("DiscountID", Details.DiscountID);
cmd.Parameters.AddWithValue("DiscountCode", Details.DiscountCode);
cmd.Parameters.AddWithValue("DiscountType", Details.DiscountType);
cmd.Parameters.AddWithValue("DiscountPrice", Details.DiscountPrice);
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 Int32 Save(DiscountDetails Details)
{
try
{
string SQL = "CALL procSaveDiscount(@DiscountID, @DiscountCode, @DiscountType, @DiscountPrice, @InPercent, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("DiscountID", Details.DiscountID);
cmd.Parameters.AddWithValue("DiscountCode", Details.DiscountCode);
cmd.Parameters.AddWithValue("DiscountType", Details.DiscountType);
cmd.Parameters.AddWithValue("DiscountPrice", Details.DiscountPrice);
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 DiscountDetails Details(string DiscountCode)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = SQLSelect() + "WHERE DiscountCode = @DiscountCode;";
cmd.Parameters.AddWithValue("@DiscountCode", DiscountCode);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
DiscountDetails Details = new DiscountDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.DiscountID = Int32.Parse(dr["DiscountID"].ToString());
Details.DiscountCode = "" + dr["DiscountCode"].ToString();
Details.DiscountType = "" + dr["DiscountType"].ToString();
Details.DiscountPrice = Decimal.Parse(dr["DiscountPrice"].ToString());
Details.InPercent = bool.Parse(dr["InPercent"].ToString());
}
return(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(DiscountDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(DiscountDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Insert(DiscountDetails Details)
{
try
{
Save(Details);
return Int32.Parse(base.getLAST_INSERT_ID(this));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Insert(DiscountDetails Details)
{
try
{
Save(Details);
return(Int32.Parse(base.getLAST_INSERT_ID(this)));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public DiscountDetails Details(string DiscountCode)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL= SQLSelect() + "WHERE DiscountCode = @DiscountCode;";
cmd.Parameters.AddWithValue("@DiscountCode", DiscountCode);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
DiscountDetails Details = new DiscountDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.DiscountID = Int32.Parse(dr["DiscountID"].ToString());
Details.DiscountCode = "" + dr["DiscountCode"].ToString();
Details.DiscountType = "" + dr["DiscountType"].ToString();
Details.DiscountPrice = Decimal.Parse(dr["DiscountPrice"].ToString());
Details.InPercent = bool.Parse(dr["InPercent"].ToString());
}
return Details;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private Int32 SaveRecord()
{
Discount clsDiscount = new Discount();
DiscountDetails clsDetails = new DiscountDetails();
clsDetails.DiscountCode = txtDiscountCode.Text;
clsDetails.DiscountType = txtDiscountType.Text;
clsDetails.DiscountPrice = Convert.ToDecimal(txtDiscountPrice.Text);
clsDetails.InPercent = Convert.ToBoolean(chkInPercent.Checked);
int id = clsDiscount.Insert(clsDetails);
clsDiscount.CommitAndDispose();
return id;
}
private void SaveRecord()
{
Discount clsDiscount = new Discount();
DiscountDetails clsDetails = new DiscountDetails();
clsDetails.DiscountID = Convert.ToInt16(lblDiscountID.Text);
clsDetails.DiscountCode = txtDiscountCode.Text;
clsDetails.DiscountType = txtDiscountType.Text;
clsDetails.DiscountPrice = Convert.ToDecimal(txtDiscountPrice.Text);
clsDetails.InPercent = Convert.ToBoolean(chkInPercent.Checked);
clsDiscount.Update(clsDetails);
clsDiscount.CommitAndDispose();
}
