private void BindCustomerInfo()
{
try
{
Qtm.Lib.CustomerInfo obj = Qtm.Lib.CustomerInfo.Find(SessionManager.GetCustomerId(HttpContext.Current));
if (obj != null)
{
l_CustCode.Text = obj.Code;
l_Name.Text = obj.Name;
l_Address.Text = obj.Address1;
l_Address2.Text = obj.Address2;
l_City.Text = obj.City + " " + obj.PostCode;
Session["CustName"] = obj.Name;
Session["CustAdd1"] = obj.Address1;
Session["CustAdd2"] = obj.Address2;
Session["CustCity"] = obj.City + " " + obj.PostCode;
}
Qtm.Lib.ConsigneeInfo objCons = Qtm.Lib.ConsigneeInfo.Find(SessionManager.GetConsigneeId(HttpContext.Current), SessionManager.GetCustomerId(HttpContext.Current));
if (objCons != null)
{
l_CsCustCode.Text = objCons.Code;
l_CsName.Text = objCons.Name;
l_CsAddress.Text = objCons.Address1;
l_CsAddress2.Text = objCons.Address2;
l_CsCity.Text = objCons.City + " " + objCons.PostCode;
Session["ConName"] = objCons.Name;
Session["ConAdd1"] = objCons.Address1;
Session["ConAdd2"] = objCons.Address2;
Session["ConCity"] = objCons.City + " " + objCons.PostCode;
}
else
{
l_CsCustCode.Text = obj.Code;
l_CsName.Text = obj.Name;
l_CsAddress.Text = obj.Address1;
l_CsAddress2.Text = obj.Address2;
l_CsCity.Text = obj.City + " " + obj.PostCode;
Session["ConName"] = obj.Name;
Session["ConAdd1"] = obj.Address1;
Session["ConAdd2"] = obj.Address2;
Session["ConCity"] = obj.City + " " + obj.PostCode;
}
}
catch (Exception ex)
{
l_Error.Text = ex.Message;
l_Error.Visible = true;
}
}
public static ConsigneeInfo Find(string id, string customercode)
{
string strSQL = string.Empty;
SqlDataReader reader;
strSQL = "SP_WA_FindConsigneeByCode_SP";
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand(strSQL);
ConsigneeInfo obj = null;
try
{
db.AddInParameter(dbCommand, "@ConsigneeCode", DbType.String, id);
db.AddInParameter(dbCommand, "@CustCode", DbType.String, customercode);
reader = (SqlDataReader)db.ExecuteReader(dbCommand);
if (reader.HasRows)
{
while (reader.Read())
{
obj = new ConsigneeInfo();
obj.Code = Convert.ToString(reader.GetValue(reader.GetOrdinal("Code")));
obj.Name = Convert.ToString(reader.GetValue(reader.GetOrdinal("Name")));
obj.Address1 = Convert.ToString(reader.GetValue(reader.GetOrdinal("Address")));
obj.Address2 = Convert.ToString(reader.GetValue(reader.GetOrdinal("Address 2")));
obj.City = Convert.ToString(reader.GetValue(reader.GetOrdinal("City")));
obj.PostCode = Convert.ToString(reader.GetValue(reader.GetOrdinal("Post Code")));
obj.PhoneNo = Convert.ToString(reader.GetValue(reader.GetOrdinal("Phone No_")));
}
}
if (!reader.IsClosed)
{
reader.Close();
}
}
catch (SqlException e)
{ throw e; }
catch (Exception e)
{ throw e; }
finally
{
dbCommand.Dispose();
dbCommand = null;
db = null;
}
return(obj);
}
