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