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