//public string getConnectionString(int serverID) //{ // //Get the connection string for the selected database // var context = new App_Data.AcuPayEntities(); // var query1 = (from a in context.tbl_Servers // where a.ServerID == serverID // select new // { // a.ConnectionString // }).ToString(); // return query1; //} public List <string> getLocationID(int serverID, string loggedInUser) { //Get the locations the user is assigned to var context = new App_Data.AcuPayEntities(); var query1 = (from a in context.tbl_Users_Servers join b in context.tbl_Estate on a.EstatesID equals b.EstateID join c in context.tbl_Users on a.UserID equals c.UserID where a.ServerID == serverID && c.UserName == loggedInUser select new { b.Guy_EstateCode }).ToList(); List <string> results = new List <string>(); if (query1.Count > 0) { foreach (var item in query1) { string val = item.ToString(); val = val.Remove(0, 19); val = val.TrimEnd('}'); results.Add(val.TrimEnd(' ')); } } else { results.Add("NoLocation"); } return(results); }
private void loadGridviewData() { List <string> estates = new List <string>(); if (EstateID.Count > 0) { foreach (string li in EstateID) { estates.Add(li); } } //estates = estates.TrimEnd(','); //Select from Entity Data Model to Bind gridview with all records not uploaded. var context = new App_Data.AcuPayEntities(); var query1 = (from a in context.tbl_1_Export_PieceWork where a.Uploaded.Contains("N") && estates.Contains(a.EstateiD) orderby a.WorkDate descending select new { a.RecordId, a.FirstName, a.LastName, a.Emp_Seq_No, a.est_emp_no, a.WorkDate, a.Quantity, a.TentativeRate, a.TotalEarnings, a.DayWorked, a.ActivityMaster, a.ActivityCode, a.ExpenseCode, a.Holding_ac_Code, a.LocationID, a.ChargedTo, a.EstateLocationId, a.EstateiD, a.TemporaryGang, a.TemporaryGangOption, a.Recoverable, a.Unit }).ToList(); gvTime.DataSource = query1; gvTime.DataBind(); if (gvTime.Rows.Count == 0) { toggleEndableDisable(false); lblTime.Text = "No data available for upload."; } else if (gvTime.Rows.Count > 0) { toggleEndableDisable(true); lblTime.Text = "Records available for upload: " + query1.Count; } }
private void loadGridviewData() { List <string> estates = new List <string>(); if (EstateID.Count > 0) { foreach (string li in EstateID) { estates.Add(li); } } //estates = estates.TrimEnd(','); //Select from Entity Data Model to Bind gridview with all records not uploaded. var context = new App_Data.AcuPayEntities(); var query1 = (from a in context.tbl_3_Export_OtherEarnings where a.Uploaded.Contains("N") && estates.Contains(a.Estate_ID) orderby a.Work_date descending select new { a.RecordId, a.FirstName, a.LastName, a.Emp_seq_no, a.est_emp_no, a.Work_date, a.INCOME_ID, a.Amount, a.EarningRate, a.Total_other_earnings, a.Earnings_table_name, a.Link_id, a.Estate_location_id, a.Estate_ID }).ToList(); gvTime.DataSource = query1; gvTime.DataBind(); if (gvTime.Rows.Count == 0) { toggleEndableDisable(false); lblTime.Text = "No data available for upload."; } else if (gvTime.Rows.Count > 0) { toggleEndableDisable(true); lblTime.Text = "Records available for upload: " + query1.Count; } }
private void loadGridviewData() { List <string> estates = new List <string>(); if (EstateID.Count > 0) { foreach (string li in EstateID) { estates.Add(li); } } //estates = estates.TrimEnd(','); //Select from Entity Data Model to Bind gridview with all records not uploaded. var context = new App_Data.AcuPayEntities(); var query1 = (from a in context.tbl_6_Export_NotRequired where a.Uploaded.Contains("N") orderby a.WorkDate descending //&& estates.Contains(a.EstateId) select new { a.RecordId, a.FirstName, a.LastName, a.emp_seq_no, a.est_emp_no, a.WorkDate, a.NRStatus, a.EstateId, a.EstateLocationId, }).ToList(); gvTime.DataSource = query1; gvTime.DataBind(); if (gvTime.Rows.Count == 0) { toggleEndableDisable(false); lblTime.Text = "No data available for upload."; } else if (gvTime.Rows.Count > 0) { toggleEndableDisable(true); lblTime.Text = "Records available for upload: " + query1.Count; } }
public bool IsAdmin(string loggedInUser) { //Check if the loggedinuser is an Admin var context = new App_Data.AcuPayEntities(); var query1 = (from a in context.tbl_Users where a.UserName == loggedInUser select new { a.Admin }).ToList(); string result = ""; bool adminStatus = new bool(); if (query1.Count > 0) { foreach (var item in query1) { string val = item.ToString(); val = val.Remove(0, 10); val = val.TrimEnd('}'); result = val.TrimEnd(' '); } } if (result != "") { if (result == "True") { adminStatus = true; } else { adminStatus = false; } } else { adminStatus = false; } return(adminStatus); }
//Updated uploaded record for Time Details to show it was uploaded public void setUploadStatus_TimeDetails(int recordID, string updatedBy) { var contex = new App_Data.AcuPayEntities(); try { var recordToUpdate = (from a in contex.tbl_2_Export_TimeDetails where a.RecordId == recordID select a).First(); recordToUpdate.Uploaded = "Y"; recordToUpdate.UploadedBy = updatedBy; recordToUpdate.UploadedOn = DateTime.Now; contex.SaveChanges(); successfulCommit = true; } catch (System.Exception excec) { successfulCommit = false; writetoAlertLog(excec.ToString().ToUpper()); } }
private void loadGridviewData() { List <string> estates = new List <string>(); if (EstateID.Count > 0) { foreach (string li in EstateID) { estates.Add(li); } } //estates = estates.TrimEnd(','); //Select from Entity Data Model to Bind gridview with all records not uploaded. var context = new App_Data.AcuPayEntities(); var query1 = (from a in context.tbl_2_Export_TimeDetails where a.Uploaded.Contains("N") && estates.Contains(a.EstateID) orderby a.WorkDate descending select new { a.RecordId, a.FirstName, a.LastName, a.Emp_seq_no, a.est_emp_no, a.WorkDate, a.ShiftId, a.FromTime, a.ToTime, a.OverNight, a.HasSplit, a.SS_FromTime, a.SS_ToTime, a.Rate, a.ActivityMaster, a.ActivityCode, a.Holding_Acc_Code, a.LocationId, a.ChargedTo, a.EstateLocationID, a.EstateID, a.TypeOfEntry, a.TemporaryGang, a.TemporaryGangOption, a.Vehicle, a.Recoverable, a.Quantity }).ToList(); gvTime.DataSource = query1; gvTime.DataBind(); if (gvTime.Rows.Count == 0) { toggleEndableDisable(false); lblTime.Text = "No data available for upload."; } else if (gvTime.Rows.Count > 0) { toggleEndableDisable(true); lblTime.Text = "Records available for upload: " + query1.Count; } }