private OpeningBalanceDTO Populate()
{
try
{
string strP_PK;
OpeningBalanceDTO dto = new OpeningBalanceDTO();
if (this.txtHideFieldPK.Value != "")
{
dto.PrimaryKey = (Guid)TypeDescriptor.GetConverter(dto.PrimaryKey).ConvertFromString(this.txtHideFieldPK.Value);
}
Guid nullGuid = Guid.NewGuid();
nullGuid = (Guid)TypeDescriptor.GetConverter(nullGuid).ConvertFromString("00000000-0000-0000-0000-000000000000");
strP_PK = (string)this.ddlProductName.SelectedValue;
dto.P_PK = strP_PK == string.Empty ? nullGuid : (Guid)TypeDescriptor.GetConverter(dto.P_PK).ConvertFromString(strP_PK);
dto.OpeningDate = Convert.ToDateTime(this.txtOpeningDate.Text);
dto.OpeningQty = this.txtOpeningQty.Text == string.Empty ? 0 : (decimal)TypeDescriptor.GetConverter(dto.OpeningQty).ConvertFromString(this.txtOpeningQty.Text);
dto.OpeningRate = this.txtOpeningRate.Text == string.Empty ? 0 : (decimal)TypeDescriptor.GetConverter(dto.OpeningRate).ConvertFromString(this.txtOpeningRate.Text);
dto.OpeningDiscount = this.txtOpeningDiscount.Text == string.Empty ? 0 : (decimal)TypeDescriptor.GetConverter(dto.OpeningDiscount).ConvertFromString(this.txtOpeningDiscount.Text);
dto.EntryBy = "Admin";
dto.EntryDate = DateTime.Now.Date;
return(dto);
}
catch (Exception Exp)
{
throw Exp;
}
}
public override void Delete(object obj)
{
OpeningBalanceDTO oOpeningBalanceDTO = (OpeningBalanceDTO)obj;
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString());
String sql = "Delete ProductOpeningBalance where POB_PK=@POB_PK";
SqlCommand objCmdDelete = sqlConn.CreateCommand();
objCmdDelete.CommandText = sql;
try
{
objCmdDelete.Parameters.Add("@POB_PK", SqlDbType.UniqueIdentifier, 16);
objCmdDelete.Parameters["@POB_PK"].Value = (Guid)oOpeningBalanceDTO.PrimaryKey;
sqlConn.Open();
objCmdDelete.ExecuteNonQuery();
}
catch (Exception Exp)
{
throw Exp;
}
finally
{
objCmdDelete.Dispose();
objCmdDelete.Cancel();
sqlConn.Dispose();
sqlConn.Close();
}
}
public List <OpeningBalanceDTO> getOpeningBalanceInfo()
{
string sqlSelect = "SELECT ProductOpeningBalance.POB_PK, ProductOpeningBalance.P_PK, ProductInfo.P_Name, ProductOpeningBalance.OpeningDate, ProductOpeningBalance.OpeningQty, ProductOpeningBalance.OpeningRate, ProductOpeningBalance.OpeningDiscount, ProductOpeningBalance.EntryBy, ProductOpeningBalance.EntryDate FROM ProductOpeningBalance INNER JOIN ProductInfo ON ProductOpeningBalance.P_PK = ProductInfo.P_PK ORDER BY ProductOpeningBalance.P_PK, ProductInfo.P_Name";
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString());
List <OpeningBalanceDTO> oArrayList = new List <OpeningBalanceDTO>();
SqlCommand objCmd = sqlConn.CreateCommand();
objCmd.CommandText = sqlSelect;
objCmd.Connection = sqlConn;
try
{
sqlConn.Open();
SqlDataReader thisReader = objCmd.ExecuteReader();
while (thisReader.Read())
{
OpeningBalanceDTO oOpeningBalanceDTO = populate(thisReader);
oArrayList.Add(oOpeningBalanceDTO);
}
thisReader.Close();
thisReader.Dispose();
}
catch (Exception Exp)
{
throw Exp;
}
finally
{
objCmd.Dispose();
objCmd.Cancel();
sqlConn.Dispose();
sqlConn.Close();
}
return(oArrayList);
}
public OpeningBalanceDTO populate(SqlDataReader reader)
{
try
{
OpeningBalanceDTO dto = new OpeningBalanceDTO();
dto.PrimaryKey = (Guid)reader["POB_PK"];
dto.P_PK = (Guid)reader["P_PK"];
dto.OpeningDate = (DateTime)reader["OpeningDate"];
dto.OpeningQty = (decimal)reader["OpeningQty"];
dto.OpeningRate = (decimal)reader["OpeningRate"];
dto.OpeningDiscount = (decimal)reader["OpeningDiscount"];
dto.EntryBy = (string)reader["EntryBy"];
dto.EntryDate = (DateTime)reader["EntryDate"];
return(dto);
}
catch (Exception Exp)
{
throw Exp;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (this.lblErrorMessage.Text.Length != 0)
{
this.lblErrorMessage.Text = "";
}
if (this.ddlProductName.SelectedValue == "")
{
this.lblErrorMessage.Text = "Select a Supplier Name";
return;
}
try
{
OpeningBalanceDTO oOpeningBalanceDTO = Populate();
Facade facade = Facade.GetInstance();
IOpeningBalanceBL oOpeningBalanceBL = facade.createOpeningBalanceBL();
oOpeningBalanceBL.addNewOpeningRecord(oOpeningBalanceDTO);
this.lblErrorMessage.Text = "Data Save Successfully.";
this.ddlProductName.SelectedValue = "";
this.txtHideFieldPK.Value = "";
this.txtOpeningDate.Text = "";
this.txtOpeningQty.Text = "";
this.txtOpeningRate.Text = "";
this.txtOpeningDiscount.Text = "";
this.btnSave.Text = "Save";
this.GridView1.DataBind();
}
catch (Exception Exp)
{
this.lblErrorMessage.Text = cls.ErrorString(Exp);
}
}
public override void Save(object obj)
{
OpeningBalanceDTO oOpeningBalanceDTO = (OpeningBalanceDTO)obj;
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString());
SqlCommand objCmd = sqlConn.CreateCommand();
if (oOpeningBalanceDTO.PrimaryKey.ToString() == "00000000-0000-0000-0000-000000000000")
{
//string strset = getPKCode(oProductCategoryInfoDTO);
String sql = "INSERT INTO ProductOpeningBalance (P_PK, OpeningDate, OpeningQty, OpeningRate, OpeningDiscount, EntryBy, EntryDate) VALUES (@P_PK, @OpeningDate, @OpeningQty,@OpeningRate, @OpeningDiscount, @EntryBy, @EntryDate)";
try
{
//getPKCode(oOpeningBalanceDTO);
objCmd.CommandText = sql;
objCmd.Parameters.Add(new SqlParameter("@P_PK", SqlDbType.UniqueIdentifier, 16));
objCmd.Parameters.Add(new SqlParameter("@OpeningDate", SqlDbType.DateTime));
objCmd.Parameters.Add(new SqlParameter("@OpeningQty", SqlDbType.Decimal, 9));
objCmd.Parameters.Add(new SqlParameter("@OpeningRate", SqlDbType.Decimal, 9));
objCmd.Parameters.Add(new SqlParameter("@OpeningDiscount", SqlDbType.Decimal, 9));
objCmd.Parameters.Add(new SqlParameter("@EntryBy", SqlDbType.VarChar, 5));
objCmd.Parameters.Add(new SqlParameter("@EntryDate", SqlDbType.DateTime));
objCmd.Parameters["@P_PK"].Value = (Guid)oOpeningBalanceDTO.P_PK;
objCmd.Parameters["@OpeningDate"].Value = Convert.ToDateTime(oOpeningBalanceDTO.OpeningDate);
objCmd.Parameters["@OpeningQty"].Value = Convert.ToDecimal(oOpeningBalanceDTO.OpeningQty);
objCmd.Parameters["@OpeningRate"].Value = Convert.ToDecimal(oOpeningBalanceDTO.OpeningRate);
objCmd.Parameters["@OpeningDiscount"].Value = Convert.ToDecimal(oOpeningBalanceDTO.OpeningDiscount);
objCmd.Parameters["@EntryBy"].Value = Convert.ToString(oOpeningBalanceDTO.EntryBy);
objCmd.Parameters["@EntryDate"].Value = Convert.ToDateTime(oOpeningBalanceDTO.EntryDate);
sqlConn.Open();
objCmd.ExecuteNonQuery();
}
catch (Exception Exp)
{
throw Exp;
}
finally
{
objCmd.Dispose();
objCmd.Cancel();
sqlConn.Close();
sqlConn.Dispose();
}
}
else
{
String sql = "UPDATE ProductOpeningBalance SET P_PK =@P_PK, OpeningDate =@OpeningDate, OpeningQty =@OpeningQty, OpeningRate =@OpeningRate, OpeningDiscount =@OpeningDiscount,EntryBy=@EntryBy,EntryDate=@EntryDate where POB_PK =@POB_PK";
//objCmd = new SqlCommand(sql, getCurrentConnection(), getCurrentTransaction()); ;
try
{
objCmd.CommandText = sql;
objCmd.Parameters.Add(new SqlParameter("@POB_PK", SqlDbType.UniqueIdentifier, 16));
objCmd.Parameters.Add(new SqlParameter("@P_PK", SqlDbType.UniqueIdentifier, 16));
objCmd.Parameters.Add(new SqlParameter("@OpeningDate", SqlDbType.DateTime));
objCmd.Parameters.Add(new SqlParameter("@OpeningQty", SqlDbType.Decimal, 9));
objCmd.Parameters.Add(new SqlParameter("@OpeningRate", SqlDbType.Decimal, 9));
objCmd.Parameters.Add(new SqlParameter("@OpeningDiscount", SqlDbType.Decimal, 9));
objCmd.Parameters.Add(new SqlParameter("@EntryBy", SqlDbType.VarChar, 5));
objCmd.Parameters.Add(new SqlParameter("@EntryDate", SqlDbType.DateTime));
objCmd.Parameters["@POB_PK"].Value = (Guid)oOpeningBalanceDTO.PrimaryKey;
objCmd.Parameters["@P_PK"].Value = (Guid)oOpeningBalanceDTO.P_PK;
objCmd.Parameters["@OpeningDate"].Value = Convert.ToDateTime(oOpeningBalanceDTO.OpeningDate);
objCmd.Parameters["@OpeningQty"].Value = Convert.ToDecimal(oOpeningBalanceDTO.OpeningQty);
objCmd.Parameters["@OpeningRate"].Value = Convert.ToDecimal(oOpeningBalanceDTO.OpeningRate);
objCmd.Parameters["@OpeningDiscount"].Value = Convert.ToDecimal(oOpeningBalanceDTO.OpeningDiscount);
objCmd.Parameters["@EntryBy"].Value = Convert.ToString(oOpeningBalanceDTO.EntryBy);
objCmd.Parameters["@EntryDate"].Value = Convert.ToDateTime(oOpeningBalanceDTO.EntryDate);
sqlConn.Open();
objCmd.ExecuteNonQuery();
}
catch (Exception Exp)
{
throw Exp;
}
finally
{
objCmd.Dispose();
objCmd.Cancel();
sqlConn.Dispose();
sqlConn.Close();
}
}
}
