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); }