/// <summary> /// It Stores Data in the Database /// </summary> /// <param name="companyAdd">Caompany Data</param> /// <returns>If Data Found return ResponseData else nul or Exception</returns> public CompanyAddResponse AddCompany(CompanyAddRequest companyAddRequest) { try { CompanyAddResponse responseData = null; try { using (SqlConnection conn = new SqlConnection(sqlConnectionString)) { SqlCommand cmd = new SqlCommand("spAddCompany", conn) { CommandType = System.Data.CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@Name", companyAddRequest.Name); cmd.Parameters.AddWithValue("@Address", companyAddRequest.Address); cmd.Parameters.AddWithValue("@Location", companyAddRequest.Location); cmd.Parameters.AddWithValue("@Status", companyAddRequest.Status); cmd.Parameters.AddWithValue("@CreatorStamp", companyAddRequest.CreatorStamp); cmd.Parameters.AddWithValue("@CreatorUser", companyAddRequest.CreatorUser); cmd.Parameters.AddWithValue("@CreatedDate", DateTime.Now); cmd.Parameters.AddWithValue("@ModifiedDate", DateTime.Now); conn.Open(); SqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { responseData = new CompanyAddResponse() { CompanyID = Convert.ToInt32(dataReader["CompanyID"]), Name = dataReader["Name"].ToString(), Address = dataReader["Address"].ToString(), Location = dataReader["Location"].ToString(), Status = dataReader["Status"].ToString(), CreatorStamp = dataReader["CreatorStamp"].ToString(), CreatorUser = dataReader["CreatorUser"].ToString(), CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]), ModifiedDate = Convert.ToDateTime(dataReader["ModifiedDate"]) }; } conn.Close(); } return(responseData); } catch { return(null); } } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// It Fetch All Comapnies Data /// </summary> /// <returns>If Data Found return ResponseData else null or Exception</returns> public List <CompanyAddResponse> GetAllCompanies() { try { List <CompanyAddResponse> companiesList = null; using (SqlConnection conn = new SqlConnection(sqlConnectionString)) { companiesList = new List <CompanyAddResponse>(); SqlCommand cmd = new SqlCommand("spGetAllCompanies", conn) { CommandType = System.Data.CommandType.StoredProcedure }; conn.Open(); SqlDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { CompanyAddResponse responseData = new CompanyAddResponse() { CompanyID = Convert.ToInt32(dataReader["CompanyID"]), Name = dataReader["Name"].ToString(), Address = dataReader["Address"].ToString(), Location = dataReader["Location"].ToString(), Status = dataReader["Status"].ToString(), CreatorStamp = dataReader["CreatorStamp"].ToString(), CreatorUser = dataReader["CreatorUser"].ToString(), CreatedDate = Convert.ToDateTime(dataReader["CreatedDate"]), ModifiedDate = Convert.ToDateTime(dataReader["ModifiedDate"]) }; companiesList.Add(responseData); } conn.Close(); } return(companiesList); } catch (Exception ex) { throw new Exception(ex.Message); } }