public ActionResult getAll(AD_Projects SearchProject, int pageIndex, int pageSize) { AD_ProjectsBL p = new AD_ProjectsBL(); string StartDate = string.Empty; string EndDate = string.Empty; string ProjectIds = SearchProject.ProjectIds != null?string.Join(",", SearchProject.ProjectIds) : null; string CompanyIds = SearchProject.CompanyIds != null?string.Join(",", SearchProject.CompanyIds) : null; string VendorIds = SearchProject.VendorIds != null?string.Join(",", SearchProject.VendorIds) : null; string StatusId = SearchProject.StatusIds != null?string.Join(",", SearchProject.StatusIds) : null; if (SearchProject.StartDate != null) { StartDate = Convert.ToDateTime(SearchProject.StartDate).ToString(); } if (SearchProject.EndDate != null) { EndDate = Convert.ToDateTime(SearchProject.EndDate).ToString(); } //return Json(p.ToList("SearchAll", // SearchProject.ProjectId != null ? string.Join(",", SearchProject.ProjectId) : null, // SearchProject.CompanyId != null ? string.Join(",", SearchProject.CompanyId) : null, // SearchProject.VendorId != null ? string.Join(",", SearchProject.VendorId) : null, // SearchProject.StatusId != null ? string.Join(",", SearchProject.StatusId) : null, // FromDate, EndDate), return(Json(p.ToList("All", ProjectIds, CompanyIds, VendorIds, StatusId, StartDate, EndDate, pageIndex, pageSize), JsonRequestBehavior.AllowGet)); }
public ActionResult New2(AD_Projects project, List <string> Ids) { if (Ids != null) { project.ProjectScopeID = string.Join(",", Ids); } else { project.ProjectScopeID = "0"; } try { AD_ProjectsBL pBL = new AD_ProjectsBL(); Int64 ProjectID = 0; if (project.ProjectID > 0) { ProjectID = pBL.Manage("Update", project); } else { ProjectID = pBL.Manage("Insert", project); } return(Json(new { Success = true, Message = "Saved" })); } catch (Exception ex) { TempData["msg_error"] = ex.Message; return(View()); } }
//public bool Insert(DataTable project) //{ // SqlCommand loCommand = DataContext.OpenConnection(); // try // { // loCommand = DataContext.SetStoredProcedure(loCommand, "AD_ManageClientAddressXXXXXXXX"); // loCommand = DataContext.StartTransaction(loCommand); // bool result = DataContext.ExecuteNonQuery(DataContext.AddParameters(loCommand, "@List", project)); // DataContext.EndTransaction(loCommand); // return result; // } // catch(Exception) // { // // DataContext.CancelTransaction(loCommand); // throw; // } // finally // { // DataContext.CloseConnection(loCommand); // } //} public void Add_project(AD_Projects p) { //SqlCommand com = new SqlCommand("Sp_AddProject", con); SqlCommand com = DataContext.OpenConnection(); com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@ProjectID", p.ProjectID); com.Parameters.AddWithValue("@ProjectName", p.ProjectName); com.Parameters.AddWithValue("@ProjectScopeID", p.ProjectScopeID); com.Parameters.AddWithValue("@CompanyID", p.CompanyID); com.Parameters.AddWithValue("@VendorID", p.VendorID); com.Parameters.AddWithValue("@StartDate", p.StartDate); com.Parameters.AddWithValue("@EndDate", p.EndDate); com.Parameters.AddWithValue("@StatusID", p.StatusID); com.Parameters.AddWithValue("@Color", p.Color); com.Parameters.AddWithValue("@Description", p.Description); com.Parameters.AddWithValue("@IsActive", p.IsActive); com.Parameters.AddWithValue("@TypeId", p.TypeId); //con.Open(); com.ExecuteNonQuery(); // con.Close(); }
public ActionResult Delete(int Id) { try { AD_Projects p = new AD_Projects(); AD_ProjectsBL rbl = new AD_ProjectsBL(); p.ProjectID = Id; rbl.Manage("Delete", p); } catch (Exception ex) { TempData["msg_error"] = ex.Message; } return(RedirectToAction("All")); }
public bool UpdateActiveStatus(int Id, bool status) { try { AD_Projects p = new AD_Projects(); AD_ProjectsBL rbl = new AD_ProjectsBL(); p.ProjectID = Id; p.IsActive = status; rbl.Manage("UpdateStatus", p); return(true); } catch { return(false); } }
public List <AD_Projects> ListCompany(string filter, string value = null) { AD_ProjectsDL dl = new AD_ProjectsDL(); DataTable dt = dl.Get(filter, value); List <AD_Projects> lst = new List <AD_Projects>(); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { AD_Projects c = new AD_Projects(); c.CompanyID = int.Parse(dt.Rows[i]["ClientId"].ToString()); c.Company = dt.Rows[i]["ClientName"].ToString(); lst.Add(c); } } return(lst); }
public List <AD_Projects> ListProject(string filter, string value = null) { AD_ProjectsDL dl = new AD_ProjectsDL(); DataTable dt = dl.GetProjects(filter, value); List <AD_Projects> lst = new List <AD_Projects>(); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { AD_Projects p = new AD_Projects(); p.ProjectID = int.Parse(dt.Rows[i]["ProjectID"].ToString()); p.ProjectName = dt.Rows[i]["ProjectName"].ToString(); lst.Add(p); } } return(lst); }
public List <AD_Projects> ListStatus(string filter, string value = null) { AD_ProjectsDL dl = new AD_ProjectsDL(); DataTable dt = dl.GetScopeOrStatus(filter, value); List <AD_Projects> lst = new List <AD_Projects>(); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { AD_Projects p = new AD_Projects(); p.StatusID = int.Parse(dt.Rows[i]["DefinationId"].ToString()); p.Status = dt.Rows[i]["DefinationName"].ToString(); lst.Add(p); } } return(lst); }
public AD_Projects Single(string filter, string value = null) { try { DataTable dt = pDL.GetProjects(filter, value); AD_Projects projects = new AD_Projects(); if (dt != null && dt.Rows.Count > 0) { int i = 0; projects.ProjectID = int.Parse(dt.Rows[i]["ProjectID"].ToString()); projects.ProjectName = dt.Rows[i]["ProjectName"].ToString(); projects.ProjectScopeID = dt.Rows[i]["ProjectScopeID"].ToString(); projects.CompanyID = int.Parse(dt.Rows[i]["CompanyID"].ToString()); projects.Company = dt.Rows[i]["Company"].ToString(); projects.VendorID = int.Parse(dt.Rows[i]["VendorID"].ToString()); projects.Vendor = dt.Rows[i]["Vendor"].ToString(); projects.StartDate = Convert.ToDateTime(dt.Rows[i]["StartDate"].ToString()); if (!String.IsNullOrEmpty((dt.Rows[i]["EndDate"].ToString()))) { projects.EndDate = Convert.ToDateTime(dt.Rows[i]["EndDate"].ToString()); } //projects.EndDate = Convert.ToDateTime(String.IsNullOrEmpty(dt.Rows[i]["EndDate"].ToString()) ? "NULL" : dt.Rows[i]["EndDate"].ToString()); projects.StatusID = int.Parse(dt.Rows[i]["StatusID"].ToString()); projects.Status = dt.Rows[i]["Status"].ToString(); projects.Color = dt.Rows[i]["Color"].ToString(); projects.Description = dt.Rows[i]["Description"].ToString(); projects.IsActive = bool.Parse(dt.Rows[i]["IsActive"].ToString()); return(projects); } return(null); } catch (Exception) { return(null); } }
//public List<SelectedList> SelectedList(string filter, string value = null, string Message = null) //{ // SelectedList sl = new SelectedList(); // var rec = ToListMarket(filter, value).Select(m => new SelectedList { Text = m.DefinationName, Value = m.DefinationId.ToString() }).ToList(); // if (!string.IsNullOrEmpty(Message)) // { // sl.Text = Message; // sl.Value = "0"; // rec.Add(sl); // rec = rec.OrderBy(m => m.Value).ToList(); // } // return rec; //} //public List<AD_Projects> ToListMarket(string filter, string value = null) //{ // AD_ProjectsDL dl = new AD_ProjectsDL(); // DataTable dt = dl.GetCitiesMarkeet(filter, value); // List<AD_Projects> lst = dt.ToList<AD_Projects>(); // return lst; //} public List <AD_Projects> ListCitiesMarket(string filter, string value = null) { AD_ProjectsDL dl = new AD_ProjectsDL(); DataTable dt = dl.GetCitiesMarket(filter, value); List <AD_Projects> lst = new List <AD_Projects>(); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { AD_Projects p = new AD_Projects(); p.TypeValue = Convert.ToInt32(dt.Rows[i]["DefinationId"].ToString()); p.DefinationName = dt.Rows[i]["DefinationName"].ToString(); p.TypeId = int.Parse(dt.Rows[i]["DefinationTypeId"].ToString()); lst.Add(p); } } return(lst); }
public int Manage(string filter, AD_Projects p) { return(pDL.Manage(filter, p.ProjectID, p.ProjectName, p.ProjectScopeID, p.CompanyID, p.VendorID, p.StartDate, p.EndDate, p.StatusID, p.Color, p.Description, p.IsActive)); }