public DataSet Select_User_Password(Admin_User user)
{
dbAccess db = new dbAccess();
db.AddParameter("@UserName", user._username);
db.AddParameter("@Password", user.Password);
return db.ExecuteDataSet("sp_CheckLogin");
}
public DataTable GetUploadReports(Report_Details objReports)
{
dbAccess db = new dbAccess();
db.AddParameter("@FromDate", objReports.FromDate);
db.AddParameter("@ToDate", objReports.ToDate);
db.AddParameter("@Name", objReports.FileName);
ds = db.ExecuteDataSet("sp_getuploadhistory");
dt = ds.Tables[0];
return dt;
}
public DataTable GetFileReports( Report_Details objReports)
{
dbAccess db = new dbAccess();
db.AddParameter("@FromDate", objReports.FromDate);
db.AddParameter("@ToDate", objReports.ToDate);
db.AddParameter("@Key", objReports.FileName);
ds = db.ExecuteDataSet("sp_FileDetailsReport");
dt = ds.Tables[0];
return dt;
}
public DataSet Load_User_Password_By_Id(ChangePasswordClient client)
{
dbAccess db = new dbAccess();
db.AddParameter("@Username", client.User_Name);
db.AddParameter("@Password", client.Current_Password);
return db.ExecuteDataSet("SP_checklogin");
}
public DataSet Get_Files_Search(string key)
{
dbAccess db = new dbAccess();
db.AddParameter("@key", key);
return db.ExecuteDataSet("SP_GETFILEDETAILSSEARCH");
}
public DataSet Get_Files_List()
{
dbAccess db = new dbAccess();
return db.ExecuteDataSet("SP_GETFILEDETAILS");
}
public DataSet Bind_Price_Details()
{
dbAccess db = new dbAccess();
return db.ExecuteDataSet("Sp_select_Genereal ");
}
public DataTable GetUserReports(Report_Details objReports)
{
dbAccess db = new dbAccess();
db.AddParameter("@FromDate", objReports.FromDate);
db.AddParameter("@ToDate", objReports.ToDate);
ds = db.ExecuteDataSet("sp_getuserdetails");
dt = ds.Tables[0];
return dt;
}