public List <Enquiry> getAllEnquiryData() { List <Enquiry> enquiryList = new List <Enquiry>(); // creating list of model. DataTable dt = new DataTable(); using (DBClass context = new DBClass()) { dt = context.getData("getAllEnquiry", CommandType.StoredProcedure); foreach (DataRow dr in dt.Rows) { enquiryList.Add(new Enquiry { EnquiryID = Convert.ToString(dr["ID"]), UserName = Convert.ToString(dr["UserName"]), Enq_Category = Convert.ToString(dr["EnquiryCategory"]), Enq_Subject = Convert.ToString(dr["EnquirySubject"]), EnquiryDetail1 = Convert.ToString(dr["EnquiryDetail"]), Enq_CreateDate = Convert.ToString(dr["CreateDate"]), Buyer_Count = Convert.ToInt32(dr["Buyer_Count"]), Country = Convert.ToString(dr["Country"]), City = Convert.ToString(dr["City"]), State = Convert.ToString(dr["State"]), }); } return(enquiryList); } }
public static List <Enquiry> getAllEnquiry(string UserRole) { List <Enquiry> enquiryList = new List <Enquiry>(); // creating list of model. string username = HttpContext.Current.Session["UserName"].ToString(); DataTable dt = new DataTable(); using (DBClass context = new DBClass()) { if (UserRole == "Client") { context.AddParameter("@UserName", username); dt = context.getData("getEnquiryByUser", CommandType.StoredProcedure); } else { dt = context.getData("getAllEnquiry", CommandType.StoredProcedure); } foreach (DataRow dr in dt.Rows) { string EnquiryStatus = "NO"; context.AddParameter("@EnquiryID", Convert.ToString(dr["ID"])); context.AddParameter("@UserName", username); DataSet dtStatus = context.ExecuteDataSet("getEnquiryStatus", CommandType.StoredProcedure); if (dtStatus.Tables[0].Rows.Count > 0) { EnquiryStatus = "YES"; } enquiryList.Add(new Enquiry { EnquiryID = Convert.ToString(dr["ID"]), UserName = Convert.ToString(dr["UserName"]), Enq_Category = Convert.ToString(dr["EnquiryCategory"]), Enq_Subject = Convert.ToString(dr["EnquirySubject"]), EnquiryDetail1 = Convert.ToString(dr["EnquiryDetail"]), Enq_CreateDate = Convert.ToString(dr["CreateDate"]), Buyer_Count = Convert.ToInt32(dr["Buyer_Count"]), Country = Convert.ToString(dr["Country"]), City = Convert.ToString(dr["City"]), State = Convert.ToString(dr["State"]), eStatus = EnquiryStatus }); } return(enquiryList); } }
public static List <ClientsRecord> GetClients() { List <ClientsRecord> clientList = new List <ClientsRecord>(); // creating list of model. DataSet ds = new DataSet(); char[] delimiterChars = { '@' }; //string[] RolesForCurrentUser = Roles.GetAllRoles(); //string[] user = Roles.GetUsersInRole(RolesForCurrentUser[0]); // string userName = Roles.GetRolesForUser(); //string username = HttpContext.Current.User.Identity.Name; string username = ""; if (HttpContext.Current.Session["UserName"] != null) { username = HttpContext.Current.Session["UserName"].ToString(); } else { username = ""; } using (DBClass context = new DBClass()) { context.AddParameter("@username", username); ds = context.ExecuteDataSet("getUserRole", CommandType.StoredProcedure); } using (DBClass context = new DBClass()) { context.AddParameter("@UserRole", ds.Tables[0].Rows[0]["UserRole"].ToString()); context.AddParameter("@UserName", username); DataTable dt = context.getData("getFileWithStatus", CommandType.StoredProcedure); // loop for adding add from dataset to list<modeldata> foreach (DataRow dr in dt.Rows) { //string[] fName = Convert.ToString(dr["FilePath"]).Split(delimiterChars); clientList.Add(new ClientsRecord { Serial = Convert.ToInt32(dr["ID"]), UserRole = ds.Tables[0].Rows[0]["UserRole"].ToString(), Company = Convert.ToString(dr["uCompanyName"]), Phone = Convert.ToString(dr["uMobile_No"]), EmailID = Convert.ToString(dr["Email_ID"]), FileName = Convert.ToString(dr["FileName"]), PaymentStatus = Convert.ToBoolean(dr["Status"]), ReportStatus = Convert.ToBoolean(dr["UploadStatus"]), AnalysisCost = Convert.ToDouble(dr["Amount"]), ReportingDate = Convert.ToDateTime(dr["ReportingTime"]) }); } return(clientList); } }
//////////////////////////Cost Table Data/////////////////////////// //public string AnalysisType { get; set; } //public IEnumerable CostList { get; set; } public List <UploadFile> GetList(int id) { List <UploadFile> allList = new List <UploadFile>(); using (DBClass context = new DBClass()) { DataTable dt = context.getData("select * from UploadData where ID = '" + id + "'", CommandType.Text); string mac = Convert.ToString(dt.Rows[0]["Machine"]); string[] macname = mac.Split(','); string rpm = Convert.ToString(dt.Rows[0]["RPM"]); string[] rpm10 = rpm.Split(','); string mac1 = Convert.ToString(dt.Rows[0]["Coupling1"]); string[] mac11 = mac1.Split(','); string rpm1 = Convert.ToString(dt.Rows[0]["RPMWINGS1"]); string[] rpm11 = rpm1.Split(','); string mac2 = Convert.ToString(dt.Rows[0]["Coupling2"]); string[] macname22 = mac2.Split(','); string rpm2 = Convert.ToString(dt.Rows[0]["RPMWINGS2"]); string[] rpm22 = rpm2.Split(','); string mac3 = Convert.ToString(dt.Rows[0]["Coupling3"]); string[] macname33 = mac3.Split(','); string rpm3 = Convert.ToString(dt.Rows[0]["RPMWINGS3"]); string[] rpm33 = rpm3.Split(','); string pointcount = Convert.ToString(dt.Rows[0]["PointCount"]); string[] point = pointcount.Split(','); for (int i = 0; i < macname.Length; i++) { allList.Add(new UploadFile { machine = Convert.ToString(macname[i]), // rpm = Convert.ToString(rpm10[i]), coupling1 = Convert.ToString(mac11[i]), rpm1 = Convert.ToString(rpm11[i]), coupling2 = Convert.ToString(macname22[i]), rpm2 = Convert.ToString(rpm22[i]), coupling3 = Convert.ToString(macname33[i]), rpm3 = Convert.ToString(rpm33[i]), TotalPoint = Convert.ToInt32(point[i]) }); } return(allList); } }
public List <CurrentOpenings> GetAllOpenings() { List <CurrentOpenings> OpeningList = new List <CurrentOpenings>(); using (DBClass context = new DBClass()) { DataTable dt = context.getData("GetAllOpening", CommandType.StoredProcedure); foreach (DataRow dr in dt.Rows) { OpeningList.Add(new CurrentOpenings { JobID = Convert.ToInt32(dr["JobID"]), JobTitle = Convert.ToString(dr["JobTitle"]), JobCategory = Convert.ToString(dr["JobCategory"]), JobDescription = Convert.ToString(dr["Description"]), ExperienceRequired = Convert.ToString(dr["ExperienceRequired"]) }); } return(OpeningList); } }
public static List <ClientsRecord> AllUserList() { List <ClientsRecord> UserList = new List <ClientsRecord>(); using (DBClass context = new DBClass()) { DataTable dt = context.getData("getAllUserList", CommandType.StoredProcedure); foreach (DataRow dr in dt.Rows) { UserList.Add(new ClientsRecord { UserName = Convert.ToString(dr["UserName"]), Name = dr["Name"].ToString(), //Company = Convert.ToString(dr["Company"]), Phone = Convert.ToString(dr["Phone"]), EmailID = Convert.ToString(dr["Email_ID"]), CreatedDate = Convert.ToDateTime(dr["CreationDate"]), UserRole = Convert.ToString(dr["UserRole"]), }); } return(UserList); } }