protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (this.lblErrorMessage.Text.Length != 0)
{
this.lblErrorMessage.Text = "";
}
ProductSubCategoryInfoDTO dto = populate();
Facade facade = Facade.GetInstance();
IProductSubCategoryInfoBL oCategoryBL = facade.createProductSubCategoryBL();
oCategoryBL.addNewProductSubCategory(dto);
this.lblErrorMessage.Text = "Data Save Successfully.";
this.GridView1.DataBind();
this.txtHideFieldPK.Value = "";
this.txtPSCCode.Text = "";
this.txtPSubCategoryDescription.Text = "";
this.ddlProductCategory.SelectedValue = "";
this.btnSave.Text = "Save";
}
catch (Exception Exp)
{
lblErrorMessage.Text = cls.ErrorString(Exp);
}
}
/// <summary>
/// Set All Information in Domain Class
/// </summary>
/// <returns></returns>
public ProductSubCategoryInfoDTO populate()
{
try
{
string strPC_PK;
ProductSubCategoryInfoDTO dto = new ProductSubCategoryInfoDTO();
// populate dto
if (this.txtHideFieldPK.Value != "")
{
dto.PrimaryKey = (Guid)TypeDescriptor.GetConverter(dto.PrimaryKey).ConvertFromString(this.txtHideFieldPK.Value);
}
if (this.ddlProductCategory.SelectedValue == "00000000-0000-0000-0000-000000000000")
{
throw new Exception("Invalid category.");
}
dto.PSC_Description = this.txtPSubCategoryDescription.Text;
strPC_PK = (string)this.ddlProductCategory.SelectedValue;
dto.PC_PK = (Guid)TypeDescriptor.GetConverter(dto.PC_PK).ConvertFromString(strPC_PK);
dto.EntryBy = "Admin";
dto.EntryDate = DateTime.Now.Date;
return(dto);
}
catch (Exception Exp)
{
throw Exp;
}
}
private void getPKCode(ProductSubCategoryInfoDTO obj)
{
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString());
string strPKCode = null;
int PKSL = 0;
string sqlSelect = "Select isnull(Max(PSC_Code),0)+1 From ProductSubCategoryInfo";
SqlCommand objCmd = sqlConn.CreateCommand();
objCmd.CommandText = sqlSelect;
try
{
sqlConn.Open();
PKSL = (int)objCmd.ExecuteScalar();
}
catch (Exception Exp)
{
throw Exp;
}
finally
{
objCmd.Dispose();
objCmd.Cancel();
sqlConn.Dispose();
sqlConn.Close();
}
strPKCode = PKSL.ToString("000");
obj.PSC_Code = strPKCode;
//return strPKCode;
}
public override void Delete(object obj)
{
ProductSubCategoryInfoDTO oProductSubCategoryInfoDTO = (ProductSubCategoryInfoDTO)obj;
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString());
String sql = "Delete ProductSubCategoryInfo where PSC_PK=@PSC_PK";
SqlCommand objCmdDelete = sqlConn.CreateCommand();
objCmdDelete.CommandText = sql;
try
{
objCmdDelete.Parameters.Add("@PSC_PK", SqlDbType.UniqueIdentifier, 16);
objCmdDelete.Parameters["@PSC_PK"].Value = (Guid)oProductSubCategoryInfoDTO.PrimaryKey;
sqlConn.Open();
objCmdDelete.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
objCmdDelete.Dispose();
objCmdDelete.Cancel();
sqlConn.Dispose();
sqlConn.Close();
}
}
/// <summary>
/// Set All data in Domain()
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public ProductSubCategoryInfoDTO Populate(SqlDataReader reader)
{
try
{
ProductSubCategoryInfoDTO dto = new ProductSubCategoryInfoDTO();
dto.PrimaryKey = (Guid)reader["PSC_PK"];
dto.PC_PK = (Guid)reader["PC_PK"];
dto.PSC_Code = (string)reader["PSC_Code"];
dto.PSC_Description = (string)reader["PSC_Description"];
dto.EntryBy = (string)reader["EntryBy"];
dto.EntryDate = (DateTime)reader["EntryDate"];
return(dto);
}
catch (Exception Exp)
{
throw Exp;
}
}
/// <summary>
/// Get Product Category all Information
/// </summary>
/// <returns></returns>
public List <ProductSubCategoryInfoDTO> getProductSubCategoryData()
{
string sqlSelect = "Select PSC_PK,PC_PK,PSC_Code,PSC_Description,EntryBy,EntryDate From ProductSubCategoryInfo order by PSC_Code DESC";
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString());
List <ProductSubCategoryInfoDTO> oArrayList = new List <ProductSubCategoryInfoDTO>();
SqlCommand objCmd = sqlConn.CreateCommand();
objCmd.CommandText = sqlSelect;
objCmd.Connection = sqlConn;
try
{
sqlConn.Open();
SqlDataReader thisReader = objCmd.ExecuteReader();
while (thisReader.Read())
{
ProductSubCategoryInfoDTO oProductSubCategoryInfoDTO = Populate(thisReader);
oArrayList.Add(oProductSubCategoryInfoDTO);
}
thisReader.Close();
thisReader.Dispose();
}
catch (Exception Exp)
{
throw Exp;
}
finally
{
objCmd.Dispose();
objCmd.Cancel();
sqlConn.Dispose();
sqlConn.Close();
}
return(oArrayList);
}
/// <summary>
/// Get Product Category Information corresponding definite Product Primary Key.
/// </summary>
/// <param name="pk"></param>
/// <returns></returns>
public ProductSubCategoryInfoDTO FindByPK(Guid pk)
{
ProductSubCategoryInfoDTO pscDTO = new ProductSubCategoryInfoDTO();
string sqlSelect = "SELECT PSC_PK, PC_PK,PSC_Code, PSC_Description,EntryBy,EntryDate FROM ProductSubCategoryInfo WHERE PSC_PK=@PSC_PK";
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString());
SqlCommand objCmd = sqlConn.CreateCommand();
try
{
objCmd.CommandText = sqlSelect;
objCmd.Connection = sqlConn;
objCmd.Parameters.Add("@PSC_PK", SqlDbType.UniqueIdentifier, 16);
objCmd.Parameters["@PSC_PK"].Value = pk;
sqlConn.Open();
SqlDataReader thisReader = objCmd.ExecuteReader();
while (thisReader.Read())
{
pscDTO = Populate(thisReader);
}
thisReader.Close();
thisReader.Dispose();
}
catch (Exception Exp)
{
throw Exp;
}
finally
{
objCmd.Dispose();
objCmd.Cancel();
sqlConn.Dispose();
sqlConn.Close();
}
return(pscDTO);
}
/// <summary>
/// Get Product Category Information corresponding definite Product Primary Key.
/// </summary>
/// <param name="pk"></param>
/// <returns></returns>
public List <ProductSubCategoryInfoDTO> getProductSubCategoryDataByPC(Guid pk)
{
string sqlSelect = "Select PSC_PK,PC_PK,PSC_Code,PSC_Description,EntryBy,EntryDate From ProductSubCategoryInfo Where PC_PK=@PC_PK";
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString());
List <ProductSubCategoryInfoDTO> oArrayList = new List <ProductSubCategoryInfoDTO>();
SqlCommand objCmd = sqlConn.CreateCommand();
try
{
objCmd.CommandText = sqlSelect;
objCmd.Connection = sqlConn;
objCmd.Parameters.Add("@PC_PK", SqlDbType.UniqueIdentifier, 16);
objCmd.Parameters["@PC_PK"].Value = pk;
sqlConn.Open();
SqlDataReader thisReader = objCmd.ExecuteReader();
while (thisReader.Read())
{
ProductSubCategoryInfoDTO oProductSubCategoryInfoDTO = Populate(thisReader);
oArrayList.Add(oProductSubCategoryInfoDTO);
}
thisReader.Close();
thisReader.Dispose();
}
catch (Exception Exp)
{
throw Exp;
}
finally
{
objCmd.Dispose();
objCmd.Cancel();
sqlConn.Dispose();
sqlConn.Close();
}
return(oArrayList);
}
protected void GridView1_RowEdting(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "Edit")
{
Facade facade = Facade.GetInstance();
int index = Convert.ToInt32(e.CommandArgument);
ProductSubCategoryInfoDTO oProductSubCategoryInfoDTO = new ProductSubCategoryInfoDTO();
GridViewRow row = GridView1.Rows[index];
DataKey xx = this.GridView1.DataKeys[index];
this.txtHideFieldPK.Value = xx.Value.ToString();
oProductSubCategoryInfoDTO = facade.GetProductsubCategoryInfo((Guid)TypeDescriptor.GetConverter(oProductSubCategoryInfoDTO.PrimaryKey).ConvertFromString(this.txtHideFieldPK.Value));
this.txtPSCCode.Text = Server.HtmlDecode(row.Cells[2].Text);
this.txtPSubCategoryDescription.Text = Server.HtmlDecode(row.Cells[3].Text);
this.btnSave.Text = "Update";
ProductCategoryInfoDTO pcDto = new ProductCategoryInfoDTO();
pcDto = facade.GetProductCategoryInfo((Guid)oProductSubCategoryInfoDTO.PC_PK);
this.ddlProductCategory.SelectedValue = pcDto.PrimaryKey.ToString();
//*********Modified by NERO. DDL Select Example. Req: SAMAD********************
//DropDownList1.SelectedItem.Selected = false;
//DropDownList1.Items.FindByValue("000111-222556-3333-2222-222").Selected=true;
//*********END EXAMPLE*********************************************************
}
}
catch (Exception Exp)
{
lblErrorMessage.Text = cls.ErrorString(Exp);
}
}
public override void Save(object obj)
{
ProductSubCategoryInfoDTO oProductSubCategoryInfoDTO = (ProductSubCategoryInfoDTO)obj;
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString());
SqlCommand objCmd = sqlConn.CreateCommand();
if (oProductSubCategoryInfoDTO.PrimaryKey.ToString() == "00000000-0000-0000-0000-000000000000")
{
//string strset = getPKCode(oProductCategoryInfoDTO);
String sql = "Insert Into ProductSubCategoryInfo(PC_PK,PSC_Code,PSC_Description,EntryBy,EntryDate) values(@PC_PK,@PSC_Code,@PSC_Description,@EntryBy,@EntryDate)";
try
{
getPKCode(oProductSubCategoryInfoDTO);
objCmd.CommandText = sql;
objCmd.Parameters.Add(new SqlParameter("@PC_PK", SqlDbType.UniqueIdentifier, 16));
objCmd.Parameters.Add(new SqlParameter("@PSC_Code", SqlDbType.VarChar, 3));
objCmd.Parameters.Add(new SqlParameter("@PSC_Description", SqlDbType.VarChar, 50));
objCmd.Parameters.Add(new SqlParameter("@EntryBy", SqlDbType.VarChar, 5));
objCmd.Parameters.Add(new SqlParameter("@EntryDate", SqlDbType.DateTime));
objCmd.Parameters["@PC_PK"].Value = (Guid)oProductSubCategoryInfoDTO.PC_PK;
objCmd.Parameters["@PSC_Code"].Value = Convert.ToString(oProductSubCategoryInfoDTO.PSC_Code);
objCmd.Parameters["@PSC_Description"].Value = Convert.ToString(oProductSubCategoryInfoDTO.PSC_Description);
objCmd.Parameters["@EntryBy"].Value = Convert.ToString(oProductSubCategoryInfoDTO.EntryBy);
objCmd.Parameters["@EntryDate"].Value = Convert.ToDateTime(oProductSubCategoryInfoDTO.EntryDate);
sqlConn.Open();
objCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
objCmd.Dispose();
objCmd.Cancel();
sqlConn.Close();
sqlConn.Dispose();
}
}
else
{
String sql = "Update ProductSubCategoryInfo set PC_PK=@PC_PK,PSC_Description=@PSC_Description,EntryBy=@EntryBy,EntryDate=@EntryDate where PSC_PK=@PSC_PK ";
try
{
objCmd.CommandText = sql;
objCmd.Parameters.Add(new SqlParameter("@PSC_PK", SqlDbType.UniqueIdentifier, 16));
objCmd.Parameters.Add(new SqlParameter("@PC_PK", SqlDbType.UniqueIdentifier, 16));
objCmd.Parameters.Add(new SqlParameter("@PSC_Description", SqlDbType.VarChar, 50));
objCmd.Parameters.Add(new SqlParameter("@EntryBy", SqlDbType.VarChar, 5));
objCmd.Parameters.Add(new SqlParameter("@EntryDate", SqlDbType.DateTime));
objCmd.Parameters["@PSC_PK"].Value = (Guid)oProductSubCategoryInfoDTO.PrimaryKey;
objCmd.Parameters["@PC_PK"].Value = (Guid)oProductSubCategoryInfoDTO.PC_PK;
objCmd.Parameters["@PSC_Description"].Value = Convert.ToString(oProductSubCategoryInfoDTO.PSC_Description);
objCmd.Parameters["@EntryBy"].Value = Convert.ToString(oProductSubCategoryInfoDTO.EntryBy);
objCmd.Parameters["@EntryDate"].Value = Convert.ToDateTime(oProductSubCategoryInfoDTO.EntryDate);
sqlConn.Open();
objCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
objCmd.Dispose();
objCmd.Cancel();
sqlConn.Dispose();
sqlConn.Close();
}
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "Edit")
{
ProductInfoDTO pDto = new ProductInfoDTO();
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow row = GridView1.Rows[index];
DataKey dk = GridView1.DataKeys[index];
this.hfPrimaryKey.Value = dk.Value.ToString();
Facade facade = Facade.GetInstance();
DropDownListSubCategory(facade);
pDto = facade.GetProductInfoDTO((Guid)TypeDescriptor.GetConverter(pDto.PrimaryKey).ConvertFromString(this.hfPrimaryKey.Value));
this.txtProductCode.Text = pDto.P_Code;
this.txtProductName.Text = pDto.P_Name;
this.txtStyle.Text = pDto.P_Style;
this.txtSalesPrice.Text = pDto.P_SalesPrice.ToString();
this.txtCostPrice.Text = pDto.P_CostPrice.ToString();
this.txtTax.Text = pDto.P_Tax.ToString();
this.txtVat.Text = pDto.P_VAT.ToString();
this.txtDiscount.Text = pDto.P_Discount.ToString();
this.txtMinLevel.Text = pDto.P_MinLevel.ToString();
this.txtMaxLevel.Text = pDto.P_MaxLevel.ToString();
this.txtReorderLevel.Text = pDto.P_ReorderLevel.ToString();
this.chkStatus.Checked = pDto.P_Status;
this.txtSalesPriceDate.Text = pDto.P_SalesPriceDate.ToString("MM/dd/yyyy");
this.txtCostPriceDate.Text = pDto.P_CostPriceDate.ToString("MM/dd/yyyy");
this.chkWarranty.Checked = pDto.P_Warranty;
this.txtWarrantyMonth.Text = pDto.P_WarrantyMonth.ToString();
this.btnSave.Text = "Update";
ProductCategoryInfoDTO pcDto = new ProductCategoryInfoDTO();
pcDto = facade.GetProductCategoryInfo((Guid)pDto.PC_PrimaryKey);
this.ddlProductCategory.SelectedValue = pcDto.PrimaryKey.ToString();
ProductSubCategoryInfoDTO pscDto = new ProductSubCategoryInfoDTO();
pscDto = facade.GetProductsubCategoryInfo((Guid)pDto.PSC_PrimaryKey);
if (pscDto.PrimaryKey.ToString() == "00000000-0000-0000-0000-000000000000")
{
this.ddlProductSubCategory.SelectedValue = "";
}
else
{
this.ddlProductSubCategory.SelectedValue = pscDto.PrimaryKey.ToString();
}
ProductBrandInfoDTO pbDto = new ProductBrandInfoDTO();
pbDto = facade.GetProductBrandInfo((Guid)pDto.PB_PrimaryKey);
if (pbDto.PrimaryKey.ToString() == "00000000-0000-0000-0000-000000000000")
{
this.ddlProductBrand.SelectedValue = "";
}
else
{
this.ddlProductBrand.SelectedValue = pbDto.PrimaryKey.ToString();
}
ProductUnitInfoDTO puDto = new ProductUnitInfoDTO();
puDto = facade.GetProductUnitInfo((Guid)pDto.PU_PrimaryKey);
if (puDto.PrimaryKey.ToString() == "00000000-0000-0000-0000-000000000000")
{
this.ddlProductUnit.SelectedValue = "";
}
else
{
this.ddlProductUnit.SelectedValue = puDto.PrimaryKey.ToString();
}
}
}
catch (Exception Exp)
{
lblErrorMessage.Text = cls.ErrorString(Exp);
}
}
