public bool SetAcademic(int Id, string jsonAcademic) { if (comfun.DeleteRecords(Id, 6)) { SqlConnection con = new SqlConnection(); connection = ConfigurationManager.ConnectionStrings[Constants.connection].ConnectionString; con.ConnectionString = connection; SqlCommand cmd = new SqlCommand(); cmd.Connection = con; con.Open(); using (SqlTransaction sqlTransaction = con.BeginTransaction()) { try { using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con, SqlBulkCopyOptions.Default, sqlTransaction)) { //Set the database table name sqlBulkCopy.DestinationTableName = Constants.tblAcademic; //[OPTIONAL]: Map the DataTable columns with that of the database table sqlBulkCopy.ColumnMappings.Add(Constants.EmpId, Constants.colEmpID); sqlBulkCopy.ColumnMappings.Add(Constants.School, Constants.colSchool); sqlBulkCopy.ColumnMappings.Add(Constants.Course, Constants.colCourse); sqlBulkCopy.ColumnMappings.Add(Constants.Major, Constants.colMajor); sqlBulkCopy.ColumnMappings.Add(Constants.Minor, Constants.colMinor); sqlBulkCopy.ColumnMappings.Add(Constants.PerMarks, Constants.colPerMarks); sqlBulkCopy.ColumnMappings.Add(Constants.University, Constants.colUniversity); sqlBulkCopy.ColumnMappings.Add(Constants.CourseCompletion, Constants.colCourseCompletion); sqlBulkCopy.ColumnMappings.Add(Constants.YearofPassing, Constants.colYearofPassing); sqlBulkCopy.ColumnMappings.Add(Constants.Grade, Constants.colGrade); sqlBulkCopy.ColumnMappings.Add(Constants.AttachmentPaths, Constants.colAttachmentPaths); sqlBulkCopy.ColumnMappings.Add(Constants.CreatedDate, Constants.colCreatedDate); sqlBulkCopy.ColumnMappings.Add(Constants.ModifiedDate, Constants.colModifiedDate); sqlBulkCopy.ColumnMappings.Add(Constants.CreatedEmpID, Constants.colCreatedEmpID); sqlBulkCopy.ColumnMappings.Add(Constants.ModifiedEmpID, Constants.colModifiedEmpID); sqlBulkCopy.WriteToServer(comfun.StringtoDataTable(jsonAcademic)); sqlTransaction.Commit(); } return(true); } catch (Exception e) { sqlTransaction.Rollback(); return(false); } finally { con.Close(); } } } return(false); }
public bool UpdateGroups(int CompanyId, int EmpId, string jsonGroupDetails) { Common_Library.CommonFunctions comfun = new Common_Library.CommonFunctions(); if (comfun.DeleteRecords(CompanyId, 47)) { SqlConnection con = new SqlConnection(); connection = ConfigurationManager.ConnectionStrings[Constants.connection].ConnectionString; con.ConnectionString = connection; SqlCommand cmd = new SqlCommand(); cmd.Connection = con; con.Open(); using (SqlTransaction sqlTransaction = con.BeginTransaction()) { try { using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con, SqlBulkCopyOptions.Default, sqlTransaction)) { //Set the database table name sqlBulkCopy.DestinationTableName = AdminConstants.tblGroup; //[OPTIONAL]: Map the DataTable columns with that of the database table sqlBulkCopy.ColumnMappings.Add(AdminConstants.colGroupName, AdminConstants.colGroupName); sqlBulkCopy.ColumnMappings.Add(AdminConstants.colCompanyId, AdminConstants.colCompanyId); sqlBulkCopy.ColumnMappings.Add(AdminConstants.colDepartmentId, AdminConstants.colDepartmentId); sqlBulkCopy.ColumnMappings.Add(AdminConstants.CreatedEmpID, AdminConstants.CreatedEmpID); sqlBulkCopy.ColumnMappings.Add(AdminConstants.ModifiedEmpID, AdminConstants.ModifiedEmpID); sqlBulkCopy.WriteToServer(comfun.StringtoDataTable(jsonGroupDetails)); sqlTransaction.Commit(); } return(true); } catch (Exception e) { sqlTransaction.Rollback(); return(false); } finally { con.Close(); comfun = null; } } } return(false); }
public bool SetInterview(int Id, string jsonInterView) { if (comfun.DeleteRecords(Id, 43)) { SqlConnection con = new SqlConnection(); connection = ConfigurationManager.ConnectionStrings[Constants.connection].ConnectionString; con.ConnectionString = connection; SqlCommand cmd = new SqlCommand(); cmd.Connection = con; con.Open(); using (SqlTransaction sqlTransaction = con.BeginTransaction()) { try { using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con, SqlBulkCopyOptions.Default, sqlTransaction)) { //Set the database table name sqlBulkCopy.DestinationTableName = RecruitmentConstants.tblInterviewers; //[OPTIONAL]: Map the DataTable columns with that of the database table sqlBulkCopy.ColumnMappings.Add(RecruitmentConstants.FKScheduleId, RecruitmentConstants.colFKScheduleId); sqlBulkCopy.ColumnMappings.Add(RecruitmentConstants.Interviewer, RecruitmentConstants.colInterviewer); sqlBulkCopy.ColumnMappings.Add(RecruitmentConstants.InterviewerStatusId, RecruitmentConstants.colInterviewerStatusId); sqlBulkCopy.ColumnMappings.Add(RecruitmentConstants.Comments, RecruitmentConstants.colComments); sqlBulkCopy.ColumnMappings.Add(RecruitmentConstants.Attachments, RecruitmentConstants.colAttachments); sqlBulkCopy.WriteToServer(comfun.StringtoDataTable(jsonInterView)); sqlTransaction.Commit(); } return(true); } catch (Exception e) { sqlTransaction.Rollback(); return(false); } finally { con.Close(); } } } return(false); }