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);
}