public SupplierInfoDTO populate()
{
try
{
//string strPC_PK;
SupplierInfoDTO dto = new SupplierInfoDTO();
// populate dto
if (this.txtHideFieldPK.Value != "")
{
dto.PrimaryKey = (Guid)TypeDescriptor.GetConverter(dto.PrimaryKey).ConvertFromString(this.txtHideFieldPK.Value);
}
dto.SupplierName = this.txtSupplierName.Text;
dto.ContractPerson = this.txtContractPerson.Text;
dto.ShortName = this.txtShortName.Text;
dto.Address = this.txtAddress.Text;
dto.Phone = this.txtPhone.Text;
dto.Fax = this.txtFax.Text;
dto.Email = this.txtEmail.Text;
dto.WebAddress = this.txtWebAddress.Text;
dto.EntryBy = "Admin";
dto.EntryDate = DateTime.Now.Date;
return(dto);
}
catch (Exception Exp)
{
throw Exp;
}
}
public SupplierInfoDTO populate(SqlDataReader reader)
{
try
{
SupplierInfoDTO dto = new SupplierInfoDTO();
dto.PrimaryKey = (Guid)reader["Sp_PK"];
dto.SupplierCode = (string)reader["SupplierCode"];
dto.SupplierName = (string)reader["SupplierName"];
dto.ContractPerson = (string)reader["ContractPerson"];
dto.ShortName = (string)reader["ShortName"];
dto.Address = (string)reader["Address"];
dto.Phone = (string)reader["Phone"];
dto.Fax = (string)reader["Fax"];
dto.Email = (string)reader["Email"];
dto.WebAddress = (string)reader["WebAddress"];
dto.EntryBy = (string)reader["EntryBy"];
dto.EntryDate = (DateTime)reader["EntryDate"];
return(dto);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// set Sales Main information in Domain Class
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public PurchaseReturnMainDTO populate(SqlDataReader reader)
{
try
{
PurchaseReturnMainDTO dto = new PurchaseReturnMainDTO();
PurchaseMainDTO oPurchaseMainDTO = new PurchaseMainDTO();
SupplierInfoDTO oSupplierInfoDTO = new SupplierInfoDTO();
oPurchaseMainDTO.PrimaryKey = (Guid)reader["PU_PK"];
oPurchaseMainDTO.GRN_No = (string)reader["GRN_No"];
oPurchaseMainDTO.GRNDate = (DateTime)reader["GRNDate"];
oPurchaseMainDTO.ReferenceNo = (string)reader["ReferenceNo"];
oPurchaseMainDTO.Sp_PK = (Guid)reader["Sp_PK"];
oPurchaseMainDTO.TotalAmount = (decimal)reader["TotalAmount"];
oPurchaseMainDTO.Discount = (decimal)reader["Discount"];
oPurchaseMainDTO.EntryBy = (string)reader["EntryBy"];
oPurchaseMainDTO.EntryDate = (DateTime)reader["EntryDate"];
dto.PurchaseMainDTO = oPurchaseMainDTO;
oSupplierInfoDTO.PrimaryKey = (Guid)reader["Sp_PK"];
oSupplierInfoDTO.SupplierCode = (string)reader["SupplierCode"];
oSupplierInfoDTO.SupplierName = (string)reader["SupplierName"];
oSupplierInfoDTO.Address = (string)reader["Address"];
dto.SupplierInfoDTO = oSupplierInfoDTO;
return(dto);
}
catch (Exception ex)
{
throw ex;
}
}
// Error Handling developed by Samad
// 05/12/06
private void getPKCode(SupplierInfoDTO obj)
{
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString());
string strPKCode = null;
int PKSL = 0;
string sqlSelect = "Select isnull(Max(SupplierCode),0)+1 From SupplierInfo";
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("000000");
obj.SupplierCode = strPKCode;
//return strPKCode;
}
public override void Delete(object obj)
{
SupplierInfoDTO oSupplierInfoDTO = (SupplierInfoDTO)obj;
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString());
String sql = "Delete SupplierInfo where Sp_PK=@Sp_PK";
SqlCommand objCmdDelete = sqlConn.CreateCommand();
objCmdDelete.CommandText = sql;
try
{
objCmdDelete.Parameters.Add("@Sp_PK", SqlDbType.UniqueIdentifier, 16);
objCmdDelete.Parameters["@Sp_PK"].Value = (Guid)oSupplierInfoDTO.PrimaryKey;
sqlConn.Open();
objCmdDelete.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
objCmdDelete.Dispose();
objCmdDelete.Cancel();
sqlConn.Dispose();
sqlConn.Close();
}
}
public SupplierInfoDTO GetSupplierInfoBYCode(string strCode)
{
SupplierInfoDTO oSupplierInfoDTO = new SupplierInfoDTO();
//oSupplierInfoDTO.PrimaryKey = pk;
string sqlSelect = "Select Sp_PK,SupplierCode,SupplierName,ContractPerson,ShortName,Address,Phone,Fax,Email,WebAddress,EntryBy,EntryDate From SupplierInfo where SupplierCode=@SupplierCode";
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString());
SqlCommand objCmd = sqlConn.CreateCommand();
objCmd.CommandText = sqlSelect;
objCmd.Connection = sqlConn;
try
{
objCmd.Parameters.Add(new SqlParameter("@SupplierCode", SqlDbType.VarChar, 6));
objCmd.Parameters["@SupplierCode"].Value = strCode;
sqlConn.Open();
SqlDataReader thisReader = objCmd.ExecuteReader();
while (thisReader.Read())
{
oSupplierInfoDTO = populate(thisReader);
}
thisReader.Close();
thisReader.Dispose();
}
catch (Exception ex)
{
throw ex;
}
finally
{
objCmd.Dispose();
objCmd.Cancel();
sqlConn.Dispose();
sqlConn.Close();
}
return(oSupplierInfoDTO);
}
public List <SupplierInfoDTO> getSupplierInfoData()
{
string sqlSelect = "Select Sp_PK,SupplierCode,SupplierName,ContractPerson,ShortName,Address,Phone,Fax,Email,WebAddress,EntryBy,EntryDate From SupplierInfo order by SupplierCode DESC";
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString());
List <SupplierInfoDTO> oArrayList = new List <SupplierInfoDTO>();
SqlCommand objCmd = sqlConn.CreateCommand();
objCmd.CommandText = sqlSelect;
objCmd.Connection = sqlConn;
try
{
sqlConn.Open();
SqlDataReader thisReader = objCmd.ExecuteReader();
while (thisReader.Read())
{
SupplierInfoDTO oSupplierInfoDTO = populate(thisReader);
oArrayList.Add(oSupplierInfoDTO);
}
thisReader.Close();
thisReader.Dispose();
}
catch (Exception ex)
{
throw ex;
}
finally
{
objCmd.Dispose();
objCmd.Cancel();
sqlConn.Dispose();
sqlConn.Close();
}
return(oArrayList);
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (this.lblErrorMessage.Text.Length != 0)
{
this.lblErrorMessage.Text = "";
}
SupplierInfoDTO dto = populate();
Facade facade = Facade.GetInstance();
ISupplierInfoBL oISupplierInfoBL = facade.createSupplierBL();
oISupplierInfoBL.addNewSupplierRecord(dto);
this.lblErrorMessage.Text = "Data Save Successfully.";
this.txtHideFieldPK.Value = "";
this.txtSupplierCode.Text = "";
this.txtSupplierName.Text = "";
this.txtShortName.Text = "";
this.txtPhone.Text = "";
this.txtFax.Text = "";
this.txtEmail.Text = "";
this.txtContractPerson.Text = "";
this.txtAddress.Text = "";
this.txtWebAddress.Text = "";
this.btnSave.Text = "Save";
this.GridView1.DataBind();
}
catch (Exception Exp)
{
lblErrorMessage.Text = cls.ErrorString(Exp);
}
}
protected void GridView1_RowEdting(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "Edit")
{
SupplierInfoDTO oSupplierInfoDTO = new SupplierInfoDTO();
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow row = GridView1.Rows[index];
this.txtSupplierName.Text = Server.HtmlDecode(row.Cells[2].Text);
DataKey xx = this.GridView1.DataKeys[index];
this.txtHideFieldPK.Value = xx.Value.ToString();
Facade facade = Facade.GetInstance();
oSupplierInfoDTO = facade.getSupplierInfo((Guid)TypeDescriptor.GetConverter(oSupplierInfoDTO.PrimaryKey).ConvertFromString(this.txtHideFieldPK.Value));
txtSupplierCode.Text = oSupplierInfoDTO.SupplierCode;
txtSupplierName.Text = oSupplierInfoDTO.SupplierName;
txtContractPerson.Text = oSupplierInfoDTO.ContractPerson;
txtShortName.Text = oSupplierInfoDTO.ShortName;
txtAddress.Text = oSupplierInfoDTO.Address;
txtPhone.Text = oSupplierInfoDTO.Phone;
txtFax.Text = oSupplierInfoDTO.Fax;
txtEmail.Text = oSupplierInfoDTO.Email;
txtWebAddress.Text = oSupplierInfoDTO.WebAddress;
this.btnSave.Text = "Update";
}
}
catch (Exception Exp)
{
lblErrorMessage.Text = cls.ErrorString(Exp);
}
}
public override void Save(object obj)
{
SupplierInfoDTO oSupplierInfoDTO = (SupplierInfoDTO)obj;
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DPOSConnectionString"].ToString());
SqlCommand objCmd = sqlConn.CreateCommand();
if (oSupplierInfoDTO.PrimaryKey.ToString() == "00000000-0000-0000-0000-000000000000")
{
//string strset = getPKCode(oProductCategoryInfoDTO);
String sql = "Insert Into SupplierInfo(SupplierCode,SupplierName,ContractPerson,ShortName,Address,Phone,Fax,Email,WebAddress,EntryBy,EntryDate) values(@SupplierCode,@SupplierName,@ContractPerson,@ShortName,@Address,@Phone,@Fax,@Email,@WebAddress,@EntryBy,@EntryDate)";
try
{
getPKCode(oSupplierInfoDTO);
objCmd.CommandText = sql;
objCmd.Parameters.Add(new SqlParameter("@SupplierCode", SqlDbType.VarChar, 6));
objCmd.Parameters.Add(new SqlParameter("@SupplierName", SqlDbType.VarChar, 100));
objCmd.Parameters.Add(new SqlParameter("@ContractPerson", SqlDbType.VarChar, 50));
objCmd.Parameters.Add(new SqlParameter("@ShortName", SqlDbType.VarChar, 25));
objCmd.Parameters.Add(new SqlParameter("@Address", SqlDbType.VarChar, 150));
objCmd.Parameters.Add(new SqlParameter("@Phone", SqlDbType.VarChar, 30));
objCmd.Parameters.Add(new SqlParameter("@Fax", SqlDbType.VarChar, 30));
objCmd.Parameters.Add(new SqlParameter("@Email", SqlDbType.VarChar, 30));
objCmd.Parameters.Add(new SqlParameter("@WebAddress", SqlDbType.VarChar, 20));
objCmd.Parameters.Add(new SqlParameter("@EntryBy", SqlDbType.VarChar, 5));
objCmd.Parameters.Add(new SqlParameter("@EntryDate", SqlDbType.DateTime));
objCmd.Parameters["@SupplierCode"].Value = Convert.ToString(oSupplierInfoDTO.SupplierCode);
objCmd.Parameters["@SupplierName"].Value = Convert.ToString(oSupplierInfoDTO.SupplierName);
objCmd.Parameters["@ContractPerson"].Value = Convert.ToString(oSupplierInfoDTO.ContractPerson);
objCmd.Parameters["@ShortName"].Value = Convert.ToString(oSupplierInfoDTO.ShortName);
objCmd.Parameters["@Address"].Value = Convert.ToString(oSupplierInfoDTO.Address);
objCmd.Parameters["@Phone"].Value = Convert.ToString(oSupplierInfoDTO.Phone);
objCmd.Parameters["@Fax"].Value = Convert.ToString(oSupplierInfoDTO.Fax);
objCmd.Parameters["@Email"].Value = Convert.ToString(oSupplierInfoDTO.Email);
objCmd.Parameters["@WebAddress"].Value = Convert.ToString(oSupplierInfoDTO.WebAddress);
objCmd.Parameters["@EntryBy"].Value = Convert.ToString(oSupplierInfoDTO.EntryBy);
objCmd.Parameters["@EntryDate"].Value = Convert.ToDateTime(oSupplierInfoDTO.EntryDate);
sqlConn.Open();
objCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
objCmd.Dispose();
objCmd.Cancel();
sqlConn.Close();
sqlConn.Dispose();
}
}
else
{
String sql = "Update SupplierInfo set SupplierName=@SupplierName,ContractPerson=@ContractPerson,ShortName=@ShortName,Address=@Address,Phone=@Phone,Fax=@Fax,Email=@Email,WebAddress=@WebAddress,EntryBy=@EntryBy,EntryDate=@EntryDate where Sp_PK=@Sp_PK";
//objCmd = new SqlCommand(sql, getCurrentConnection(), getCurrentTransaction()); ;
try
{
objCmd.CommandText = sql;
objCmd.Parameters.Add(new SqlParameter("@Sp_PK", SqlDbType.UniqueIdentifier, 16));
//objCmd.Parameters.Add(new SqlParameter("@SupplierCode", SqlDbType.VarChar, 6));
objCmd.Parameters.Add(new SqlParameter("@SupplierName", SqlDbType.VarChar, 100));
objCmd.Parameters.Add(new SqlParameter("@ContractPerson", SqlDbType.VarChar, 50));
objCmd.Parameters.Add(new SqlParameter("@ShortName", SqlDbType.VarChar, 25));
objCmd.Parameters.Add(new SqlParameter("@Address", SqlDbType.VarChar, 150));
objCmd.Parameters.Add(new SqlParameter("@Phone", SqlDbType.VarChar, 30));
objCmd.Parameters.Add(new SqlParameter("@Fax", SqlDbType.VarChar, 30));
objCmd.Parameters.Add(new SqlParameter("@Email", SqlDbType.VarChar, 30));
objCmd.Parameters.Add(new SqlParameter("@WebAddress", SqlDbType.VarChar, 20));
objCmd.Parameters.Add(new SqlParameter("@EntryBy", SqlDbType.VarChar, 5));
objCmd.Parameters.Add(new SqlParameter("@EntryDate", SqlDbType.DateTime));
objCmd.Parameters["@Sp_PK"].Value = (Guid)oSupplierInfoDTO.PrimaryKey;
//objCmd.Parameters["@SupplierCode"].Value = Convert.ToString(oSupplierInfoDTO.SupplierCode);
objCmd.Parameters["@SupplierName"].Value = Convert.ToString(oSupplierInfoDTO.SupplierName);
objCmd.Parameters["@ContractPerson"].Value = Convert.ToString(oSupplierInfoDTO.ContractPerson);
objCmd.Parameters["@ShortName"].Value = Convert.ToString(oSupplierInfoDTO.ShortName);
objCmd.Parameters["@Address"].Value = Convert.ToString(oSupplierInfoDTO.Address);
objCmd.Parameters["@Phone"].Value = Convert.ToString(oSupplierInfoDTO.Phone);
objCmd.Parameters["@Fax"].Value = Convert.ToString(oSupplierInfoDTO.Fax);
objCmd.Parameters["@Email"].Value = Convert.ToString(oSupplierInfoDTO.Email);
objCmd.Parameters["@WebAddress"].Value = Convert.ToString(oSupplierInfoDTO.WebAddress);
objCmd.Parameters["@EntryBy"].Value = Convert.ToString(oSupplierInfoDTO.EntryBy);
objCmd.Parameters["@EntryDate"].Value = Convert.ToDateTime(oSupplierInfoDTO.EntryDate);
sqlConn.Open();
objCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
objCmd.Dispose();
objCmd.Cancel();
sqlConn.Dispose();
sqlConn.Close();
}
}
}
