/// <summary> /// Created By : Shiva /// Created Date : 16 Oct 2014 /// Modified By : /// Modified Date : /// Description : To Get Corporation Details by ID /// </summary> public static CorporationInfo GetCorporationDetailsByID(int ID) { System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); var data = new CorporationInfo(); try { SqlParameter[] sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@ID", ID); var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SPGetCorporationDetailsByID", sqlParams); while (reader.Read()) { var safe = new SafeDataReader(reader); var Corporation = new Corporation(); Corporation.FetchCorporation(Corporation, safe); data.CorporationList.Add(Corporation); } return data; } catch (Exception ex) { log.Error("Error: " + ex); return data; } finally { log.Debug("End: " + methodBase.Name); } }
/// <summary> /// Description : To Get Company Data /// Created By : Pavan /// Created Date : 30 September 2014 /// Modified By : /// Modified Date : /// <returns></returns> /// </summary> public static CorporationInfo GetAllCorporationData(string CompanyName, string OrderBy, int startPage, int resultPerPage) { var data = new CorporationInfo(); System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame(); System.Reflection.MethodBase methodBase = stackFrame.GetMethod(); log.Debug("Start: " + methodBase.Name); try { SqlParameter[] sqlParams = new SqlParameter[4]; sqlParams[0] = new SqlParameter("@startPage", startPage); sqlParams[1] = new SqlParameter("@resultPerPage", resultPerPage); sqlParams[2] = new SqlParameter("@CompanyName", CompanyName); sqlParams[3] = new SqlParameter("@OrderBy", OrderBy); var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[SpGetAllCorporation]", sqlParams); var safe = new SafeDataReader(reader); while (reader.Read()) { var Corporation = new Corporation(); Corporation.FetchCorporation(Corporation, safe); data.CorporationList.Add(Corporation); data.CorporationCount = Convert.ToInt32(reader["CorporationCount"]); } return data; } catch (Exception ex) { log.Error("Error: " + ex); return data; } finally { log.Debug("End: " + methodBase.Name); } }