public ResponseModel SaveUserDetail(UserCredientialDetail model)
{
try
{
DbContext.UserCredientialDetail.Add(model);
return(new ResponseModel {
Success = true, Message = "Success"
});
}
catch (Exception ex)
{
throw ex;
}
}
public ResponseModel UpdateEmployee(UserCredientialViewModel model, Employee employeeOb)
{
var flag = false;
try
{
UserCredentials userCredentials = DbContext.UserCredentials.Where(r => r.Id == model.Id).FirstOrDefault();
userCredentials.IsActive = model.IsActive;
userCredentials.PhoneNumber = model.PhoneNumber;
userCredentials.Email = model.Email;
UserCredientialDetail userCredientialDetail = DbContext.UserCredientialDetail.Where(r => r.UserCredentialId == model.Id).FirstOrDefault();
if (userCredientialDetail != null)
{
userCredientialDetail.DathOfBirth = model.DathOfBirth;
}
Employee employee = DbContext.Employee.Where(r => r.Id == employeeOb.Id).FirstOrDefault();
employee.DesignationId = employeeOb.DesignationId;
employee.ContactNo = employeeOb.ContactNo;
employee.Name = employeeOb.Name;
DbContext.Database.BeginTransaction();
flag = true;
DbContext.Entry(userCredentials).State = System.Data.Entity.EntityState.Modified;
DbContext.Entry(userCredientialDetail).State = System.Data.Entity.EntityState.Modified;
DbContext.Entry(employee).State = System.Data.Entity.EntityState.Modified;
DbContext.SaveChanges();
flag = false;
DbContext.Database.CurrentTransaction.Commit();
return(new ResponseModel {
Success = true, Message = "Success"
});
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (flag)
{
DbContext.Database.CurrentTransaction.Rollback();
}
}
}
public ResponseModel SaveUser(UserCredientialViewModel model, List <UserWithPackage> userWithPackage
, List <UserWeekDayOff> userWeekDayOffs)
{
var flag = false;
try
{
UserCredentials userCredentials = new UserCredentials
{
Id = Guid.NewGuid().ToString(),
LoginID = model.LoginID,
Password = model.Password,
FullName = model.FullName,
Email = model.Email,
UserTypeId = model.UserTypeId,
IsActive = model.IsActive,
PhoneNumber = model.PhoneNumber,
ImagePath = model.ImagePath,
FileId = model.FileId,
FileName = model.FileName,
CreatedDate = DateTime.Now,
CreatedById = model.CreatedById,
UpdatedDate = null
};
UserCredientialDetail userCredientialDetail = new UserCredientialDetail
{
UserCredentialId = userCredentials.Id,
Gender = model.Gender,
Age = CommonHelper.CalculateYourAge(model.DathOfBirth).Years,
DathOfBirth = model.DathOfBirth,
BloodGroup = model.BloodGroup,
Weight = model.Weight,
Height = model.Height,
Diabetes = model.Diabetes,
Allergy = model.Allergy,
AllergyDetail = model.AllergyDetail,
BP = model.BP,
NationalId = model.NationalId,
CompanyId = model.CompanyId,
CompanyName = model.CompanyName,
CompanyAddress = model.Address,
Address = model.Address,
Department = model.Department,
Section = model.Section,
Designation = model.Designation,
ReferencePersonName = model.ReferencePersonName,
ReferencePersonCellNumber = model.ReferencePersonCellNumber,
ReplacementMenu = model.ReplacementMenu,
SpecialMenu = model.SpecialMenu,
WeekDayOff = model.WeekDayOff,
SalesExecutiveId = model.SalesExecutiveId,
DeliveryManId = model.DeliveryManId,
PaidAmount = model.PaidAmount,
DueAmount = model.DueAmount,
RegistrationAmount = model.RegistrationAmount,
Status = model.Status,
AccountType = model.AccountType,
CreatedDate = DateTime.Now
};
UserActiveStatus userActiveStatus = new UserActiveStatus
{
Id = Guid.NewGuid().ToString(),
Status = model.Status,
UserCredentialId = userCredentials.Id,
CreatedDate = DateTime.Now,
CreatedById = model.CreatedById,
};
DbContext.Database.BeginTransaction();
flag = true;
DbContext.UserCredentials.Add(userCredentials);
SaveUserDetail(userCredientialDetail);
DbContext.SaveChanges();
DbContext.UserActiveStatus.Add(userActiveStatus);
foreach (var item in userWithPackage)
{
item.Id = Guid.NewGuid().ToString();
item.UserCrediantialId = userCredentials.Id;
item.CreatedDate = DateTime.Now;
SaveUserAdvance(item);
}
if (userWeekDayOffs != null)
{
foreach (var item in userWeekDayOffs)
{
item.Id = Guid.NewGuid().ToString();
item.UserId = userCredentials.Id;
item.CreatedDate = DateTime.Now;
SaveUserWeekDayOff(item);
}
}
DbContext.SaveChanges();
flag = false;
DbContext.Database.CurrentTransaction.Commit();
return(new ResponseModel {
Success = true, Message = "Success"
});
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (flag)
{
DbContext.Database.CurrentTransaction.Rollback();
}
}
}
public ResponseModel SaveEmployee(UserCredientialViewModel model, Employee employeeOb)
{
var flag = false;
try
{
UserCredentials userCredentials = new UserCredentials
{
Id = Guid.NewGuid().ToString(),
LoginID = model.LoginID,
Password = model.Password,
FullName = model.FullName,
Email = model.Email,
UserTypeId = model.UserTypeId,
IsActive = model.IsActive,
PhoneNumber = model.PhoneNumber,
ImagePath = model.ImagePath,
CreatedDate = DateTime.Now,
CreatedById = model.CreatedById,
UpdatedDate = null
};
UserCredientialDetail userCredientialDetail = new UserCredientialDetail
{
UserCredentialId = userCredentials.Id,
Gender = model.Gender,
Age = CommonHelper.CalculateYourAge(model.DathOfBirth).Years,
DathOfBirth = model.DathOfBirth,
BloodGroup = model.BloodGroup,
Weight = model.Weight,
Height = model.Height,
Diabetes = model.Diabetes,
Allergy = model.Allergy,
AllergyDetail = model.AllergyDetail,
BP = model.BP,
NationalId = model.NationalId,
CompanyName = model.CompanyName,
CompanyAddress = model.Address,
Address = model.Address,
Department = model.Department,
Section = model.Section,
Designation = model.Designation,
ReferencePersonName = model.ReferencePersonName,
ReferencePersonCellNumber = model.ReferencePersonCellNumber,
ReplacementMenu = model.ReplacementMenu,
SpecialMenu = model.SpecialMenu,
WeekDayOff = model.WeekDayOff,
SalesExecutiveId = model.SalesExecutiveId,
DeliveryManId = model.DeliveryManId,
LunchStartDate = null,
PaidAmount = null,
DueAmount = model.DueAmount,
CreatedDate = DateTime.Now
};
Employee employee = new Employee
{
Id = Guid.NewGuid().ToString(),
LoginKey = userCredentials.Id,
Name = employeeOb.Name,
EmployeeCode = employeeOb.EmployeeCode,
DesignationId = employeeOb.DesignationId,
ContactNo = employeeOb.ContactNo,
CreatedAt = DateTime.Now,
CreatedById = employeeOb.CreatedById
};
DbContext.Database.BeginTransaction();
flag = true;
DbContext.UserCredentials.Add(userCredentials);
SaveUserDetail(userCredientialDetail);
SaveUserEmployee(employee);
DbContext.SaveChanges();
flag = false;
DbContext.Database.CurrentTransaction.Commit();
return(new ResponseModel {
Success = true, Message = "Success"
});
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (flag)
{
DbContext.Database.CurrentTransaction.Rollback();
}
}
}
public ResponseModel EditProfile(UserCredientialViewModel model, List <UserWeekDayOff> userWeekDayOffs)
{
var flag = false;
try
{
UserCredentials userCredentials = DbContext.UserCredentials.Where(r => r.Id == model.Id).FirstOrDefault();
userCredentials.FullName = model.FullName;
userCredentials.Email = model.Email;
userCredentials.IsActive = model.IsActive;
userCredentials.PhoneNumber = model.PhoneNumber;
userCredentials.ImagePath = model.ImagePath;
userCredentials.FileId = model.FileId;
userCredentials.FileName = model.FileName;
userCredentials.UpdatedDate = DateTime.Now;
UserCredientialDetail userCredientialDetail = DbContext.UserCredientialDetail.Where(r => r.UserCredentialId == model.Id).FirstOrDefault();
userCredientialDetail.UserCredentialId = userCredentials.Id;
userCredientialDetail.Gender = model.Gender;
userCredientialDetail.Age = CommonHelper.CalculateYourAge(model.DathOfBirth).Years;
userCredientialDetail.DathOfBirth = model.DathOfBirth;
userCredientialDetail.BloodGroup = model.BloodGroup;
userCredientialDetail.Weight = model.Weight;
userCredientialDetail.Height = model.Height;
userCredientialDetail.Diabetes = model.Diabetes;
userCredientialDetail.Allergy = model.Allergy;
userCredientialDetail.AllergyDetail = model.AllergyDetail;
userCredientialDetail.BP = model.BP;
userCredientialDetail.NationalId = model.NationalId;
userCredientialDetail.CompanyId = model.CompanyId;
userCredientialDetail.CompanyName = model.CompanyName;
userCredientialDetail.CompanyAddress = model.Address;
userCredientialDetail.Address = model.Address;
userCredientialDetail.Department = model.Department;
userCredientialDetail.Section = model.Section;
userCredientialDetail.Designation = model.Designation;
userCredientialDetail.ReferencePersonName = model.ReferencePersonName;
userCredientialDetail.ReferencePersonCellNumber = model.ReferencePersonCellNumber;
userCredientialDetail.ReplacementMenu = model.ReplacementMenu;
userCredientialDetail.SpecialMenu = model.SpecialMenu;
userCredientialDetail.WeekDayOff = model.WeekDayOff;
userCredientialDetail.LunchReceiveAddress = model.LunchReceiveAddress;
userCredientialDetail.UpdatedDate = DateTime.Now;
UserActiveStatus userActiveStatus = DbContext.UserActiveStatus.Where(r => r.UserCredentialId == userCredentials.Id).OrderByDescending(a => a.CreatedDate).FirstOrDefault();
DbContext.Database.BeginTransaction();
flag = true;
DbContext.Entry(userCredentials).State = System.Data.Entity.EntityState.Modified;
DbContext.SaveChanges();
DbContext.Entry(userCredientialDetail).State = System.Data.Entity.EntityState.Modified;
DbContext.SaveChanges();
if (userWeekDayOffs != null)
{
foreach (var item in userWeekDayOffs)
{
if (item.Id == null)
{
item.Id = Guid.NewGuid().ToString();
item.UserId = userCredentials.Id;
item.CreatedDate = DateTime.Now;
SaveUserWeekDayOff(item);
}
else
{
UserWeekDayOff uw = DbContext.UserWeekDayOff.Where(r => r.Id == item.Id).FirstOrDefault();
uw.UpdatedDate = DateTime.Now;
DbContext.Entry(uw).State = System.Data.Entity.EntityState.Modified;
}
}
}
DbContext.SaveChanges();
flag = false;
DbContext.Database.CurrentTransaction.Commit();
return(new ResponseModel {
Success = true, Message = "Success"
});
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (flag)
{
DbContext.Database.CurrentTransaction.Rollback();
}
}
}
