public JsonResult ToList(string filter, string value)
{
ClientsBL ub = new ClientsBL();
var rec = ub.ToList(filter, value);
return(Json(rec, JsonRequestBehavior.AllowGet));
}
public ActionResult Clients(int CountryId)
{
List <SelectListItem> items = new List <SelectListItem>();
ClientsBL cb = new ClientsBL();
var lst = cb.ToList("ByCountryId", CountryId.ToString());
// items.Add(new SelectListItem { Text = "Select Client", Value = "0" });
foreach (var item in lst)
{
items.Add(new SelectListItem {
Text = item.ClientName, Value = item.ClientId.ToString()
});
}
return(Json(new SelectList(items, "Value", "Text"), JsonRequestBehavior.AllowGet));;
}
public ActionResult New()
{
ClientsBL ub = new ClientsBL();
var List = ub.ToList("Company");
SWI.AirView.Common.SelectedList sl = new SWI.AirView.Common.SelectedList();
ViewBag.SelectedClientTypes = sl.Definations("byDefinationType", "Profile Type");
ViewBag.SelectedPClient = sl.Clients("AllVendors");
if (List.Count > 0)
{
return(RedirectToAction("Edit", new { @Id = List[0].ClientId }));
}
else
{
return(View());
}
}
public List <SelectListItem> Clients(string filter)
{
List <SelectListItem> items = new List <SelectListItem>();
ClientsBL cb = new ClientsBL();
var lst = cb.ToList(filter);
items.Add(new SelectListItem {
Text = "Select Client", Value = "0"
});
foreach (var item in lst)
{
items.Add(new SelectListItem {
Text = item.ClientName, Value = item.ClientId.ToString()
});
}
return(items);
}
public ActionResult New(AD_Clients cl, List <AD_ClientContacts> con, List <AD_ClientAddress> add)
{
decimal Id = 0;
Response res = new Response();
string fname = string.Empty;
try
{
ClientsBL rb = new ClientsBL();
var List = rb.ToList("Company");
if (List.Count > 0)
{
res.Status = "danger";
res.Message = "Company Already Exist !";
return(Json(res, JsonRequestBehavior.AllowGet));
}
string Extension = "";
if (Request.Files.Count > 0)
{
HttpFileCollectionBase files = Request.Files;
for (int i = 0; i < files.Count; i++)
{
HttpPostedFileBase file = files[i];
// Checking for Internet Explorer
if (Request.Browser.Browser.ToUpper() == "IE" || Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER")
{
string[] testfiles = file.FileName.Split(new char[] { '\\' });
fname = testfiles[testfiles.Length - 1];
}
else
{
fname = cl.ClientPrefix;
}
fname = Path.Combine(Server.MapPath("~/Content/Images/ClientLogo"), fname + "_logo" + Path.GetExtension(file.FileName));
file.SaveAs(fname);
Extension = Path.GetExtension(file.FileName);
}
}
cl.Logo = "/Content/Images/ClientLogo/" + cl.ClientPrefix + "_logo" + Extension;
Id = rb.Manage("Insert", cl);
dbDataTable ddt = new dbDataTable();
DataTable dtcon = ddt.List();
DataTable dt = ddt.List();
foreach (var item in add)
{
myDataTable.AddRow(dt, "Value1", item.Address, "Value2", item.Street, "Value3", item.CityId, "Value4", item.StateId, "Value5", item.CountryId,
"Value6", item.ZipCode, "Value7", item.IsHeadOffice, "Value8", Id, "Value9", item.IsActive);
}
AD_ClientAddressDL claddress = new AD_ClientAddressDL();
claddress.Manage("Insert", dt);
res.Status = "success";
res.Value = Id;
res.Message = "Save successfully";
res.Value = Id.ToString();
}
catch (Exception ex)
{
res.Status = "danger";
res.Message = ex.Message;
}
if (res.Status == "success")
{
return(Json(res, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(res, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Edit(string Id = "")
{
ClientsBL cb = new ClientsBL();
UserClientsBL uchb = new UserClientsBL();
UserCityBL ucb = new UserCityBL();
AD_DefinationBL db = new AD_DefinationBL();
Sec_User user = new Sec_User();
Sec_UserBL ubl = new Sec_UserBL();
Sec_UserSettingsDL udl = new Sec_UserSettingsDL();
Sec_PermissionBL pl = new Sec_PermissionBL();
Sec_UserDefinationTypeBL udt = new Sec_UserDefinationTypeBL();
ViewBag.Titles = new List <SelectListItem> {
new SelectListItem {
Text = "Mr.", Value = "1"
},
new SelectListItem {
Text = "Mrs.", Value = "2"
},
new SelectListItem {
Text = "Miss.", Value = "3"
},
new SelectListItem {
Text = "Ms.", Value = "4"
},
new SelectListItem {
Text = "Sir.", Value = "5"
},
new SelectListItem {
Text = "DR", Value = "6"
}
};
ViewBag.Hide = false;
ViewBag.Team = false;
if (Id == Convert.ToString(ViewBag.UserId))
{
ViewBag.Hide = true;
List <OrgChart> rec = ubl.hierarchy("ByCompanyId", Convert.ToString(ViewBag.CompId));
List <Chart> Data2 = FlatToHierarchy(rec, ViewBag.UserId);
if (Data2.Count > 0)
{
ViewBag.Team = true;
}
else
{
ViewBag.Team = false;
}
}
SWI.AirView.Common.SelectedList sl = new SWI.AirView.Common.SelectedList();
Sec_UserBL ud = new Sec_UserBL();
Sec_User User = ud.Single("ById", Id.ToString());
ViewBag.UserTitle = User.Title;
ViewBag.Hide2 = true;
if (User.ReportToId.ToString() == Convert.ToString(ViewBag.UserId))
{
ViewBag.Hide2 = false;
}
if (Id == Convert.ToString(ViewBag.UserId))
{
ViewBag.Hide2 = false;
}
ViewBag.User = User;
if (User == null)
{
}
if (User.IsAdmin == true)
{
ViewBag.Hide = false;
ViewBag.Hide2 = false;
ViewBag.Team = true;
}
NewData();
ViewBag.Id = User.CompanyId;
ViewBag.RoleId = User.RoleId;
ViewBag.Reports = sl.User("All");
ViewBag.ReportTo = ud.ToList("All");
ViewBag.Clients2 = sl.Clients("AllRecords");
/////permissions
user = ubl.Single("ById", Id.ToString());
///Project
DataTable Table = udl.GetDataTable("All_Projects", User.ReportToId.ToString(), null, null);
ViewBag.Projects = Table.ToList <PM_Projects>();
DataTable Table1 = udl.GetDataTable("UserProjects", Id.ToString(), null, null);
ViewBag.UserProjects = Table1.ToList <PM_Projects>();
var r = pl.ToList("byUserId", Id.ToString());
var d = udt.ToList("GetByUserId", Id.ToString());
string UDSelected = null;
foreach (var item in d)
{
UDSelected += item.DefinationTypeId + ",";
}
ViewBag.DIds = UDSelected;
string Selected = null;
foreach (var item in r)
{
Selected += item.Id + ",";
}
ViewBag.PIds = Selected;
ViewBag.UId = Id;
#region user Permissions on tab
//Clients
//ViewBag.Clients = cb.ToList("byStatus", User.ReportToId.ToString());
ViewBag.Clients = cb.ToList("byStatus", "True", User.ReportToId.ToString());
ViewBag.UserClients = uchb.ToList("byUserId", Id.ToString());
//Cities
ViewBag.Cities = db.ToList("AllCities");
//db.ToList("UserCities",User.ReportToId.ToString());
ViewBag.UserCities = ucb.ToList("byUserId", Id.ToString());
ViewBag.Region = db.RegionsToList(User.ReportToId.ToString());
//scope
ViewBag.Scopes = db.ToList("Scopes", User.ReportToId.ToString());
//ViewBag.Scopes = db.ToList("Scopes");
ViewBag.UserScopes = db.ToList("UserScopes", Id.ToString());
ViewBag.Permissions = pl.ToList("byRoleId", user.RoleId.ToString(), User.ReportToId.ToString());
#endregion
AD_DefinationTypesBL dtd = new AD_DefinationTypesBL();
ViewBag.DefinationTypes = dtd.ToList("All", User.ReportToId.ToString());
//User.RoleName = ViewBag.RoleName;
return(View("edit", User));
}
public ActionResult New(Workorder wo, List <Workorder> wolst, List <AV_TSSCheckList> tss, long SiteTypeIds = 0, long SiteClassIds = 0, long ProjectIds = 0, string Clonetype = "")
{
Response res = new Response();
try
{
if (Clonetype == "Clone")
{
wo.SiteTypeId = SiteTypeIds.ToString();
wo.SiteClassId = SiteClassIds;
wo.ProjectId = ProjectIds;
}
if (wo.SiteId != 0)
{
wo.SiteTypeId = SiteTypeIds.ToString();
wo.SiteClassId = SiteClassIds;
wo.ProjectId = ProjectIds;
}
ClientsBL ub = new ClientsBL();
var ClientPrefix = ub.ToList("AllRecords").Where(x => x.ClientId == Convert.ToDecimal(wo.Client)).FirstOrDefault().ClientPrefix;
wolst[0].ClientPrefix = ClientPrefix;
Common.SelectedList sl = new Common.SelectedList();
var obj = sl.Definations("UserScopes", Convert.ToString(ViewBag.UserId));// sl.Scopes();
TempData["clusters"] = wolst;
TempData["SiteCluster"] = wo.siteCode + "," + wo.clusterCode + "," + ClientPrefix;
foreach (var df in obj)
{
if (wo.Scope == df.Value && df.Text == "TSS" || wo.Scope == df.Value && df.Text == "CLS")
{
foreach (var item in wolst)
{
item.VerticalBeamWidth = "0";
item.RFHeight = 0;
item.MTilt = 0;
item.ETilt = 0;
item.BandWidth = "0";
item.SectorLatitude = 0;
item.SectorLongitude = 0;
item.CellId = "0";
item.MRBTS = "0";
}
}
}
WorkOrderBL wb = new WorkOrderBL();
if (wolst.Count > 0 && wolst[0].clusterId != null)
{
var fname = wo.siteCode + "," + wo.clusterCode;
if (wo.SiteId == 0)
{
wb.Insert("NewWorkOrder", wo, wolst, ViewBag.UserId, null, fname);
}
else
{
wb.ChangeFolderName(wo, wolst);
wb.Insert("Edit_Work_Order", wo, wolst, ViewBag.UserId, null, fname);
}
}
else
{
if (wo.SiteId == 0)
{
wb.Insert("NewWorkOrder", wo, wolst, ViewBag.UserId, null);
}
else
{
wb.ChangeFolderName(wo, wolst);
wb.Insert("Edit_Work_Order", wo, wolst, ViewBag.UserId, null);
}
}
res.Status = "success";
res.Message = "save successfully";
}
catch (Exception ex)
{
res.Status = "danger";
res.Message = ex.Message;
}
return(Json(new { response = res }, JsonRequestBehavior.AllowGet));
}
public ActionResult All()
{
return(View(BL.ToList("AllRecords")));
}
public ActionResult ByUser(int id = 0)
{
Sec_User user = new Sec_User();
Sec_UserBL ubl = new Sec_UserBL();
user = ubl.Single("ById", id.ToString());
if (user != null)
{
Sec_UserSettingsDL udl = new Sec_UserSettingsDL();
Sec_PermissionBL pl = new Sec_PermissionBL();
Sec_UserDefinationTypeBL ud = new Sec_UserDefinationTypeBL();
///Projects and User projects
DataTable Table = udl.GetDataTable("All_Projects", null, null, null);
ViewBag.Projects = Table.ToList <PM_Projects>();
DataTable Table1 = udl.GetDataTable("UserProjects", id.ToString(), null, null);
ViewBag.UserProjects = Table1.ToList <PM_Projects>();
var r = pl.ToList("byUserId", id.ToString());
var d = ud.ToList("GetByUserId", id.ToString());
string UDSelected = null;
foreach (var item in d)
{
UDSelected += item.DefinationTypeId + ",";
}
ViewBag.DIds = UDSelected;
string Selected = null;
foreach (var item in r)
{
Selected += item.Id + ",";
}
ViewBag.PIds = Selected;
ViewBag.UId = id;
// User Clients
ClientsBL cb = new ClientsBL();
ViewBag.Clients = cb.ToList("byStatus", "True");
// get selected user Clients
UserClientsBL uchb = new UserClientsBL();
ViewBag.UserClients = uchb.ToList("byUserId", id.ToString());
// get selected user Cities
UserCityBL ucb = new UserCityBL();
ViewBag.UserCities = ucb.ToList("byUserId", id.ToString());
// get Regions
AD_DefinationBL db = new AD_DefinationBL();
ViewBag.Region = db.RegionsToList();
ViewBag.Cities = db.ToList("AllCities");
ViewBag.Scopes = db.ToList("Scopes");
ViewBag.UserScopes = db.ToList("UserScopes", id.ToString());
// ViewBag.UserScopes = string.Join(",", Scopes.Select(n => n.DefinationId.ToString()).ToArray());
var Permissions = pl.ToList("byRoleId", user.RoleId.ToString());
return(View(Permissions));
}
else
{
TempData["msg_error"] = "User not Found.";
}
return(View());
}
