public ActionResult MenuRoleAction(int id)
{
ViewBag.Title = "Role Action";
int menuID = id;
int company_id = SessionUtil.GetCompanyID();
IList <ControllerAction> list = new List <ControllerAction>();
var listController = STUtil.GetListController(); //Nedd to check data in respwct of
ViewBag.action_name = new List <SelectListItem>();
ViewBag.menu_id = menuID;
foreach (var c in listController)
{
string controllerName = c.Value;
var listAllAction = STUtil.GetListAllActionByController(controllerName);
var listAssignedAction = (from r in db.menu_access_controller_action
where r.menu_id == menuID && r.controller_name == controllerName
orderby r.action_name
select new SelectListItem
{
Value = r.action_name,
Text = r.action_name,
}).ToList();
foreach (var aa in listAllAction)
{
ControllerAction ca = new ControllerAction();
ca.ControllerName = controllerName;
ca.ActionName = aa.Text;
ca.IsAssigned = listAssignedAction.Where(a => a.Text == aa.Text).Count() > 0 ? true : false;
list.Add(ca);
}
}
return(PartialView("_MenuRoleAction", list));
}
public ActionResult UserIndex(string id)
{
int company_id = SessionUtil.GetCompanyID();
var roleList = db.roles.Where(x => x.is_public && x.is_active && x.company_id == company_id).ToList();
return(View(roleList));
}
public ActionResult LoadJobDetail(int id)
{
job obj = new job();
if (id > 0)
{
obj = db.jobs.Find(id);
}
user u = new user();
var JobAssData = db.job_assignment.AsEnumerable().Where(x => x.job_id == obj.job_id).ToList();
int company_id = SessionUtil.GetCompanyID();
u.company_id = company_id;
ViewBag.payment_term_id = new SelectList(db.payment_term.AsEnumerable().Where(x => x.is_active), "payment_term_id", "payment_term_name");
ViewBag.job_type_id = new SelectList(jobUtil.GetJobType(), "Value", "Text", obj != null ? obj.job_type_id : 0);
ViewBag.job_status_id = new SelectList(jobUtil.GetJobStatus(), "Value", "Text", obj != null ? obj.job_status_id : 0);
ViewBag.client_id = new SelectList(jobUtil.GetClient(), "Value", "Text", obj != null ? obj.client_id : 0);
ViewBag.paper_type_id = new SelectList(jobUtil.GetPaperType(), "Value", "Text", obj != null ? obj.paper_type_id : 0);
ViewBag.paper_sub_type_id = new SelectList(jobUtil.GetPaperSubType(), "Value", "Text", obj != null ? obj.paper_sub_type_id : 0);
ViewBag.lemination_type_id = new SelectList(jobUtil.GetLeminationType(), "Value", "Text", obj != null ? obj.lemination_type_id : 0);
ViewBag.paper_size_id = new SelectList(jobUtil.GetPaperSizeList(), "Value", "Text", obj != null ? obj.paper_size_id : 0);
ViewBag.printing_side_id = new SelectList(jobUtil.GetPrintingSideList(), "Value", "Text", obj != null ? obj.printing_side_id : 0);
ViewBag.orientation_id = new SelectList(jobUtil.GetOrientationList(), "Value", "Text", obj != null ? obj.orientation_id : 0);
ViewBag.user_id = new SelectList(jobUtil.GetAssignedUsers(), "Value", "Text", JobAssData.Count() > 0 ? JobAssData.FirstOrDefault().user_id : 0);
var tupleModel = new Tuple <job, user>(obj, u);
return(PartialView("_JobDetail", tupleModel));
}
public user IsEmailExist(string emailID, int userId)
{
var list = db.users.AsEnumerable().Where(x => x.company_id == SessionUtil.GetCompanyID()).ToList();
return(userId > 0 ?
list.AsEnumerable().Where(x => x.email_id.ToUpper() == emailID.ToUpper() && x.user_id != userId && x.company_id == SessionUtil.GetCompanyID()).FirstOrDefault()
: list.AsEnumerable().Where(x => x.email_id.ToUpper() == emailID.ToUpper() && x.company_id == SessionUtil.GetCompanyID()).FirstOrDefault());
}
public ActionResult getPassword(string id)
{
int user_id = Convert.ToInt32(id);
int company_id = SessionUtil.GetCompanyID();
string password = db.USP_GetUserPassword(user_id, company_id).ToList().FirstOrDefault().password;
return(Json(password));
}
public USER IsEmailExist(string emailID, int userId)
{
var list = db.USERs.AsEnumerable().Where(x => x.CompanyId == SessionUtil.GetCompanyID()).ToList();
return(userId > 0 ?
list.AsEnumerable().Where(x => x.EmailId.ToUpper() == emailID.ToUpper() && x.UserId != userId && x.CompanyId == SessionUtil.GetCompanyID()).FirstOrDefault()
: list.AsEnumerable().Where(x => x.EmailId.ToUpper() == emailID.ToUpper() && x.CompanyId == SessionUtil.GetCompanyID()).FirstOrDefault());
}
public CompanySettingController()
{
CompanyId = SessionUtil.GetCompanyID();
result = new Result();
companyUtil = new CompanyUtil();
stateUtil = new StateUtil();
countryUtil = new CountryUtil();
packageUtil = new PackageUtil();
}
public ActionResult Index(string id = "")
{
user user = new user();
int company_id = SessionUtil.GetCompanyID();
ViewBag.role_bit = new SelectList(RoleUtil.GetParentRoleBitByCompany(company_id), "Value", "Text");
user.company_id = company_id;
return(View(user));
}
public IList <SelectListItem> ParentUserList(int roleBit)
{
return((from c in db.USERs.AsEnumerable()
where c.CompanyId == SessionUtil.GetCompanyID() && c.RoleBit == roleBit
select new SelectListItem
{
Value = c.UserId.ToString(),
Text = c.FirstName,
}).OrderBy(x => x.Text).ToList());
}
// GET: /CompanySetting/
public ActionResult EditCompany(string id = "")
{
STUtil.SetSessionValue(UserInfo.pageTitle.ToString(), "Company Setting");
int company_id = (Int32)SessionUtil.GetCompanyID();
company company = db.companies.Find(company_id);
ViewBag.Title = "Company Edit";
ViewBag.id = company != null ? company.company_id : 0;
return(View());
}
public IList <SelectListItem> ParentUserList(int roleBit)
{
return((from c in db.users.AsEnumerable()
where c.company_id == SessionUtil.GetCompanyID() && c.role_bit == roleBit
select new SelectListItem
{
Value = c.user_id.ToString(),
Text = c.user_name
}).OrderBy(x => x.Text).ToList());
}
public ActionResult Index()
{
user user = new user();
int company_id = SessionUtil.GetCompanyID();
user.company_id = company_id;
ViewBag.payment_term_id = new SelectList(db.payment_term.AsEnumerable().Where(x => x.is_active), "payment_term_id", "payment_term_name");
return(View(user));
}
public IList<SelectListItem> GetJobStatus()
{
var CompanyId = SessionUtil.GetCompanyID();
var list = (from li in db.job_status.AsEnumerable()
where li.company_id == CompanyId && li.is_active
select new SelectListItem
{
Text = li.job_status_name,
Value = li.job_status_id.ToString()
}).ToList();
return list;
}
public IList<SelectListItem> GetLeminationType()
{
var CompanyId = SessionUtil.GetCompanyID();
var list = (from li in db.lemination_type.AsEnumerable()
where li.company_id == CompanyId && li.is_active
select new SelectListItem
{
Text = li.lemination_type_name,
Value = li.lemination_type_id.ToString()
}).ToList();
return list;
}
public List<SelectListItem> GetOrientationList()
{
int companyId = (Int32)SessionUtil.GetCompanyID();
var list = (from c in db.orientations.AsEnumerable()
where c.company_id == companyId && c.is_active
select new SelectListItem
{
Text = c.orientation_name,
Value = c.orientation_id.ToString(),
}).ToList();
return list;
}
public IList<SelectListItem> GetAssignedUsers()
{
var CompanyId = SessionUtil.GetCompanyID();
var list = (from li in db.users.AsEnumerable()
where li.role_bit == Convert.ToInt32(Role.Manager) || li.role_bit == Convert.ToInt32(Role.Operator) && li.company_id == CompanyId && li.is_active
select new SelectListItem
{
Text = li.user_name,
Value = li.user_id.ToString()
}).ToList();
return list;
}
public List <SelectListItem> GetPaymentTermList()
{
int companyId = (Int32)SessionUtil.GetCompanyID();
var list = (from c in db.payment_term.AsEnumerable()
where c.company_id == companyId && c.is_active
select new SelectListItem
{
Text = c.payment_term_name,
Value = c.payment_term_id.ToString(),
}).ToList();
return(list);
}
public List <SelectListItem> GetEmailOwnerList()
{
int companyId = (Int32)SessionUtil.GetCompanyID();
var list = (from c in db.users.AsEnumerable()
where c.company_id == companyId
select new SelectListItem
{
Text = c.user_name + "(" + c.email_id + ")",
Value = c.email_id.ToString(),
}).ToList();
return(list);
}
public Result PostCompanyCreateEdit(COMPANY company, string userName, string loginID, string emailID, string mobile, string gender, string password, HttpPostedFileBase company_logo)
{
try
{
int userID = SessionUtil.GetUserID();
if (company.CompanyId > 0)
{
var tempCompanyId = SessionUtil.GetCompanyID();
COMPANY data = new COMPANY();
data = db.COMPANies.Find(company.CompanyId);
data.CompanyName = company.CompanyName;
data.ContactNumber = company.ContactNumber;
data.CityId = company.CityId;
data.GSTN = company.GSTN;
data.CTSNumber = company.CTSNumber;
data.CompanyAddress = company.CompanyAddress;
data.ContactPerson = company.ContactPerson;
data.EmailId = company.EmailId;
data.PAN = company.PAN;
data.LogoImage = company_logo != null ? company.LogoImage : data.LogoImage;
data.IsActive = company.IsActive;
int sessionComId = (Int32)SessionUtil.GetCompanyID();
db.Entry(data).State = System.Data.Entity.EntityState.Modified;
BaseUtil.SetSessionValue(UserInfo.CompanyID.ToString(), company.CompanyId.ToString());
db.SaveChanges();
BaseUtil.SetSessionValue(UserInfo.CompanyID.ToString(), sessionComId.ToString());
result.Message = string.Format(BaseConst.MSG_SUCCESS_UPDATE, "Company");
result.Id = company.CompanyId;
}
else
{
db.COMPANies.Add(company);
db.SaveChanges();
result.Message = string.Format(BaseConst.MSG_SUCCESS_CREATE, "Company");
result.MessageType = MessageType.Success;
result.Id = company.CompanyId;
}
}
catch (Exception ex)
{
result.MessageType = MessageType.Error;
result.Message = ex.Message;
}
return(result);
}
public ActionResult CompanyHolidayList(string id)
{
var list = db.company_holiday.AsEnumerable().Where(x => x.company_id == SessionUtil.GetCompanyID()).ToList();
var data = (from li in list
select new
{
company_holiday_id = li.company_holiday_id,
holiday_name = li.holiday_name,
holiday_date = DateTime.ParseExact(li.holiday_date.ToShortDateString(), "dd/mm/yyyy", null).ToString("mm/dd/yyyy"),
is_active = li.is_active,
}).ToList();
return(Json(data));
}
public ActionResult JobAssignUsersList(int id)
{
var Company_id = SessionUtil.GetCompanyID();
var list = (from li in db.job_assignment.AsEnumerable()
where li.job_id == id && li.company_id == Company_id && li.is_active
select new
{
user_name = li.user.user_name,
is_active = li.is_active,
job_assignment_id = li.job_assignment_id,
}).ToList();
return(Json(list));
}
public ActionResult GetMenuCategory(string id)
{
string[] treeobj = { "parent", "Text" };
var snag_type_sla = db.MENU_CATEGORY.AsEnumerable().Where(x => x.CompanyId == SessionUtil.GetCompanyID()).ToList();
var list = (
from sla in snag_type_sla
where sla.CompanyId == SessionUtil.GetCompanyID()
select new
{
id = sla.MenuCategoryId,
parent = (sla.PerentMenuCategoryId != null ? Convert.ToString(sla.PerentMenuCategoryId) : "#"),
text = sla != null ? sla.MenuCategoryName + "-" + sla.SequenceOrder:"",
selected = false
}).Distinct().ToList();
List <object> Arraylist = treeobj.ToList <object>();
return(Json(list));
}
public ActionResult ClientList()
{
var CompanyId = SessionUtil.GetCompanyID();
var data = (from list in db.users.AsEnumerable()
where list.role_bit == (Int32)Role.Client && list.company_id == CompanyId
select new
{
user_id = list.user_id,
user_name = list.user_name,
email_id = list.email_id,
gstin = list.gstin_numer,
mobile = list.mobile,
gender = list.gender,
is_active = list.is_active,
}).ToList();
return(Json(data));
}
public ActionResult UsersList(string id)
{
int CompanyId = SessionUtil.GetCompanyID();
//int rolebit = Convert.ToInt32(id);
IList <user> list = db.users.AsEnumerable().Where(x => x.company_id == CompanyId && x.role_bit != 8 && x.role_bit > 2).ToList();
var data = (from li in list
select new
{
user_id = li.user_id,
user_name = li.user_name,
email_id = li.email_id,
mobile = li.mobile,
gender = li.gender,
RoleName = li.role.role_name,
is_active = li.is_active,
}).ToList();
return(Json(data));
}
public ActionResult UsersList(string id)
{
int rolebit = Convert.ToInt32(db.ROLEs.Find(Convert.ToInt32(id)).RoleBit);
IList <USER> list = db.USERs.AsEnumerable().Where(x => x.CompanyId == SessionUtil.GetCompanyID() && x.RoleBit == rolebit).ToList();
var data = (from li in list
select new
{
user_id = li.UserId,
user_name = li.FirstName,
email_id = li.EmailId,
mobile = li.Mobile,
gender = li.Gender,
is_active = li.IsActive,
team_count = 0,
unit_count = 0,
}).ToList();
return(Json(data));
}
public ActionResult EmailSettingsList(int id)
{
var list = db.email_setting.AsEnumerable().ToList();
//list = list.Where(x => x.email_setting_type.is_public).ToList();
var data = (from li in list
where li.company_id == SessionUtil.GetCompanyID() && li.user_id == SessionUtil.GetUserID()
select new
{
email_setting_id = li.email_setting_id,
from_email_id = li.from_email_id,
from_email_name = li.from_email_name,
email_user_name = li.email_user_name,
email_setting_type_name = li.email_setting_type.email_setting_type_name,
is_public = li.email_setting_type.is_public,
is_active = li.is_active,
company_id = li.company_id,
created_date = li.created_date,
created_by = li.created_by,
updated_date = li.updated_date,
updated_by = li.updated_by,
}).ToList();
return(Json(data));
}
public ActionResult CompanyList()
{
//// var path = BaseUtil.GetWebConfigValue("SNAG_AWS_S3");
int role = SessionUtil.GetRoleBit();
int companyId = SessionUtil.GetCompanyID();
var list = db.COMPANies.AsEnumerable().ToList();
if (role != Convert.ToInt32(Role.SuperAdmin))
{
list = list.AsEnumerable().Where(x => x.CompanyId == companyId).ToList();
}
var data = (from li in list
select new
{
company_id = li.CompanyId,
CompanyName = li.CompanyName,
EmailId = li.EmailId,
address = li.CompanyAddress,
image = string.IsNullOrEmpty(li.LogoImage) ? "~/Base/Content/images/NA.jpg" : li.LogoImage,
is_active = li.IsActive,
}).ToList();
return(Json(data));
}
public ActionResult JobList(string id)
{
var JobAss = db.job_assignment.AsEnumerable().Where(x => x.company_id == SessionUtil.GetCompanyID()).ToList();
var Company_Id = SessionUtil.GetCompanyID();
var data = (from li in db.jobs.AsEnumerable()
where li.is_active
select new
{
job_id = li.job_id,
job_type_name = li.job_type.job_type_name,
client_name = li.user.user_name,
paper_type_name = li.paper_type.paper_type_name,
paper_sub_type_name = li.paper_sub_type.paper_sub_type_name,
lemination_type_name = li.lemination_type.lemination_type_name,
job_status_name = li.job_status.job_status_name,
quantity = li.quantity,
job_code = li.job_code,
price = li.price,
AssignTo = JobAss.Where(x => x.job_id == li.job_id).Count() > 0 ? JobAss.Where(x => x.job_id == li.job_id).FirstOrDefault().user.user_name : "",
is_active = li.is_active,
}).ToList();
return(Json(data));
}
public ActionResult CreateEdit(string id, string rolid)
{
int role_bit = Convert.ToInt32(db.roles.Find(Convert.ToInt32(rolid)).role_bit);
role parentrole = new role();
role parentrole2 = new role();
List <user> userlist = new List <user>();
int company = Convert.ToInt32(SessionUtil.GetCompanyID());
parentrole = db.roles.SingleOrDefault(x => x.role_bit == role_bit && x.company_id == company);
parentrole2 = db.roles.SingleOrDefault(x => x.role_id == parentrole.parent_id && x.company_id == company);
//userlist = db.users.Where(x => x.role_bit == parentrole2.role_bit && x.company_id == company).ToList();
user u = new user();
u.role_bit = role_bit;
if (parentrole2 != null)
{
var data = (from c in db.users.AsEnumerable()
where c.company_id == company && c.role_bit == parentrole2.role_bit
select new SelectListItem
{
Text = c.user_name,
Value = c.user_id.ToString(),
}).OrderBy(x => x.Text).ToList();
if (id != null && id != "")
{
ViewBag.Title = "User Edit";
u = db.users.Find(Convert.ToInt32(id));
string Pass = db.USP_Decrypt_TEXT(u.password).ToString();
ViewBag.Password = Pass;
ViewBag.parent_user_id = new SelectList(data, "Value", "Text", u.parent_user_id);
}
else
{
ViewBag.parent_user_id = new SelectList(data, "Value", "Text", 0);
}
}
else
{
var data = (from c in db.users.AsEnumerable()
where c.company_id == company
select new SelectListItem
{
Text = c.user_name,
Value = c.user_id.ToString(),
}).OrderBy(x => x.Text).ToList();
if (id != null && id != "")
{
ViewBag.Title = "User Edit";
u = db.users.Find(Convert.ToInt32(id));
string Pass = db.USP_Decrypt_TEXT(u.password).ToString();
ViewBag.Password = Pass;
ViewBag.parent_user_id = new SelectList(data, "Value", "Text", u.parent_user_id);
}
else
{
ViewBag.parent_user_id = new SelectList(data, "Value", "Text", 0);
}
//ViewBag.parent_user_id = (from c in db.users.AsEnumerable()
// where c.company_id == company && c.role_bit == parentrole2.role_bit
// select new SelectListItem
// {
// Value = c.user_id.ToString(),
// Text = c.user_name
// }).OrderBy(x => x.Text).ToList();
}
ViewBag.rol_id = rolid;
//ViewBag.parent_user_id = new SelectList(userlist, "Value", "Text");
int roleBit = 0;
//List<SelectListItem> plist = (from c in db.users.AsEnumerable()
// where c.company_id == company && c.role_bit == parentrole2.role_bit
// select new SelectListItem
// {
// Value = c.user_id.ToString(),
// Text = c.user_name
// }).OrderBy(x => x.Text).ToList();
//ViewBag.parent_user_id = new SelectList(plist, "Value", "Text", u.parent_user_id);
//else
//{
// if (rolid != null && rolid != "")
// {
// u.role_bit = Convert.ToInt32(db.roles.Find(rol_id).role_bit);
// roleBit = u.role_bit;
// }
// ViewBag.Title = "User Create";
//}
//ViewBag.rol_id = rolid;
//ViewBag.IsParentDDL = userUtil.IsParentDDL(rol_id);
//if (userUtil.IsParentDDL(rol_id))
//{
// ViewBag.parent_user_id = new SelectList(userUtil.ParentUserList(roleBit), "Value", "Text", u != null ? u.parent_user_id : 0);
//}
return(View(u));
}
public ActionResult CreateEdit(user user, FormCollection frm, HttpPostedFileBase user_photo)
{
try
{
string rol_id = frm["rol_id"];
if (user_photo != null)
{
string AWSProfileName = BaseUtil.GetWebConfigValue("AWSProfileName");
string GenFileName = BaseUtil.GetTodayDate().ToString("yyyyMMdd") + "_" + SessionUtil.GetCompanyID().ToString() + "_" + Path.GetFileName(user_photo.FileName).Replace(" ", "_");
String companyFolderName = BaseUtil.GetSessionValue(UserInfo.CompanyFolderName.ToString()).ToString().Replace("/", "");
AWSUtil.UploadFile(user_photo.InputStream, AWSProfileName, companyFolderName, GenFileName);
user.user_photo = GenFileName;
}
else
{
user.user_photo = user.gender + ".JPG";
}
result = userUtil.PostCreateEdit(user, frm);
ViewBag.Title = user == null ? "User Create" : "User Edit";
ViewBag.action_name = BaseUtil.GetListAllActionByController("");
switch (result.MessageType)
{
case MessageType.Success:
return(RedirectToAction("Index", "User", new { id = rol_id, Result = result.Message, MessageType = result.MessageType }));
default:
return(RedirectToAction("CreateEdit", "User", new { id = user.user_id, Result = result.Message, MessageType = result.MessageType }));
}
return(View(user));
}
catch (Exception ex)
{
return(View(user));
}
}
