public Int32 Insert(ProductSubGroupVariationDetails 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);
Int32 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int32.Parse(dr[0].ToString());
}
return iID;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Insert(ProductSubGroupVariationDetails 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);
Int32 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int32.Parse(dr[0].ToString());
}
return(iID);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(ProductSubGroupVariationDetails Details, int VarIDToUpdate)
{
try
{
string SQL = "UPDATE tblProductSubGroupVariations SET " +
//"SubGroupID = @SubGroupID, " +
"VariationID = @VariationID " +
"WHERE SubGroupID = @SubGroupID AND VariationID = @VarIDToUpdate;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@SubGroupID", Details.SubGroupID);
cmd.Parameters.AddWithValue("@VariationID", Details.VariationID);
cmd.Parameters.AddWithValue("@VarIDToUpdate", VarIDToUpdate);
base.ExecuteNonQuery(cmd);
SQL = "UPDATE tblProductSubGroupVariationsMatrix a, tblProductSubGroupBaseVariationsMatrix b SET " +
"VariationID = @VariationID " +
"WHERE a.MatrixID = b.MatrixID " +
"AND SubGroupID = @SubGroupID " +
"AND VariationID = @VarIDToUpdate;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@SubGroupID", Details.SubGroupID);
cmd.Parameters.AddWithValue("@VariationID", Details.VariationID);
cmd.Parameters.AddWithValue("@VarIDToUpdate", VarIDToUpdate);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(ProductSubGroupVariationDetails Details, int VarIDToUpdate)
{
try
{
string SQL = "UPDATE tblProductSubGroupVariations SET " +
//"SubGroupID = @SubGroupID, " +
"VariationID = @VariationID " +
"WHERE SubGroupID = @SubGroupID AND VariationID = @VarIDToUpdate;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@SubGroupID", Details.SubGroupID);
cmd.Parameters.AddWithValue("@VariationID", Details.VariationID);
cmd.Parameters.AddWithValue("@VarIDToUpdate", VarIDToUpdate);
base.ExecuteNonQuery(cmd);
SQL = "UPDATE tblProductSubGroupVariationsMatrix a, tblProductSubGroupBaseVariationsMatrix b SET " +
"VariationID = @VariationID " +
"WHERE a.MatrixID = b.MatrixID " +
"AND SubGroupID = @SubGroupID " +
"AND VariationID = @VarIDToUpdate;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("@SubGroupID", Details.SubGroupID);
cmd.Parameters.AddWithValue("@VariationID", Details.VariationID);
cmd.Parameters.AddWithValue("@VarIDToUpdate", VarIDToUpdate);
base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Save(ProductSubGroupVariationDetails Details)
{
try
{
string SQL = "CALL procSaveProductSubGroupVariations(@ProductSubGroupVariationID, @SubGroupID, @VariationID, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("ProductSubGroupVariationID", Details.ProductSubGroupVariationID);
cmd.Parameters.AddWithValue("SubGroupID", Details.SubGroupID);
cmd.Parameters.AddWithValue("VariationID", Details.VariationID);
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(ProductSubGroupVariationDetails Details)
{
try
{
string SQL = "CALL procSaveProductSubGroupVariations(@ProductSubGroupVariationID, @SubGroupID, @VariationID, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("ProductSubGroupVariationID", Details.ProductSubGroupVariationID);
cmd.Parameters.AddWithValue("SubGroupID", Details.SubGroupID);
cmd.Parameters.AddWithValue("VariationID", Details.VariationID);
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);
}
}
private void SaveRecord()
{
ProductSubGroupVariations clsProductSubGroupVariation = new ProductSubGroupVariations();
ProductSubGroupVariationDetails clsDetails = new ProductSubGroupVariationDetails();
clsDetails.SubGroupID = Convert.ToInt64(lblProductSubGroupID.Text);
clsDetails.VariationID = Convert.ToInt32(cboVariationType.SelectedItem.Value);
clsProductSubGroupVariation.Update(clsDetails, Convert.ToInt32(lblProductSubGroupVariationID.Text));
clsProductSubGroupVariation.CommitAndDispose();
}
private Int32 SaveRecord()
{
ProductSubGroupVariations clsProdSubVariation = new ProductSubGroupVariations();
ProductSubGroupVariationDetails clsDetails = new ProductSubGroupVariationDetails();
clsDetails.SubGroupID = Convert.ToInt16(lblProductSubGroupID.Text);
clsDetails.VariationID = Convert.ToInt16(cboVariationType.SelectedItem.Value);
clsDetails.VariationType = cboVariationType.SelectedItem.Text;
int id = clsProdSubVariation.Insert(clsDetails);
clsProdSubVariation.CommitAndDispose();
return id;
}
