예제 #1
0
 public LookupList GetCityListbyStateID(string StateID)
 {
     int IntStateID;
     LookupList CitylookupList = new LookupList();
     Lookup cityLookup;
     LookUpDAL lookUpDAL = new LookUpDAL();
     try
     {
         IntStateID = Convert.ToInt32(StateID);
     }
     catch (Exception exception)
     {
         CitylookupList.Status = false;
         CitylookupList.Message = "Opps something went worng, with supplied Param !";
         Logger Err = new Logger();
         Err.ErrorLog(HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["ErrorLogPath"]), exception.Message, exception.StackTrace);
         return CitylookupList;
     }
     try
     {
         DataTable dt = lookUpDAL.GetCityListbyStateID(IntStateID);
         if (dt.Rows.Count > 0)
         {
             foreach (DataRow dr in dt.Rows)
             {
                 cityLookup = new Lookup();
                 cityLookup.Id = Convert.ToInt32(dr["ID"] == null ? 0 : dr["ID"]);
                 cityLookup.Name = dr["Name"].ToString();
                 CitylookupList.Data.Add(cityLookup);
             }
             CitylookupList.Status = true;
             CitylookupList.Message = "List of cities !";
         }
         else
         {
             CitylookupList.Status = false;
             CitylookupList.Message = "No city exists !";
         }
     }
     catch (Exception exception)
     {
         CitylookupList.Status = false;
         CitylookupList.Message = "Opps something went worng, please check with application admin !";
         Logger Err = new Logger();
         Err.ErrorLog(HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["ErrorLogPath"]), exception.Message, exception.StackTrace);
     }
     return CitylookupList;
 }
예제 #2
0
 public LookupList GetStateList()
 {
     LookupList stateList = new LookupList();
     Lookup stateLookup;
     LookUpDAL lookUpDAL = new LookUpDAL();
     try
     {
         DataTable dt = lookUpDAL.GetStateList();
         if (dt.Rows.Count > 0)
         {
             foreach (DataRow dr in dt.Rows)
             {
                 stateLookup = new Lookup();
                 stateLookup.Id = Convert.ToInt32(dr["LID"] == null ? 0 : dr["LID"]);
                 stateLookup.Name = dr["LDESC"].ToString();
                 stateList.Data.Add(stateLookup);
             }
             stateList.Status = true;
             stateList.Message = "List of States !";
         }
         else
         {
             stateList.Status = false;
             stateList.Message = "No State exists !";
         }
     }
     catch (Exception exception)
     {
         stateList.Status = false;
         stateList.Message = "Opps something went worng, please check with application admin !";
         Logger Err = new Logger();
         Err.ErrorLog(HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["ErrorLogPath"]), exception.Message, exception.StackTrace);
     }
     return stateList;
 }