public DataTable LoadIVDetailsByCompanyName(RecruiterProfileBO ObjRecruiterProfileBO1) { ObjDatabaseObject.DBDataTable = new DataTable(); ObjDatabaseObject.DBAdapter = new SqlDataAdapter(); ObjDatabaseObject.DBAdapter.SelectCommand = new SqlCommand(@"uspLoadIVDetailsByCompanyName", ObjDatabaseObject.DBConnection); SqlParameter Param1 = new SqlParameter(); Param1.ParameterName = "@CompanyName"; Param1.Value = ObjRecruiterProfileBO1.CompanyName; ObjDatabaseObject.DBAdapter.SelectCommand.CommandType = CommandType.StoredProcedure; ObjDatabaseObject.DBAdapter.SelectCommand.Parameters.Add(Param1); ObjDatabaseObject.DBAdapter.Fill(ObjDatabaseObject.DBDataTable); return ObjDatabaseObject.DBDataTable; }
public int UpdateRecruiterAddress(RecruiterProfileBO recruiterProfileBOObject) { return recruiterProfileBLLObject.UpdateRecruiterAddress(recruiterProfileBOObject); }
public int UpdatePhoneNumber(RecruiterProfileBO recruiterProfileBOObject) { return recruiterProfileBLLObject.UpdatePhoneNumber(recruiterProfileBOObject); }
public int UpdateEmailId(RecruiterProfileBO recruiterProfileBOObject) { return recruiterProfileBLLObject.UpdateEmailId(recruiterProfileBOObject); }
public int InsertRecruitmentProfileDetails(RecruiterProfileBO recruiterProfile) { return recruiterProfileBLLObject.InsertRecruitmentProfileDetails(recruiterProfile); }
public string GetUniqueCodeIfExists(RecruiterProfileBO recruiterProfileBOObject) { return recruiterProfileBLLObject.GetUniqueCodeIfExists(recruiterProfileBOObject); }
public DataTable LoadIVDetailsByCompanyName(RecruiterProfileBO ObjRecruiterProfileBO1) { return ObjInterviewApprovalDAL.LoadIVDetailsByCompanyName(ObjRecruiterProfileBO1); }
public string GetUniqueCodeIfExists(RecruiterProfileBO recruiterProfileBOObject) { string uniqueCodeExists = string.Empty; databaseObject.DBCommand = new SqlCommand(); databaseObject.DBCommand.CommandText = @"uspGetUniqueCodeIfExists"; databaseObject.DBCommand.CommandType = CommandType.StoredProcedure; SqlParameter param1 = new SqlParameter(); param1.ParameterName = "@CompanyName"; param1.Value = recruiterProfileBOObject.CompanyName; SqlParameter param2 = new SqlParameter(); param2.ParameterName = "@RecruiterName"; param2.Value = recruiterProfileBOObject.RecruiterName; try { databaseObject.DBCommand.Connection = databaseObject.DBConnection; databaseObject.DBConnection.Open(); databaseObject.DBCommand.Parameters.Add(param1); databaseObject.DBCommand.Parameters.Add(param2); databaseObject.DBDataReader = databaseObject.DBCommand.ExecuteReader(); if (databaseObject.DBDataReader.HasRows == true) { while (databaseObject.DBDataReader.Read()) { uniqueCodeExists = (databaseObject.DBDataReader[0].ToString()); } } else { } } catch (SqlException ex) { return ex.ErrorCode.ToString(); } finally { databaseObject.DBConnection.Close(); } return uniqueCodeExists; }
public int UpdateRecruiterAddress(RecruiterProfileBO recruiterProfileBOObject1) { int queryStatus = 0; databaseObject.DBCommand = new SqlCommand(); databaseObject.DBCommand.CommandText = @"uspUpdateAddress"; databaseObject.DBCommand.CommandType = CommandType.StoredProcedure; SqlParameter param1 = new SqlParameter(); param1.ParameterName = "@Address"; param1.Value = recruiterProfileBOObject1.Address; SqlParameter param2 = new SqlParameter(); param2.ParameterName = "@UniqueCode"; param2.Value = recruiterProfileBOObject1.UniqueCode; try { databaseObject.DBCommand.Connection = databaseObject.DBConnection; databaseObject.DBConnection.Open(); databaseObject.DBCommand.Parameters.Add(param1); databaseObject.DBCommand.Parameters.Add(param2); queryStatus = databaseObject.DBCommand.ExecuteNonQuery(); } catch (SqlException ex) { } finally { databaseObject.DBConnection.Close(); } return queryStatus; }
public int InsertRecruitmentProfileDetails(RecruiterProfileBO recruiterProfile) { int queryStatus = 0; databaseObject.DBCommand = new SqlCommand(); databaseObject.DBCommand.CommandText = @"uspInsertRecruiterProfile"; databaseObject.DBCommand.CommandType = CommandType.StoredProcedure; databaseObject.DBDataTable = new DataTable(); databaseObject.DBDataTable.Columns.Add("LoginId", typeof(long)); databaseObject.DBDataTable.Columns.Add("RecruiterName", typeof(string)); databaseObject.DBDataTable.Columns.Add("CompanyName", typeof(string)); databaseObject.DBDataTable.Columns.Add("Address", typeof(string)); databaseObject.DBDataTable.Columns.Add("Mail id", typeof(string)); databaseObject.DBDataTable.Columns.Add("Phone", typeof(string)); databaseObject.DBDataTable.Columns.Add("UniqueCode", typeof(string)); databaseObject.DBDataTable.Rows.Add(recruiterProfile.LoginId, recruiterProfile.RecruiterName, recruiterProfile.CompanyName, recruiterProfile.Address, recruiterProfile.EmailId, recruiterProfile.Phone, recruiterProfile.UniqueCode); SqlParameter param1 = new SqlParameter(); param1.ParameterName = "@RecruiterDetails"; param1.Value = databaseObject.DBDataTable; param1.SqlDbType = SqlDbType.Structured; try { databaseObject.DBCommand.Connection = databaseObject.DBConnection; databaseObject.DBConnection.Open(); databaseObject.DBCommand.Parameters.Add(param1); queryStatus=databaseObject.DBCommand.ExecuteNonQuery(); } catch (SqlException ex) { } finally { databaseObject.DBConnection.Close(); } return queryStatus; }
public DataTable ViewPostsByCompanyName(RecruiterProfileBO ObjRecruiterProfileBO1) { return ObjJobPostingApprovalDAL.ViewPostsByCompanyName(ObjRecruiterProfileBO1); }
public DataTable ViewPostsByCompanyName(RecruiterProfileBO ObjRecruiterProfileBO1) { ObjDatabaseObject.DBDataTable = new DataTable(); ObjDatabaseObject.DBAdapter = new SqlDataAdapter(); //ObjDatabaseObject.DBCommand = new SqlCommand(@"uspViewPostsByCompanyName", ObjDatabaseObject.DBConnection); ObjDatabaseObject.DBAdapter.SelectCommand = new SqlCommand(@"uspViewPostsByCompanyName", ObjDatabaseObject.DBConnection); ObjDatabaseObject.DBAdapter.SelectCommand.Parameters.Add(new SqlParameter("@CompanyName",ObjRecruiterProfileBO1.CompanyName)); ObjDatabaseObject.DBAdapter.SelectCommand.CommandType= CommandType.StoredProcedure; ObjDatabaseObject.DBAdapter.Fill(ObjDatabaseObject.DBDataTable); return ObjDatabaseObject.DBDataTable; }