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));
}
