public static string GetProjects(string user_id) { ProjectService.Projecttracker _service = new ProjectService.Projecttracker(); string jsonprojects = _service.GetProjects(user_id); return(jsonprojects); }
public static string getCompanyClients(string companyId) { ProjectService.Projecttracker _service = new ProjectService.Projecttracker(); string jsonprojects = _service.GetCompanyClients(companyId); return(jsonprojects); }
public static string GetProject_Type_Id() { ProjectService.Projecttracker _service = new ProjectService.Projecttracker(); string jsonprojects = _service.GetProject_Type_Id(); return(jsonprojects); }
public static string GetProjectDetail(string Bugid) { ProjectService.Projecttracker _service = new ProjectService.Projecttracker(); string jsonprojects = _service.GetProjectDetail(Bugid); return(jsonprojects); }
public static string GetSearchResult(string user_id, string fname, string lname, string bug_id) { ProjectService.Projecttracker _service = new ProjectService.Projecttracker(); string jsonprojects = _service.GetSearchResult(user_id, fname, lname, bug_id); return(jsonprojects); }
public static string GetBillingDetails() { ProjectService.Projecttracker _service = new ProjectService.Projecttracker(); string jsonprojects = _service.GetBillingDetails(string.Empty); return(jsonprojects); }
public static string GetCompany() { ProjectService.Projecttracker _service = new ProjectService.Projecttracker(); string jsonprojects = _service.GetCompany(string.Empty); return(jsonprojects); }
public static string AddClient(string ClientId, string ClientName, string Charge, string billingId, string companyId) { ProjectService.Projecttracker _service = new ProjectService.Projecttracker(); bool _add = _service.AddClient(ClientId, ClientName, Convert.ToDouble(Charge), billingId, companyId); DataTable dt = new DataTable(); dt.Columns.Add("ADD", typeof(string)); DataRow dr = dt.NewRow(); dr["ADD"] = _add.ToString(); dt.Rows.Add(dr); return(GetJson(dt)); }
public static string AddCompany(string CompanyId, string Desc, string companyno) { ProjectService.Projecttracker _service = new ProjectService.Projecttracker(); bool _add = _service.AddCompany(CompanyId, Desc, companyno); DataTable dt = new DataTable(); dt.Columns.Add("ADD", typeof(string)); DataRow dr = dt.NewRow(); dr["ADD"] = _add.ToString(); dt.Rows.Add(dr); return(GetJson(dt)); }
public static string AddProject(string client_id, string company_id, string Bugid, string Project_type_id, string bugdesc, string start_st, string end_dt, string user_id, string action_taken, string contact_person) { ProjectService.Projecttracker _service = new ProjectService.Projecttracker(); bool _add = _service.AddProject(company_id, client_id, Bugid, Project_type_id, bugdesc, start_st, end_dt, user_id, action_taken, contact_person); DataTable dt = new DataTable(); dt.Columns.Add("ADD", typeof(string)); DataRow dr = dt.NewRow(); dr["ADD"] = _add.ToString(); dt.Rows.Add(dr); return(GetJson(dt)); }
public static string checkUser(string UserId, string password) { ProjectService.Projecttracker _service = new ProjectService.Projecttracker(); bool _check = _service.CheckUser(UserId, password); DataTable dt = new DataTable(); dt.Columns.Add("CHECK", typeof(string)); DataRow dr = dt.NewRow(); dr["CHECK"] = _check.ToString(); dt.Rows.Add(dr); return(GetJson(dt)); }
public static string RegisterUser(string UserId, string password, string fname, string lname, string abb) { ProjectService.Projecttracker _service = new ProjectService.Projecttracker(); bool _signup = _service.RegisterUser(UserId, password, fname, lname, abb); DataTable dt = new DataTable(); dt.Columns.Add("SIGNUP", typeof(string)); DataRow dr = dt.NewRow(); dr["SIGNUP"] = _signup.ToString(); dt.Rows.Add(dr); return(GetJson(dt)); }
public static string EditCompany(string CompanyId, string Desc, string companyno) { ProjectService.Projecttracker _service = new ProjectService.Projecttracker(); bool _check = _service.EditCompany(CompanyId, Desc, companyno); DataTable dt = new DataTable(); dt.Columns.Add("UPDATE", typeof(string)); DataRow dr = dt.NewRow(); dr["UPDATE"] = _check.ToString(); dt.Rows.Add(dr); return(GetJson(dt)); }
public static string EditBillingDetails(string BillingId, string BillTo, string ContactPerson, string Address, string City, string State, string Country, string Zip) { ProjectService.Projecttracker _service = new ProjectService.Projecttracker(); bool _check = _service.EditBillingDetails(BillingId, BillTo, ContactPerson, Address, City, State, Country, Zip); DataTable dt = new DataTable(); dt.Columns.Add("UPDATE", typeof(string)); DataRow dr = dt.NewRow(); dr["UPDATE"] = _check.ToString(); dt.Rows.Add(dr); return(GetJson(dt)); }
protected void ShowReport() { string billto = string.Empty; TextInfo myTI = new CultureInfo("en-US", false).TextInfo; ProjectService.Projecttracker _service = new ProjectService.Projecttracker(); DataTable dtReport = _service.GetReportDS(); dtReport.Columns.Add("HOURS", typeof(Int32)); dtReport.Columns.Add("IMAGE", System.Type.GetType("System.Byte[]")); dtReport.Columns.Add("IMAGEURL", typeof(String)); double mins = Convert.ToDouble(ConfigurationManager.AppSettings["Minutes"]); double weekendHours = Convert.ToDouble(ConfigurationManager.AppSettings["WeekEndHours"]); foreach (DataRow dr in dtReport.Rows) { double hours = 0; TimeSpan ts = Convert.ToDateTime(dr["END_DT"]) - Convert.ToDateTime(dr["START_DT"]); if (ts.Days > 0) { hours = ts.Days * 24; } if (ts.Hours > 0) { hours = hours + ts.Hours; } if (ts.Minutes > 0) { if (ts.Minutes > mins) { hours = hours + 1; } } if (Convert.ToDateTime(dr["START_DT"]).DayOfWeek == DayOfWeek.Saturday || Convert.ToDateTime(dr["START_DT"]).DayOfWeek == DayOfWeek.Sunday) { hours = hours * weekendHours; dr["BUG_DESC"] = dr["BUG_DESC"].ToString() + " (WORK IN WEEKENDS)"; } dr["HOURS"] = hours; billto = myTI.ToTitleCase(dr["BILL_TO"].ToString().ToLower()) + "\n" + myTI.ToTitleCase(dr["CONTACT_PERSON"].ToString().ToLower()) + "\n" + myTI.ToTitleCase(dr["ADDRESS"].ToString().ToLower()) + "\n" + myTI.ToTitleCase(dr["CITY"].ToString().ToLower()) + "," + dr["STATE"].ToString() + "," + dr["COUNTRY"].ToString() + " - " + myTI.ToTitleCase(dr["ZIP"].ToString().ToLower()); } CrystalReportViewer1.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None; _reportDocument = new ReportDocument(); _reportDocument.Load(Server.MapPath("CrystalReport1.rpt")); _reportDocument.SetDataSource(dtReport); TextObject txtcdate = _reportDocument.ReportDefinition.ReportObjects["txtcurrentdate"] as TextObject; txtcdate.Text = DateTime.Today.ToString("MM/dd/yyyy"); TextObject txtinvoice = _reportDocument.ReportDefinition.ReportObjects["txtinvoice"] as TextObject; txtinvoice.Text = "7201329"; TextObject txtbillto = _reportDocument.ReportDefinition.ReportObjects["txtbillto"] as TextObject; txtbillto.Text = billto; TextObject txtduedate = _reportDocument.ReportDefinition.ReportObjects["txtduedate"] as TextObject; txtduedate.Text = DateTime.Today.AddDays(20).Date.ToString("MM/dd/yyyy"); TextObject txtponumber = _reportDocument.ReportDefinition.ReportObjects["txtponumber"] as TextObject; txtponumber.Text = "390022"; CrystalReportViewer1.ReportSource = _reportDocument; }