/// <summary>
/// Insert Employee Details
/// </summary>
/// <param name="lstEmployeedetails"></param>
/// <returns></returns>
public string CreatNewUser(List <MVCModels.User_Employeedetails> lstEmployeedetails, List <MVCModels.User_LeaveTypeModel> lstLeavedetails, List <MVCModels.User_ProductModel> lstProductdetails, List <MVCModels.User_NoticeBoard> lstNoticeboarddetails, List <MVCModels.Splash> lstsplashdetails, List <MVCModels.Edetailing> lstEdetailingDetails, string createdBy, int value, int TPLockvalue, string underuser, int SPLASHID, int EdetailingId, int DACode, string strGuid, string daCode)
{
string result = string.Empty;
_objDALUsercretion = new DAL_UsercreationWizard();
string divisionCode = lstEmployeedetails[0].Division_Code;
string projectCode = lstEmployeedetails[0].Project_Code;
string effectiveFromdate = lstEmployeedetails[0].Effective_From;
int InsertDivisionCount = 1, InsertUserProjectCount = 1;
if (lstEmployeedetails != null && lstEmployeedetails.Count > 0)
{
string companyCode = lstEmployeedetails[0].Company_Code;
string employeeEntrymode = lstEmployeedetails[0].Entry_Mode;
result = _objDALUsercretion.InsertEmployeedetails(lstEmployeedetails);
if (result.Split(':')[0].ToUpper() == "SUCCESS")
{
string employeeCode = result.Split(':')[1];
lstEmployeedetails.ForEach
(
y => y.Employee_Code = employeeCode
);
result = _objDALUsercretion.InsertUserDetails(lstEmployeedetails, value, TPLockvalue, underuser, SPLASHID, EdetailingId, DACode, strGuid, daCode);
if (result.Split(':')[0] == "SUCCESS")
{
string userCode = result.Split('-')[1];
string userName = result.Split('-')[0];
//Inset Project Details
if (!string.IsNullOrEmpty(projectCode))
{
int rowsAffected = _objDALUsercretion.InsertUserProjectDetails(companyCode, userCode, projectCode, effectiveFromdate);
if (rowsAffected < InsertUserProjectCount)
{
result = revertInsertedUserDetails(companyCode, employeeCode, userCode, 0, 0, 0, employeeEntrymode, divisionCode, InsertDivisionCount, InsertUserProjectCount);
}
}
if (lstLeavedetails.Count > 0)
{
lstLeavedetails.ForEach
(
z => z.User_Code = userCode
);
int rowsaffected = _objDALUsercretion.InsertLeaveDetails(lstLeavedetails);
if (rowsaffected < lstLeavedetails.Count)
{
result = revertInsertedUserDetails(companyCode, employeeCode, userCode, 0, 0, lstLeavedetails.Count, employeeEntrymode, divisionCode, InsertDivisionCount, InsertUserProjectCount);
}
}
if (lstProductdetails.Count > 0)
{
lstProductdetails.ForEach
(
z => z.User_Code = userCode
);
DataTable dtUserProduct = null;
if (lstProductdetails.Count >= 1)
{
dtUserProduct = new DataTable();
dtUserProduct.Columns.Add("Company_Code", typeof(string));
dtUserProduct.Columns.Add("User_Code", typeof(string));
dtUserProduct.Columns.Add("Product_Code", typeof(string));
dtUserProduct.Columns.Add("Current_Stock", typeof(string));
dtUserProduct.Columns.Add("Effective_From", typeof(string));
dtUserProduct.Columns.Add("Min_Count", typeof(int));
dtUserProduct.Columns.Add("Max_Count", typeof(int));
for (int i = 0; i < lstProductdetails.Count; i++)
{
dtUserProduct.Rows.Add(lstProductdetails[i].Company_Code, lstProductdetails[i].User_Code, lstProductdetails[i].Product_Code, lstProductdetails[i].Current_Stock, lstProductdetails[i].Effective_From, lstProductdetails[i].Min_Count, lstProductdetails[i].Max_Count);
}
}
int insertproduct = _objDALUsercretion.InsertProductDetails(dtUserProduct);
if (insertproduct < lstProductdetails.Count)
{
result = revertInsertedUserDetails(companyCode, employeeCode, userCode, 0, lstProductdetails.Count, lstLeavedetails.Count, employeeEntrymode, divisionCode, InsertDivisionCount, InsertUserProjectCount);
}
}
if (lstNoticeboarddetails.Count > 0)
{
lstNoticeboarddetails.ForEach
(
z => z.User_Code = userCode
);
int insertnotice = _objDALUsercretion.InsertNoticeBoardDetails(lstNoticeboarddetails);
if (insertnotice < lstNoticeboarddetails.Count)
{
result = revertInsertedUserDetails(companyCode, employeeCode, userCode, lstNoticeboarddetails.Count, lstProductdetails.Count, lstLeavedetails.Count, employeeEntrymode, divisionCode, InsertDivisionCount, InsertUserProjectCount);
}
}
//if (lstsplashdetails.Count > 0)
//{
// //lstsplashdetails.ForEach
// // (
// // // z => z.User_Code = userCode
// // );
// int insertsplash = _objDALUsercretion.Insertsplash(lstsplashdetails);
// if (insertsplash < lstsplashdetails.Count)
// result = revertInsertedUserDetails(companyCode, employeeCode, userCode, lstsplashdetails.Count, lstProductdetails.Count, lstLeavedetails.Count, employeeEntrymode, divisionCode, InsertDivisionCount, InsertUserProjectCount);
//}
}
else
{
result = revertInsertedUserDetails(companyCode, employeeCode, "", 0, 0, 0, employeeEntrymode, divisionCode, InsertDivisionCount, InsertUserProjectCount);
}
//end of user creation
}
}
else
{
result = "FAILURE";
}
return(result);
}