public OperationStatus ActionCarPoolRequest(CarPoolAssociationCustomModel model)
{
OperationStatus status = OperationStatus.Error;
DateTime PoolDate = Convert.ToDateTime(model.DDate);
try
{
using (dbcontext = new CarPoolApplicationEntities())
{
var updatePoolInfo = dbcontext.tblCarPoolMemberAssociations.FirstOrDefault(x => x.AssociationId == model.AssociationId);
if (updatePoolInfo != null)
{
updatePoolInfo.IsApproved = model.IsApproved;
updatePoolInfo.ModifiedBy = model.ModifiedBy;
updatePoolInfo.ModifiedDate = DateTime.Now;
dbcontext.SaveChanges();
status = OperationStatus.Update;
}
else
{
status = OperationStatus.Duplicate;
}
}
}
catch (Exception ex)
{
dbcontext.Dispose();
status = OperationStatus.Exception;
throw ex;
}
return(status);
}
/// <summary>
/// method is used for validate application users
/// </summary>
/// <param name="Logininfo"></param>
/// <returns></returns>
public object GetLoginUser(LoginUserModel Logininfo)
{
APIResponse _response = new APIResponse();
LoggedInUserModel lgAppUserDetails = new LoggedInUserModel();
object objLgAppUserDetails;
try
{
using (dbcontext = new CarPoolApplicationEntities())
{
Logininfo.UserName = Logininfo.UserName.ToLower();
tblApplicationUser lgDetail = dbcontext.tblApplicationUsers.FirstOrDefault(x => x.UserName.ToLower() == Logininfo.UserName && x.IsDeleted == false);
if (lgDetail != null)
{
if (lgDetail.Password == Logininfo.Password)
{
lgAppUserDetails.ApplicationUserId = lgDetail.ApplicationUserId;
lgAppUserDetails.IsActive = lgDetail.IsActive;
lgAppUserDetails.UserIdentityKey = lgDetail.UserIdentityKey;
lgAppUserDetails.success = true;
lgAppUserDetails.ErrorMessage = "User Authenticated!!";
lgAppUserDetails.Name = lgDetail.Name == null ? "" : lgDetail.Name;
lgAppUserDetails.EmailId = lgDetail.EmailId;
lgAppUserDetails.MobileNo = lgDetail.MobileNo;
lgAppUserDetails.Gender = lgDetail.tblMember != null ? lgDetail.tblMember.Gender : null;
lgAppUserDetails.DateOfBirth = lgDetail.tblMember != null ? lgDetail.tblMember.DateOfBirth : null;
lgAppUserDetails.Address = lgDetail.tblMember != null ? lgDetail.tblMember.Address : null;
lgAppUserDetails.FatherName = lgDetail.tblMember != null ? lgDetail.tblMember.FatherName : null;
lgAppUserDetails.MotherName = lgDetail.tblMember != null ? lgDetail.tblMember.MotherName : null;
_response.Message = "User Authenticated!!";
_response.IsSucess = true;
}
else
{
lgAppUserDetails.ErrorMessage = "Invalid password!!";
_response.Message = "Invalid password!!";
_response.IsSucess = false;
}
}
else
{
lgAppUserDetails.ErrorMessage = "Invalid username!!";
_response.Message = "Invalid username!!";
_response.IsSucess = false;
}
}
}
catch (Exception ex)
{
lgAppUserDetails = null;
objLgAppUserDetails = null;
dbcontext = null;
lgAppUserDetails.ErrorMessage = ex.Message.ToString();
}
objLgAppUserDetails = lgAppUserDetails;
return(objLgAppUserDetails);
}
public object SearchCarPoolApplication(CarPoolRegistrationCustomModel model)
{
List <CarPoolRegistrationCustomModel> CarPoolListModel = new List <CarPoolRegistrationCustomModel>();
DateTime SearchDate = Convert.ToDateTime(model.PoolDate);
try
{
using (dbcontext = new CarPoolApplicationEntities())
{
CarPoolListModel = dbcontext.tblCarPoolRegistrations.Where(x => x.IsDeleted == false &&
(x.PoolDate.Value.Year == SearchDate.Year &&
x.PoolDate.Value.Month == SearchDate.Month &&
x.PoolDate.Value.Day == SearchDate.Day) &&
(x.Source.ToLower().Trim().Contains(model.Source.ToLower().Trim()) || model.Source.Trim() == String.Empty || model.Source == null) &&
(x.Destination.ToLower().Trim().Contains(model.Destination.ToLower().Trim()) || model.Destination.Trim() == String.Empty || model.Destination == null)
).Select(x => new CarPoolRegistrationCustomModel
{
Id = x.Id,
MemberId = x.MemberId,
MemberName = x.tblMember != null ? x.tblMember.Name : "",
MobileNo = x.tblMember != null ? x.tblMember.MobileNo : "",
EmailId = x.tblMember != null ? x.tblMember.EmailId : "",
Source = x.Source,
Destination = x.Destination,
PoolDate = x.PoolDate,
Charges = x.Charges,
Time = x.Time,
SeatsAvailable = x.SeatsAvailable,
IsActive = x.IsActive,
IsDeleted = x.IsDeleted,
CreatedBy = x.CreatedBy,
CreatedDate = x.CreatedDate,
ModifiedBy = x.ModifiedBy,
ModifiedDate = x.ModifiedDate
}).OrderByDescending(x => x.Id).ToList();
}
}
catch (Exception ex)
{
dbcontext.Dispose();
throw ex;
}
return(CarPoolListModel);
//DateTime KMEndDate = objDailyKisanMarketReportModel.EndDate.Add(new TimeSpan(5, 30, 0));
//DailyKisanListDetailQ = DailyKisanListDetailQ.Where(x =>
// (x.SaleDate.Year >= KMStartDate.Year
// && x.SaleDate.Month >= KMStartDate.Month
// && x.SaleDate.Day >= KMStartDate.Day)
// && (x.SaleDate.Year <= KMEndDate.Year
// && x.SaleDate.Month <= KMEndDate.Month
// && x.SaleDate.Day <= KMEndDate.Day)
}
public OperationStatus ForgotPassword(ForgotPasswordCustomModel model)
{
OperationStatus status = OperationStatus.Error;
try
{
using (dbcontext = new CarPoolApplicationEntities())
{
var rs = dbcontext.tblApplicationUsers.FirstOrDefault(x => x.UserName == model.UserName);
if (rs != null)
{
string from = "*****@*****.**"; //any valid GMail ID
string to = Convert.ToString(rs.EmailId); //any valid GMail ID
using (MailMessage mail = new MailMessage(from, to))
{
mail.Subject = "Car Pool Management Forgot Password";
mail.Body = "Dear " + rs.Name + " <br><br>Please use this password to login: "******"<br><br>Thanks,<br>Team";
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = false;
smtp.Credentials = new System.Net.NetworkCredential
("*****@*****.**", "shally123");// Enter seders User name and password
smtp.EnableSsl = true;
smtp.Send(mail);
status = OperationStatus.Success;
}
}
else
{
status = OperationStatus.Duplicate;
}
}
}
catch (Exception ex)
{
dbcontext.Dispose();
status = OperationStatus.Exception;
throw ex;
}
return(status);
}
public object GetApplicationMemberList(MemberCustomModel objMemberModel)
{
IList <MemberCustomModel> MemberListModel = new List <MemberCustomModel>();
using (response = new Response())
{
using (dbcontext = new CarPoolApplicationEntities())
{
try
{
response.success = true;
MemberListModel = dbcontext.tblMembers.Where(x => x.IsDeleted == false)
.Select(x => new MemberCustomModel
{
MemberId = x.MemberId,
Name = x.Name,
EmailId = x.EmailId,
MobileNo = x.MobileNo,
MotherName = x.MotherName,
FatherName = x.FatherName,
Address = x.Address,
DateOfBirth = x.DateOfBirth,
Gender = x.Gender,
Image = x.Image,
IsActive = x.IsActive,
IsDeleted = x.IsDeleted,
CreatedBy = x.CreatedBy,
CreatedDate = x.CreatedDate,
ModifyBy = x.ModifyBy,
ModifiedDate = x.ModifiedDate,
}).OrderByDescending(x => x.MemberId).ToList();
return(MemberListModel);
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
return(response);
}
}
}
}
public object MyCarPoolApplication(int MemberId)
{
List <CarPoolRegistrationCustomModel> CarPoolListModel = new List <CarPoolRegistrationCustomModel>();
try
{
using (dbcontext = new CarPoolApplicationEntities())
{
CarPoolListModel = dbcontext.tblCarPoolRegistrations.Where(x => x.IsDeleted == false &&
(x.MemberId == MemberId)
).Select(x => new CarPoolRegistrationCustomModel
{
Id = x.Id,
MemberId = x.MemberId,
MemberName = x.tblMember != null ? x.tblMember.Name : "",
MobileNo = x.tblMember != null ? x.tblMember.MobileNo : "",
EmailId = x.tblMember != null ? x.tblMember.EmailId : "",
Source = x.Source,
Destination = x.Destination,
PoolDate = x.PoolDate,
Charges = x.Charges,
Time = x.Time,
SeatsAvailable = x.SeatsAvailable,
IsActive = x.IsActive,
IsDeleted = x.IsDeleted,
CreatedBy = x.CreatedBy,
CreatedDate = x.CreatedDate,
ModifiedBy = x.ModifiedBy,
ModifiedDate = x.ModifiedDate
}).OrderByDescending(x => x.Id).ToList();
}
}
catch (Exception ex)
{
dbcontext.Dispose();
throw ex;
}
return(CarPoolListModel);
}
public object ListMyCarPoolActionRequest(int Id, DateTime DDate, int Status)
{
List <CarPoolAssociationCustomModel> CarPoolListModel = new List <CarPoolAssociationCustomModel>();
DateTime PoolDate = Convert.ToDateTime(DDate);
try
{
using (dbcontext = new CarPoolApplicationEntities())
{
CarPoolListModel = dbcontext.tblCarPoolMemberAssociations.Where(x => x.IsDeleted == false &&
x.CarPoolId == Id &&
(x.IsApproved == Status || Status == 0) &&
((x.DDate.Value.Year == PoolDate.Year && x.DDate.Value.Month == PoolDate.Month && x.DDate.Value.Day == PoolDate.Day) || PoolDate == null)
).Select(x => new CarPoolAssociationCustomModel
{
AssociationId = x.AssociationId,
CarPoolId = x.CarPoolId,
MemberId = x.MemberId,
MemberName = x.tblMember != null ? x.tblMember.Name : "",
DDate = x.DDate,
Description = x.Description,
IsApproved = x.IsApproved,
IsActive = x.IsActive,
IsDeleted = x.IsDeleted,
CreatedBy = x.CreatedBy,
CreatedDate = x.CreatedDate,
ModifiedBy = x.ModifiedBy,
ModifiedDate = x.ModifiedDate
}).OrderByDescending(x => x.AssociationId).ToList();
}
}
catch (Exception ex)
{
dbcontext.Dispose();
throw ex;
}
return(CarPoolListModel);
}
/// <summary>
/// This method is used to save new pool info
/// </summary>
/// <returns></returns>
public OperationStatus SaveCarPoolApplication(CarPoolRegistrationCustomModel model)
{
OperationStatus status = OperationStatus.Error;
try
{
using (dbcontext = new CarPoolApplicationEntities())
{
if (model.Id == 0)
{
tblCarPoolRegistration _addCarPool = new tblCarPoolRegistration
{
MemberId = model.MemberId,
Source = model.Source,
Destination = model.Destination,
PoolDate = model.PoolDate,
Time = model.Time,
Charges = model.Charges,
SeatsAvailable = model.SeatsAvailable,
IsActive = true,
IsDeleted = false,
CreatedDate = DateTime.Now,
CreatedBy = model.CreatedBy,
ModifiedDate = DateTime.Now,
ModifiedBy = model.ModifiedBy,
};
dbcontext.tblCarPoolRegistrations.Add(_addCarPool);
dbcontext.SaveChanges();
status = OperationStatus.Success;
}
else
{
var updatePoolInfo = dbcontext.tblCarPoolRegistrations.FirstOrDefault(m => m.Id == model.Id);
if (updatePoolInfo != null)
{
updatePoolInfo.MemberId = model.MemberId;
updatePoolInfo.Source = model.Source;
updatePoolInfo.Destination = model.Destination;
updatePoolInfo.PoolDate = model.PoolDate;
updatePoolInfo.Time = model.Time;
updatePoolInfo.Charges = model.Charges;
updatePoolInfo.SeatsAvailable = model.SeatsAvailable;
updatePoolInfo.ModifiedBy = model.ModifiedBy;
updatePoolInfo.ModifiedDate = DateTime.Now;
dbcontext.SaveChanges();
status = OperationStatus.Update;
}
}
}
}
catch (Exception ex)
{
dbcontext.Dispose();
status = OperationStatus.Exception;
throw ex;
}
return(status);
}
/// <summary>
/// This method is used to save new members
/// </summary>
/// <returns></returns>
public OperationStatus SaveApplicationUser(ApplicationUserModel applicationUserModel)
{
OperationStatus status = OperationStatus.Error;
using (TransactionScope ts = new TransactionScope())
{
try
{
using (dbcontext = new CarPoolApplicationEntities())
{
if (applicationUserModel.ApplicationUserId == 0)
{
var rs = dbcontext.tblApplicationUsers.FirstOrDefault(x => x.UserName == applicationUserModel.UserName && x.IsDeleted == false);
if (rs == null)
{
tblMember _addMember = new tblMember
{
Name = applicationUserModel.Name,
EmailId = applicationUserModel.EmailId,
MobileNo = applicationUserModel.MobileNo,
Gender = applicationUserModel.Gender,
DateOfBirth = applicationUserModel.DateOfBirth,
Address = applicationUserModel.Address,
FatherName = applicationUserModel.FatherName,
MotherName = applicationUserModel.MotherName,
IsActive = true,
IsDeleted = false,
CreatedDate = DateTime.Now,
CreatedBy = applicationUserModel.CreatedBy,
ModifiedDate = DateTime.Now,
ModifyBy = applicationUserModel.ModifyBy,
};
dbcontext.tblMembers.Add(_addMember);
dbcontext.SaveChanges();
int userid = _addMember.MemberId;
tblApplicationUser _applicationUserinfo = new tblApplicationUser
{
Name = applicationUserModel.Name,
EmailId = applicationUserModel.EmailId,
MobileNo = applicationUserModel.MobileNo,
UserIdentityKey = userid,
UserName = applicationUserModel.UserName,
Password = applicationUserModel.Password,
IsActive = true,
IsDeleted = false,
CreatedDate = DateTime.Now,
CreatedBy = applicationUserModel.CreatedBy,
ModifiedDate = DateTime.Now,
ModifyBy = applicationUserModel.ModifyBy,
};
dbcontext.tblApplicationUsers.Add(_applicationUserinfo);
dbcontext.SaveChanges();
status = OperationStatus.Success;
ts.Complete();
}
else
{
status = OperationStatus.Duplicate;
//ts.Dispose();
}
}
}
}
catch (Exception ex)
{
dbcontext.Dispose();
status = OperationStatus.Exception;
ts.Dispose();
throw ex;
}
}
return(status);
}
/// <summary>
/// This method is used to save car pool requests
/// </summary>
/// <returns></returns>
public OperationStatus SubmitCarPoolRequest(CarPoolAssociationCustomModel model)
{
OperationStatus status = OperationStatus.Error;
DateTime PoolDate = Convert.ToDateTime(model.DDate);
try
{
using (dbcontext = new CarPoolApplicationEntities())
{
if (model.AssociationId == 0)
{
var rs = dbcontext.tblCarPoolMemberAssociations.FirstOrDefault(x => x.MemberId == model.MemberId &&
x.CarPoolId == model.CarPoolId &&
(x.DDate.Value.Year == PoolDate.Year && x.DDate.Value.Month == PoolDate.Month && x.DDate.Value.Day == PoolDate.Day)
);
if (rs == null)
{
tblCarPoolMemberAssociation _addCarPool = new tblCarPoolMemberAssociation
{
MemberId = model.MemberId,
CarPoolId = model.CarPoolId,
DDate = PoolDate,
Description = model.Description,
IsApproved = 1,
IsActive = true,
IsDeleted = false,
CreatedDate = DateTime.Now,
CreatedBy = model.CreatedBy,
ModifiedDate = DateTime.Now,
ModifiedBy = model.ModifiedBy,
};
dbcontext.tblCarPoolMemberAssociations.Add(_addCarPool);
dbcontext.SaveChanges();
status = OperationStatus.Success;
}
else
{
status = OperationStatus.Duplicate;
}
}
else
{
var rs = dbcontext.tblCarPoolMemberAssociations.FirstOrDefault(m => m.IsDeleted == false &&
m.MemberId == model.MemberId &&
m.CarPoolId == model.CarPoolId &&
(m.DDate.Value.Year == PoolDate.Year && m.DDate.Value.Month == PoolDate.Month && m.DDate.Value.Day == PoolDate.Day) &&
m.AssociationId != model.AssociationId
);
if (rs == null)
{
var updatePoolInfo = dbcontext.tblCarPoolMemberAssociations.FirstOrDefault(x => x.AssociationId == model.AssociationId);
if (updatePoolInfo != null)
{
updatePoolInfo.MemberId = model.MemberId;
updatePoolInfo.CarPoolId = model.CarPoolId;
updatePoolInfo.DDate = PoolDate;
updatePoolInfo.Description = model.Description;
updatePoolInfo.ModifiedBy = model.ModifiedBy;
updatePoolInfo.ModifiedDate = DateTime.Now;
dbcontext.SaveChanges();
status = OperationStatus.Update;
}
}
else
{
status = OperationStatus.Duplicate;
}
}
}
}
catch (Exception ex)
{
dbcontext.Dispose();
status = OperationStatus.Exception;
throw ex;
}
return(status);
}
