/// <summary>
/// Get Department list
/// </summary>
/// <param name="Departmentid">To pass DepartmentId in this parameter</param>
/// <returns></returns>
public static List <Functionviewmodel> GetFunctionlist(int Departmentid)
{
try
{
List <Functionviewmodel> Funmodel = new List <Functionviewmodel>();
using (var context = new IOASDBEntities())
{
var query = (from D in context.tblRole
where (D.DepartmentId == Departmentid && D.Status == "Active")
select new { D.RoleId, D.RoleName }).ToList();
if (query.Count > 0)
{
for (int i = 0; i < query.Count; i++)
{
Funmodel.Add(new Functionviewmodel()
{
sno = i + 1,
Roleid = query[i].RoleId,
Rolename = query[i].RoleName
});
}
}
}
return(Funmodel);
}
catch (Exception ex)
{
return(null);
}
}
public static int MapProcessflowUser(List <ProcessFlowUser> selectedUser)
{
try
{
int rowsAffected = 0;
using (var context = new IOASDBEntities())
{
if (selectedUser.Count > 0)
{
foreach (var user in selectedUser)
{
tblProcessGuidelineUser objIU = new tblProcessGuidelineUser();
objIU.ProcessGuidelineDetailId = user.ProcessGuidelineDetailId;
objIU.UserId = user.UserId;
context.tblProcessGuidelineUser.Add(objIU);
rowsAffected = rowsAffected + context.SaveChanges();
}
}
}
return(rowsAffected);
}
catch
{
return(-1);
}
}
public static bool ChangePasswordforuser(ChangePasswordModel model, String username)
{
try
{
using (var context = new IOASDBEntities())
{
var oldpassword = Cryptography.Encrypt(model.OldPassword, "LFPassW0rd");
var userquery = context.tblUser.SingleOrDefault(dup => dup.UserName == username && dup.Password == oldpassword);
if (userquery != null)
{
userquery.Password = Cryptography.Encrypt(model.NewPassword, "LFPassW0rd");;
context.SaveChanges();
context.Dispose();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
return(false);
}
}
/// <summary>
/// This method when user login check user name and password
/// </summary>
/// <param name="logon"></param>
/// <returns></returns>
public static int Logon(LogOnModel logon)
{
try
{
using (var context = new IOASDBEntities())
{
String Encpassword = Cryptography.Encrypt(logon.Password, "LFPassW0rd");
var userquery = context.tblUser.SingleOrDefault(dup => dup.UserName == logon.UserName && dup.Password == Encpassword && dup.Status == "Active");
if (userquery != null)
{
tblLoginDetails log = new tblLoginDetails();
log.UserId = userquery.UserId;
log.LoginTime = DateTime.Now;
context.tblLoginDetails.Add(log);
context.SaveChanges();
return(userquery.UserId);
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
return(-1);
}
}
public static int Resetpassword(ResetPassword model)
{
try
{
using (var context = new IOASDBEntities())
{
var user = context.tblUser.Where(U => U.UserId == model.Userid).FirstOrDefault();
if (user != null)
{
string Username = model.Username;
user.Password = Cryptography.Encrypt(model.NewPassword, "LFPassW0rd");
user.UPDTDateTS = DateTime.Now;
user.LastUpdateUserId = Common.GetUserid(Username);
context.SaveChanges();
context.Dispose();
return(1);
}
else
{
return(2);
}
}
}
catch (Exception ex)
{
return(-1);
}
}
/// <summary>
/// Get function list in table
/// </summary>
/// <returns>To Fill in dropdown list</returns>
public static List <Functionlistmodel> GetFunction()
{
try
{
List <Functionlistmodel> Function = new List <Functionlistmodel>();
using (var context = new IOASDBEntities())
{
var query = (from F in context.tblFunction
orderby F.FunctionName
select new { F.FunctionId, F.FunctionName }).ToList();
if (query.Count > 0)
{
for (int i = 0; i < query.Count; i++)
{
Function.Add(new Functionlistmodel
{
Functionid = query[i].FunctionId,
Functionname = query[i].FunctionName
});
}
}
}
return(Function);
}
catch (Exception ex)
{
return(null);
}
}
public static int UnmapProcessflowUser(List <ProcessFlowUser> selectedUser)
{
try
{
tblProcessGuidelineUser pglUser;
int rowsAffected = 0;
using (var context = new IOASDBEntities())
{
if (selectedUser.Count > 0)
{
foreach (var user in selectedUser)
{
pglUser = context.tblProcessGuidelineUser.Where(s => s.UserId == user.UserId && s.ProcessGuidelineDetailId == user.ProcessGuidelineDetailId).FirstOrDefault();
context.Entry(pglUser).State = System.Data.Entity.EntityState.Deleted;
rowsAffected = rowsAffected + context.SaveChanges();
}
}
}
return(rowsAffected);
}
catch
{
return(-1);
}
}
//delete PI List in grid
public static int DeletePIlist(int UserId, string Username)
{
try
{
using (var context = new IOASDBEntities())
{
var query = (from D in context.tblUser
where (D.UserId == UserId)
select D.UserId).FirstOrDefault();
var user = context.tblUser.Where(U => U.UserId == UserId).FirstOrDefault();
if (user != null)
{
user.Status = "InActive";
user.UPDTDateTS = DateTime.Now;
user.LastUpdateUserId = Common.GetUserid(Username);
context.SaveChanges();
}
}
return(4);
}
catch (Exception ex)
{
return(-1);
}
}
public static List <ProcessGuideline> GetProcessGuideLineList(int functionId, string processName)
{
List <ProcessGuideline> objProcessGuideline = new List <ProcessGuideline>();
using (var context = new IOASDBEntities())
{
var query = (from pgl in context.tblProcessGuidelineHeader
from f in context.tblFunction
where (pgl.FunctionId == f.FunctionId && (pgl.FunctionId == functionId || functionId == -1) &&
(pgl.ProcessGuidelineTitle.Contains(processName) || processName == string.Empty)
)
orderby pgl.ProcessGuidelineId
select new { pgl.ProcessGuidelineId, pgl.ProcessGuidelineTitle, f.FunctionName, f.FunctionId }).ToList();
if (query.Count > 0)
{
for (int i = 0; i < query.Count; i++)
{
objProcessGuideline.Add(new ProcessGuideline()
{
ProcessGuidelineId = (Int32)query[i].ProcessGuidelineId,
ProcessName = Convert.ToString(query[i].ProcessGuidelineTitle),
FunctionId = Convert.ToInt32(query[i].FunctionId),
FunctionName = Convert.ToString(query[i].FunctionName)
});
}
}
}
return(objProcessGuideline);
}
public static List <Functionviewmodel> AccessRightsfunction(int functionid, int Departmentid)
{
try
{
List <Functionviewmodel> funaccess = new List <Functionviewmodel>();
using (var context = new IOASDBEntities())
{
var query = (from R in context.tblRoleaccess
where (R.FunctionId == functionid && R.DepartmentId == Departmentid)
select new { R.FunctionId, R.DepartmentId, R.RoleId, R.Read_f, R.Add_f, R.Approve_f, R.Delete_f, R.Update_f }).ToList();
if (query.Count > 0)
{
for (int i = 0; i < query.Count; i++)
{
funaccess.Add(new Functionviewmodel()
{
Roleid = (Int32)query[i].RoleId,
Functionid = (Int32)query[i].FunctionId,
Departmentid = (Int32)query[i].DepartmentId,
Read = (bool)query[i].Read_f,
Add = (bool)query[i].Add_f,
Approve = (bool)query[i].Approve_f,
Delete = (bool)query[i].Delete_f,
Update = (bool)query[i].Update_f
});
}
}
return(funaccess);
}
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// To load department in dropdownlist
/// </summary>
/// <returns></returns>
public static List <RoleModel> Getdepartment()
{
try
{
List <RoleModel> dept = new List <RoleModel>();
using (var context = new IOASDBEntities())
{
var query = (from d in context.tblDepartment
orderby d.DepartmentName
where (d.Status == "Active")
select new { d.DepartmentId, d.DepartmentName }).ToList();
if (query.Count > 0)
{
for (int i = 0; i < query.Count; i++)
{
dept.Add(new RoleModel
{
Departmentid = query[i].DepartmentId,
Departmentname = query[i].DepartmentName
});
}
}
}
return(dept);
}
catch (Exception ex)
{
List <RoleModel> dept = new List <RoleModel>();
return(dept);
}
}
public static int AddProcessFlow(ProcessFlowModel model)
{
using (var context = new IOASDBEntities())
{
tblProcessGuidelineDetail objIU = new tblProcessGuidelineDetail();
objIU.ProcessGuidelineId = model.ProcessGuidelineid;
objIU.FlowTitle = model.FlowTitle;
context.tblProcessGuidelineDetail.Add(objIU);
context.SaveChanges();
context.Dispose();
return(objIU.ProcessGuidelineDetailId);
}
}
/// <summary>
/// Add department wise role authorization
/// </summary>
/// <param name="model">Role access form data</param>
/// <returns></returns>
public static List <Functionviewmodel> AddDepartmentrole(List <Functionviewmodel> model)
{
try
{
List <Functionviewmodel> listfunction = new List <Functionviewmodel>();
tblRoleaccess objrole = new tblRoleaccess();
using (var dbctx = new IOASDBEntities())
{
var funid = model[0].Functionid;
var deptid = model[0].Departmentid;
var query = (from f in dbctx.tblRoleaccess
where (f.FunctionId == funid && f.DepartmentId == deptid)
select f).ToList();
if (query.Count > 0)
{
dbctx.tblRoleaccess.RemoveRange(query);
dbctx.SaveChanges();
}
}
using (var context = new IOASDBEntities())
{
if (model.Count > 0)
{
for (int i = 0; i < model.Count; i++)
{
if (model[i].Read == true)
{
objrole.RoleId = model[i].Roleid;
objrole.FunctionId = model[i].Functionid;
objrole.Read_f = model[i].Read;
objrole.Add_f = model[i].Add;
objrole.Delete_f = model[i].Delete;
objrole.Approve_f = model[i].Approve;
objrole.Update_f = model[i].Update;
objrole.DepartmentId = model[i].Departmentid;
objrole.Status = "Active";
context.tblRoleaccess.Add(objrole);
context.SaveChanges();
}
}
}
return(model);
}
}
catch (Exception ex)
{
var msg = ex;
return(model);
}
}
public static List <ProcessFlowApproverList> GetAllApproverList(int processheaderid, int processDetailId)
{
try
{
List <ProcessFlowApproverList> approvalList = new List <ProcessFlowApproverList>();
using (var context = new IOASDBEntities())
{
var query = (
from WF in context.tblProcessGuidelineWorkFlow
from U in context.tblUser
from S in context.tblFunctionStatus
where (WF.ProcessGuidelineId == processheaderid && WF.StatusId == S.FunctionStatusId && WF.ApproverId == U.UserId && WF.ProcessGuidelineDetailId == processDetailId)
orderby WF.ProcessGuidelineWorkFlowId
select new { WF.ProcessGuidelineWorkFlowId, WF.ProcessGuidelineDetailId, WF.ApproverId, U.UserName, S.Status, WF.StatusId, WF.ApproverLevel, WF.Approve_f, WF.Reject_f, WF.Clarify_f, WF.Mark_f }
).ToList();
if (query.Count > 0)
{
for (int i = 0; i < query.Count; i++)
{
tblProcessGuidelineDocument objDoc = new tblProcessGuidelineDocument();
int pgwfid = query[i].ProcessGuidelineWorkFlowId;
objDoc = context.tblProcessGuidelineDocument.Where(M => M.WorkflowId == pgwfid).FirstOrDefault();
approvalList.Add(new ProcessFlowApproverList()
{
UserId = Convert.ToInt32(query[i].ApproverId),
UserName = Convert.ToString(query[i].UserName),
ProcessGuidelineDetailId = Convert.ToInt32(query[i].ProcessGuidelineDetailId),
ApproverLevel = Convert.ToInt32(query[i].ApproverLevel),
StatusId = Convert.ToInt32(query[i].StatusId),
StatusName = Convert.ToString(query[i].Status),
ApproveFlag = Convert.ToBoolean(query[i].Approve_f),
RejectFlag = Convert.ToBoolean(query[i].Reject_f),
ClarifyFlag = Convert.ToBoolean(query[i].Clarify_f),
MarkFlag = Convert.ToBoolean(query[i].Mark_f),
ProcessguidlineworkflowId = query[i].ProcessGuidelineWorkFlowId,
DocumentId = objDoc != null ? Convert.ToInt32(objDoc.DocumentId) : 0
});
}
}
}
return(approvalList);
}
catch (Exception ex)
{
return(new List <ProcessFlowApproverList>());
}
}
public static int UpdateProcessFlow(ProcessFlowModel model)
{
tblProcessGuidelineDetail pgd;
using (var context = new IOASDBEntities())
{
pgd = context.tblProcessGuidelineDetail.Where(s => s.ProcessGuidelineDetailId == model.ProcessGuidelineDetailId).FirstOrDefault();
}
if (pgd != null)
{
pgd.FlowTitle = model.FlowTitle;
}
using (var dbCtx = new IOASDBEntities())
{
dbCtx.Entry(pgd).State = System.Data.Entity.EntityState.Modified;
dbCtx.SaveChanges();
}
return(model.ProcessGuidelineDetailId);
}
public static int DeletePGLWorkflow(int processguidlineworkflowId)
{
try
{
tblProcessGuidelineWorkFlow pglWF;
int rowsAffected = 0;
using (var context = new IOASDBEntities())
{
pglWF = context.tblProcessGuidelineWorkFlow.Where(s => s.ProcessGuidelineWorkFlowId == processguidlineworkflowId).FirstOrDefault();
context.Entry(pglWF).State = System.Data.Entity.EntityState.Deleted;
rowsAffected = context.SaveChanges();
}
return(rowsAffected);
}
catch
{
return(-1);
}
}
//public List<ReportModulesModel> GetModules()
//{
// List<ReportModulesModel> ModulesList = new List<ReportModulesModel>();
// ModulesList.Add(new ReportModulesModel { ModuleId = 1, ModuleName = "Admin" });
// ModulesList.Add(new ReportModulesModel { ModuleId = 2, ModuleName = "Sales" });
// ModulesList.Add(new ReportModulesModel { ModuleId = 3, ModuleName = "Finance" });
// ModulesList.Add(new ReportModulesModel { ModuleId = 4, ModuleName = "Accounts" });
// ModulesList.Add(new ReportModulesModel { ModuleId = 5, ModuleName = "IT" });
// ModulesList.Add(new ReportModulesModel { ModuleId = 6, ModuleName = "Pay Roll" });
// ModulesList.Add(new ReportModulesModel { ModuleId = 7, ModuleName = "Tester" });
// return ModulesList;
//}
public static List <RolesModel> GetRoles()
{
try
{
List <RolesModel> roles = new List <RolesModel>();
using (var context = new IOASDBEntities())
{
roles = (from R in context.tblRole
orderby R.RoleName
select new RolesModel {
RoleID = R.RoleId, RoleName = R.RoleName
}).ToList();
}
return(roles);
}
catch (Exception ex)
{
return(null);
}
}
public static List <ReportModulesModel> GetModules()
{
try
{
List <ReportModulesModel> modules = new List <ReportModulesModel>();
using (var context = new IOASDBEntities())
{
modules = (from M in context.tblModules
orderby M.ModuleName
select new ReportModulesModel {
ModuleID = M.ModuleID, ModuleName = M.ModuleName
}).ToList();
}
return(modules);
}
catch (Exception ex)
{
return(null);
}
}
public static List <ProcessFlowModel> GetProcessFlowList(int processGuidelineId)
{
List <ProcessFlowModel> processFlowDetails = new List <ProcessFlowModel>();
using (var context = new IOASDBEntities())
{
var query = (from P in context.tblProcessGuidelineDetail where P.ProcessGuidelineId == processGuidelineId orderby P.ProcessGuidelineDetailId select P).ToList();
if (query.Count > 0)
{
for (int i = 0; i < query.Count; i++)
{
processFlowDetails.Add(new ProcessFlowModel()
{
ProcessGuidelineDetailId = (Int32)query[i].ProcessGuidelineDetailId,
FlowTitle = Convert.ToString(query[i].FlowTitle)
});
}
}
}
return(processFlowDetails);
}
public static int InsertProcessGuideline(ProcessGuideline model)
{
using (var context = new IOASDBEntities())
{
tblProcessGuidelineHeader objIU = new tblProcessGuidelineHeader();
objIU.ProcessGuidelineId = model.ProcessGuidelineId;
objIU.FunctionId = model.FunctionId;
objIU.ProcessGuidelineTitle = model.ProcessName;
if (model.ProcessGuidelineId == 0)
{
context.tblProcessGuidelineHeader.Add(objIU);
}
else
{
context.Entry(objIU).State = System.Data.Entity.EntityState.Modified;
}
context.SaveChanges();
context.Dispose();
return(objIU.ProcessGuidelineId);
}
}
public static List <ProcessFlowStatus> GetStatus()
{
List <ProcessFlowStatus> statusList = new List <ProcessFlowStatus>();
using (var context = new IOASDBEntities())
{
var query = (from S in context.tblFunctionStatus orderby S.FunctionStatusId select S).ToList();
if (query.Count > 0)
{
for (int i = 0; i < query.Count; i++)
{
statusList.Add(new ProcessFlowStatus()
{
StatusId = Convert.ToInt32(query[i].FunctionStatusId),
StatusName = Convert.ToString(query[i].Status)
});
}
}
}
return(statusList);
}
public static List <ProcessFlowUser> GetApproverList()
{
List <ProcessFlowUser> approvalList = new List <ProcessFlowUser>();
using (var context = new IOASDBEntities())
{
var query = (from U in context.tblUser where U.ApproverF == true orderby U.UserId select U).ToList();
if (query.Count > 0)
{
for (int i = 0; i < query.Count; i++)
{
approvalList.Add(new ProcessFlowUser()
{
UserId = Convert.ToInt32(query[i].UserId),
UserName = Convert.ToString(query[i].UserName)
});
}
}
}
return(approvalList);
}
public static List <MasterlistviewModel> getPIList(int Departmentid, int Instituteid)
{
try
{
List <MasterlistviewModel> PIList = new List <MasterlistviewModel>();
PIList.Add(new MasterlistviewModel()
{
id = 0,
name = "Select any"
});
using (var context = new IOASDBEntities())
{
if (Departmentid > 0)
{
var query = (from C in context.tblUser
join ins in context.tblInstituteMaster on C.InstituteId equals ins.InstituteId
where (C.RoleId == 2 && C.DepartmentId == Departmentid && C.InstituteId == Instituteid)
orderby C.UserId
select new { C.UserId, C.FirstName, C.LastName, C.EMPCode, ins.Institutecode }).ToList();
if (query.Count > 0)
{
for (int i = 0; i < query.Count; i++)
{
PIList.Add(new MasterlistviewModel()
{
id = query[i].UserId,
name = query[i].EMPCode + "-" + query[i].FirstName + " " + query[i].LastName + "-" + query[i].Institutecode,
});
}
}
}
}
return(PIList);
}
catch (Exception ex)
{
return(null);
}
}
public static List <ProcessFlowUser> GetProcessFlowUserDetails(int processGuidelineDetailId)
{
List <ProcessFlowUser> processFlowUserDetails = new List <ProcessFlowUser>();
using (var context = new IOASDBEntities())
{
var query = (from D in context.tblProcessGuidelineDetail
from U in context.tblUser
join PU in context.tblProcessGuidelineUser on new { DetailId = (int?)D.ProcessGuidelineDetailId, UserId = (int?)U.UserId } equals new { DetailId = PU.ProcessGuidelineDetailId, UserId = PU.UserId } into temp
from PUG in temp.DefaultIfEmpty()
where (D.ProcessGuidelineDetailId == processGuidelineDetailId)
orderby U.UserId
select new
{
UserId = U.UserId
,
UserName = U.UserName
,
UserFlag = (PUG.UserId == null ? 0 : 1)
,
ProcessGuidelineDetailId = D.ProcessGuidelineDetailId //pgd.ProcessGuidelineDetailId
}
).ToList();
if (query.Count > 0)
{
for (int i = 0; i < query.Count; i++)
{
processFlowUserDetails.Add(new ProcessFlowUser()
{
ProcessGuidelineDetailId = (Int32)query[i].ProcessGuidelineDetailId,
UserId = Convert.ToInt32(query[i].UserId),
UserName = Convert.ToString(query[i].UserName),
UserFlag = Convert.ToInt32(query[i].UserFlag) == 0 ? false : true
});
}
}
}
return(processFlowUserDetails);
}
public static int PIRegistration(RegisterModel model)
{
try
{
using (var context = new IOASDBEntities())
{
if (model.UserId == 0)
{
tblUser PIreg = new tblUser();
var chkPI = context.tblUser.FirstOrDefault(dup => dup.Email == model.Email && dup.Status == "Active");
if (chkPI != null)
{
return(2);
}
string Username = model.Createuser;
PIreg.FirstName = model.Firstname;
PIreg.LastName = model.Lastname;
PIreg.RoleId = 7;
PIreg.Dateofbirth = model.Dateofbirth;
PIreg.DepartmentId = model.Department;
PIreg.Gender = model.Gender;
PIreg.CRTDDateTS = DateTime.Now;
PIreg.UPDTDateTS = DateTime.Now;
PIreg.CreatedUserId = Common.GetUserid(Username);
PIreg.Email = model.Email;
PIreg.Status = "Active";
PIreg.InstituteId = model.InstituteId;
PIreg.UserImage = model.Image;
PIreg.EMPCode = model.EMPCode;
PIreg.Designation = model.Designation;
context.tblUser.Add(PIreg);
context.SaveChanges();
return(1);
}
else
{
var objupdatePI = context.tblUser.Where(M => M.UserId == model.UserId).FirstOrDefault();
if (objupdatePI != null)
{
string Username = model.Createuser;
objupdatePI.FirstName = model.Firstname;
objupdatePI.LastName = model.Lastname;
objupdatePI.RoleId = 7;
objupdatePI.Dateofbirth = model.Dateofbirth;
objupdatePI.DepartmentId = model.Department;
objupdatePI.Gender = model.Gender;
objupdatePI.UPDTDateTS = DateTime.Now;
objupdatePI.LastUpdateUserId = Common.GetUserid(Username);
objupdatePI.Email = model.Email;
objupdatePI.Status = "Active";
objupdatePI.InstituteId = model.InstituteId;
if (model.Image != null)
{
objupdatePI.UserImage = model.Image;
}
objupdatePI.EMPCode = model.EMPCode;
objupdatePI.Designation = model.Designation;
context.SaveChanges();
}
return(3);
}
}
}
catch (Exception ex)
{
return(-1);
}
}
/// <summary>
/// This method used for user forgetpassword
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool UserForgotPassword(ForgotPasswordModel model)
{
try
{
using (var context = new IOASDBEntities())
{
var userquery = context.tblUser.SingleOrDefault(dup => dup.Email == model.Email);
//if (userquery != null)
//{
// string temppass = userquery.Password;
// userquery.Password = Cryptography.Decrypt(temppass, "LFPassW0rd");
// if (userquery.Password != null)
// {
// model.password = userquery.Password;
// }
// //context.SaveChanges();
// //context.Dispose();
//}
if (userquery != null)
{
string temppass = Guid.NewGuid().ToString().Substring(0, 8);
userquery.Password = Cryptography.Encrypt(temppass, "LFPassW0rd");
var Disclaimer = EmailTemplate.disclaimer;
using (MailMessage mm = new MailMessage(EmailTemplate.mailid, model.Email))
{
mm.Subject = "IOAS Website Account Password";
string body = "Hello " + userquery.UserName + ",";
body += "<br /><br />Your account password has been reset successfully. Please use the below password to log into the system";
//body += "<br /><a href = '" + Request.Url.AbsoluteUri.Replace("Jobseekers.aspx", "CS_Activation.aspx?ActivationCode=" + activationCode) + "'>Click here to activate your account.</a>";
body += "<br />Your new password is " + temppass;
body += "<br /><br />Thanks";
body += "<br /><br />________________________________________________________________________________________________________________";
body += "<br /><br />*** This is an automatically generated email, please do not reply ***";
body += "<br /><br />" + Disclaimer;
mm.Body = body;
mm.IsBodyHtml = true;
using (SmtpClient smtp = new SmtpClient(EmailTemplate.smtpAddress, EmailTemplate.portNumber))
{
smtp.Credentials = new NetworkCredential(EmailTemplate.mailid, EmailTemplate.password);
//smtp.Credentials = new NetworkCredential("*****@*****.**", "ofni963");
//smtp.EnableSsl = EmailTemplate.enableSSL;
smtp.Send(mm);
}
}
context.SaveChanges();
context.Dispose();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
return(true);
}
}
public static List <ProposalRepotViewModels> Getproposal(ProposalRepotViewModels model)
{
try
{
using (var context = new IOASDBEntities())
{
List <ProposalRepotViewModels> datelistproposal = new List <ProposalRepotViewModels>();
if (model.keysearch != null)
{
var query = (from PR in context.tblProposal
from PI in context.tblUser
from PD in context.tblPIDepartmentMaster
where (PR.InwardDate >= model.FromDate && PR.InwardDate <= model.ToDate && PI.UserId == PR.PI && PR.Department == PD.DepartmentId &&
PR.ProjectType == model.ProjecttypeId) &&
(PI.FirstName.Contains(model.keysearch) || PR.ProposalTitle.Contains(model.keysearch) || PD.Department.Contains(model.keysearch) || PR.ProposalNumber.Contains(model.keysearch))
select new { PR.ProposalNumber, PI.FirstName, PR.ProposalTitle, PD.Department, PR.InwardDate, PR.Crtd_TS, PR.DurationOfProjectYears, PR.DurationOfProjectMonths }).ToList();
if (query.Count > 0)
{
for (int i = 0; i < query.Count; i++)
{
datelistproposal.Add(new ProposalRepotViewModels()
{
Proposalnumber = query[i].ProposalNumber,
PI = query[i].FirstName,
ProposalTitle = query[i].ProposalTitle,
Department = query[i].Department,
InwardDate = (DateTime)query[i].InwardDate,
Crtd_TS = (DateTime)query[i].Crtd_TS,
Durationofprojectyears = (Int32)query[i].DurationOfProjectYears,
Durationofprojectmonths = (Int32)query[i].DurationOfProjectMonths
});
}
}
return(datelistproposal);
}
else
{
var query = (from PR in context.tblProposal
from PI in context.tblUser
from PD in context.tblPIDepartmentMaster
where (PR.InwardDate >= model.FromDate && PR.InwardDate <= model.ToDate && PI.UserId == PR.PI && PR.Department == PD.DepartmentId &&
PR.ProjectType == model.ProjecttypeId)
select new { PR.ProposalNumber, PI.FirstName, PR.ProposalTitle, PD.Department, PR.InwardDate, PR.Crtd_TS, PR.DurationOfProjectYears, PR.DurationOfProjectMonths }).ToList();
if (query.Count > 0)
{
for (int i = 0; i < query.Count; i++)
{
datelistproposal.Add(new ProposalRepotViewModels()
{
Proposalnumber = query[i].ProposalNumber,
PI = query[i].FirstName,
ProposalTitle = query[i].ProposalTitle,
Department = query[i].Department,
InwardDate = (DateTime)query[i].InwardDate,
Crtd_TS = (DateTime)query[i].Crtd_TS,
Durationofprojectyears = (Int32)query[i].DurationOfProjectYears,
Durationofprojectmonths = (Int32)query[i].DurationOfProjectMonths
});
}
}
return(datelistproposal);
}
}
}
catch (Exception ex)
{
List <ProposalRepotViewModels> datelistproposal = new List <ProposalRepotViewModels>();
return(datelistproposal);
}
}
public static int AddApproverDetails(ProcessFlowApproverList model)
{
try
{
using (var context = new IOASDBEntities())
{
int rowsAffected = 0, pglWorkflowId = 0;
if (model.ProcessguidlineworkflowId == 0)
{
tblProcessGuidelineWorkFlow objIU = new tblProcessGuidelineWorkFlow();
objIU.ProcessGuidelineId = model.processguidlineId;
objIU.ProcessGuidelineDetailId = model.ProcessGuidelineDetailId;
objIU.StatusId = model.StatusId;
objIU.ApproverId = model.UserId;
objIU.ApproverLevel = model.ApproverLevel;
objIU.Approve_f = model.ApproveFlag;
objIU.Reject_f = model.RejectFlag;
objIU.Clarify_f = model.ClarifyFlag;
objIU.Mark_f = model.MarkFlag;
context.tblProcessGuidelineWorkFlow.Add(objIU);
rowsAffected = context.SaveChanges();
pglWorkflowId = objIU.ProcessGuidelineWorkFlowId;
}
else
{
tblProcessGuidelineWorkFlow objupdate = new tblProcessGuidelineWorkFlow();
objupdate = context.tblProcessGuidelineWorkFlow.Where(M => M.ProcessGuidelineWorkFlowId == model.ProcessguidlineworkflowId).FirstOrDefault();
if (objupdate != null)
{
objupdate.ProcessGuidelineId = model.processguidlineId;
objupdate.ProcessGuidelineDetailId = model.ProcessGuidelineDetailId;
objupdate.StatusId = model.StatusId;
objupdate.ApproverId = model.UserId;
objupdate.ApproverLevel = model.ApproverLevel;
objupdate.Approve_f = model.ApproveFlag;
objupdate.Reject_f = model.RejectFlag;
objupdate.Clarify_f = model.ClarifyFlag;
objupdate.Mark_f = model.MarkFlag;
rowsAffected = context.SaveChanges();
pglWorkflowId = objupdate.ProcessGuidelineWorkFlowId;
}
}
//Document insertion
if ((model.ProcessguidlineworkflowId == 0 && rowsAffected > 0) || model.ProcessguidlineworkflowId > 0)
{
//Remove existing document
tblProcessGuidelineDocument objDocDelete;
objDocDelete = context.tblProcessGuidelineDocument.Where(s => s.WorkflowId == pglWorkflowId).FirstOrDefault();
if (objDocDelete != null)
{
context.Entry(objDocDelete).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
}
//Insert new document
tblProcessGuidelineDocument objDoc = new tblProcessGuidelineDocument();
objDoc.DocumentId = model.DocumentId;
objDoc.WorkflowId = pglWorkflowId;
context.tblProcessGuidelineDocument.Add(objDoc);
context.SaveChanges();
}
return(pglWorkflowId);
}
}
catch (Exception ex)
{
return(-1);
}
}
public static ControlDataList LoadControls()
{
ControlDataList objcbl = new ControlDataList();
using (var context = new IOASDBEntities())
{
var queryfunction = (from F in context.tblFunction
orderby F.FunctionName
select F).ToList();
if (queryfunction.Count > 0)
{
objcbl.FunctionList = new List <Function>();
for (int i = 0; i < queryfunction.Count; i++)
{
objcbl.FunctionList.Add(new Function()
{
FunctionId = (Int32)queryfunction[i].FunctionId,
FunctionName = Convert.ToString(queryfunction[i].FunctionName)
});
}
}
var queryApprover = (from U in context.tblUser
orderby U.UserName
select U).ToList();
if (queryApprover.Count > 0)
{
objcbl.ApproverList = new List <Approver>();
for (int i = 0; i < queryApprover.Count; i++)
{
objcbl.ApproverList.Add(new Approver()
{
ApproverId = (Int32)queryApprover[i].UserId,
ApproverName = Convert.ToString(queryApprover[i].UserName)
});
}
}
var queryStatus = (from F in context.tblFunctionStatus
orderby F.Status
select F).ToList();
if (queryStatus.Count > 0)
{
objcbl.StatusList = new List <ProcessFlowStatus>();
for (int i = 0; i < queryStatus.Count; i++)
{
objcbl.StatusList.Add(new ProcessFlowStatus()
{
StatusId = (Int32)queryStatus[i].FunctionStatusId,
StatusName = Convert.ToString(queryStatus[i].Status)
});
}
}
var queryDocument = (from D in context.tblDocument
orderby D.DocumentName
select D).ToList();
if (queryDocument.Count > 0)
{
objcbl.DocumentList = new List <Document>();
for (int i = 0; i < queryDocument.Count; i++)
{
objcbl.DocumentList.Add(new Document()
{
DocumentId = (Int32)queryDocument[i].DocumentId,
DocumentName = Convert.ToString(queryDocument[i].DocumentName)
});
}
}
}
return(objcbl);
}
/// <summary>
public static int UserRegistration(RegisterModel model)
{
try
{
using (var context = new IOASDBEntities())
{
using (var transaction = context.Database.BeginTransaction())
{
tblUserRole objuserrole = new tblUserRole();
if (model.UserId == 0)
{
try
{
tblUser reg = new tblUser();
var chkuser = context.tblUser.FirstOrDefault(dup => dup.UserName == model.Username && dup.Status == "Active");
if (chkuser != null)
{
return(2);
}
reg.FirstName = model.Firstname;
reg.LastName = model.Lastname;
reg.RoleId = model.RoleId;
reg.UserName = model.Username;
reg.Password = Cryptography.Encrypt(model.Password, "LFPassW0rd");
reg.Dateofbirth = model.Dateofbirth;
reg.DepartmentId = model.Department;
reg.Gender = model.Gender;
reg.CRTDDateTS = DateTime.Now;
reg.UPDTDateTS = DateTime.Now;
string Username = model.Createuser;
reg.CreatedUserId = Common.GetUserid(Username);
reg.Email = model.Username;
reg.Status = "Active";
reg.UserImage = model.Image;
context.tblUser.Add(reg);
context.SaveChanges();
if (model.SelectedRoles != null)
{
var userid = (from U in context.tblUser
where (U.UserName == model.Username)
select U.UserId).FirstOrDefault();
model.UserId = userid;
for (int i = 0; i < model.SelectedRoles.Length; i++)
{
objuserrole.UserId = model.UserId;
objuserrole.RoleId = model.SelectedRoles[i];
objuserrole.Delegated_f = false;
context.tblUserRole.Add(objuserrole);
context.SaveChanges();
}
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
return(-1);
}
return(1);
}
else
{
var objupdateuser = context.tblUser.Where(U => U.UserId == model.UserId).FirstOrDefault();
if (objupdateuser != null)
{
try
{
objupdateuser.UserId = model.UserId;
objupdateuser.FirstName = model.Firstname;
objupdateuser.LastName = model.Lastname;
objupdateuser.RoleId = model.RoleId;
//bjupdateuser.UserName = model.Username;
//reg.Password = Cryptography.Encrypt(model.Password, "LFPassW0rd");
objupdateuser.Dateofbirth = model.Dateofbirth;
objupdateuser.DepartmentId = model.Department;
objupdateuser.Gender = model.Gender;
objupdateuser.UPDTDateTS = DateTime.Now;
string Username = model.Createuser;
objupdateuser.LastUpdateUserId = Common.GetUserid(Username);
//objupdateuser.Email = model.Username;
if (model.Image != null)
{
objupdateuser.UserImage = model.Image;
}
context.SaveChanges();
var username = (from U in context.tblUser
where (U.UserId == model.UserId)
select U.UserName).FirstOrDefault();
model.Username = username;
var query = (from R in context.tblUserRole
where (R.UserId == model.UserId)
select R).ToList();
if (query.Count > 0)
{
context.tblUserRole.RemoveRange(query);
context.SaveChanges();
}
if (model.SelectedRoles != null)
{
for (int i = 0; i < model.SelectedRoles.Length; i++)
{
objuserrole.UserId = model.UserId;
objuserrole.RoleId = model.SelectedRoles[i];
objuserrole.Delegated_f = false;
context.tblUserRole.Add(objuserrole);
context.SaveChanges();
}
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
return(-1);
}
}
return(3);
}
}
}
}
catch (Exception ex)
{
return(-1);
}
}
