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 int Get_UserCount()
{
dbAccess db = new dbAccess();
return db.ExecuteStoredProcedure("sp_GetUserCount");
}
public int Get_File_DownloadCount()
{
dbAccess db = new dbAccess();
return db.ExecuteStoredProcedure("sp_GetDownloadCount");
}
protected void Page_Load(object sender, EventArgs e)
{
dbAccess obj = new dbAccess();
SqlCommand com;
string connstr = obj.ConnectionString.ToString();
//SqlConnection con = new SqlConnection(connstr);
//SqlCommand uploadCount = new SqlCommand("select count(File_Id) from UploadHistory",con);
// string str = "select count(File_Id) from UploadHistory;
// SqlDataReader reader = com.ExecuteReader();
// reader.Read();
/// lblUpload.Text = reader["Name"].ToString();
// reader.Read();
SqlConnection con = new SqlConnection(connstr);
con.Open();
string str = "select count(File_Id) from UploadHistory";
com = new SqlCommand(str, con);
SqlDataReader reader = com.ExecuteReader();
reader.Read();
lblUpload.Text = reader[0].ToString();
}
public int Change_Password(ChangePasswordClient client)
{
dbAccess db = new dbAccess();
db.AddParameter("@UserId", client.User_Name);
db.AddParameter("@Password", client.New_Password);
return db.ExecuteNonQuery("SP_TBL_CLIENT_LOGIN_UPDATE_PASSWORD");
}
public DataTable GetUploadReports()
{
dbAccess db = new dbAccess();
ds = db.ExecuteDataSet("sp_getuploadhistory");
dt = ds.Tables[0];
return dt;
}
public int Downlaod_File(FileUpload objlog)
{
dbAccess db = new dbAccess();
db.AddParameter("@UserId", objlog.UserId);
db.AddParameter("@FileId", objlog.FileId);
return db.ExecuteNonQuery("SP_DOWNLOADFILE");
}
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 int Insert_Details(Admin_Home Home)
{
dbAccess db = new dbAccess();
db.AddParameter("@Id", Home.Id);
db.AddParameter("@22kt", Home.strContents);
return db.ExecuteNonQuery("SP_INSERT_DETAILS");
}
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;
}
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 int INSERT_File_DETAILS( FileUpload objlog)
{
dbAccess db = new dbAccess();
db.AddParameter("@UserId", objlog.UserId);
db.AddParameter("@FileName", objlog.FileName);
db.AddParameter("@FileSize", objlog.FileSize);
db.AddParameter("@ContentType", objlog.FileType);
db.AddParameter("@FileExtension", objlog.Extension);
db.AddParameter("@FilePath", objlog.FilePath);
return db.ExecuteNonQuery("SP_INSERTFILEDETAILS");
}
public DataSet Get_Files_List()
{
dbAccess db = new dbAccess();
return db.ExecuteDataSet("SP_GETFILEDETAILS");
}
public int Load_Client_Username_Count_By_Text(string Username)
{
dbAccess db = new dbAccess();
db.AddParameter("@Username", Username);
return Convert.ToInt32(db.ExecuteScalar("SP_TBL_CLIENT_LOGIN_LOAD_USERNAME_COUNT_BY_TEXT"));
}
public string Load_Password_By_Id(ChangePasswordClient client)
{
dbAccess db = new dbAccess();
db.AddParameter("@UserId", client.User_Name);
return db.ExecuteScalar("SP_TBL_CLIENT_LOGIN_LOAD_PASSWORD_BY_ID").ToString();
}
public DataSet Get_Files_Search(string key)
{
dbAccess db = new dbAccess();
db.AddParameter("@key", key);
return db.ExecuteDataSet("SP_GETFILEDETAILSSEARCH");
}
public string Load_Client_Current_Email_By_Id(ChangePasswordClient client)
{
dbAccess db = new dbAccess();
db.AddParameter("@Client_Id", client.User_Name);
return db.ExecuteScalar("SP_TBL_CLIENT_LOGIN_LOAD_CURRENT_EMAIL_BY_ID").ToString();
}
public string Load_Client_Current_Username_By_Id(ChangePasswordClient client)
{
dbAccess db = new dbAccess();
db.AddParameter("@Usernmae", client.User_Name);
return db.ExecuteScalar("SP_TBL_CLIENT_LOGIN_LOAD_CURRENT_USERNAME_BY_ID").ToString();
}
public string Load_User_Current_Username_By_Id(ChangePasswordClient client)
{
dbAccess db = new dbAccess();
db.AddParameter("@Usernmae", client.User_Name);
return db.ExecuteScalar("SP_UsernamebyId").ToString();
}
//public int insert_client(Client profile)
//{
// dbAccess db = new dbAccess();
// db.AddParameter("@First_Name", profile.First_Name);
// db.AddParameter("@Last_Name", profile.Last_Name);
// db.AddParameter("@User_Name", profile.User_Name);
// db.AddParameter("@Password", profile.Password);
// db.AddParameter("@Email", profile.Email);
// db.AddParameter("@Gender", profile.Privilage);
// db.AddParameter("@Client_Name", profile.Client_Name);
// db.AddParameter("@Description", profile.Description);
// db.AddParameter("@Address1", profile.Address1);
// db.AddParameter("@Address2", profile.Address2);
// db.AddParameter("@City", profile.City);
// db.AddParameter("@State", profile.State);
// db.AddParameter("@Country", profile.Country);
// db.AddParameter("@Region", profile.Region);
// db.AddParameter("@Pincode", profile.Pincode);
// db.AddParameter("@Phone", profile.Phone);
// db.AddParameter("@Mobile", profile.Mobile);
// db.AddParameter("@Info_Email", profile.Info_Email);
// db.AddParameter("@Website", profile.Website);
// db.AddParameter("@SeqQues", profile.SeqQues);
// db.AddParameter("@SeqAns", profile.SeqAns);
// db.AddParameter("@NewsLetter", profile.NewsLetter);
// db.AddParameter("@Offers", profile.Offers);
// return db.ExecuteNonQuery("SP_TBL_CLIENT_PROFILE_INSERT_V2");
//}
public int Load_User_Email_Count_By_Text(string Email)
{
dbAccess db = new dbAccess();
db.AddParameter("@Email", Email);
return Convert.ToInt32(db.ExecuteScalar("SP_TBL_LOGIN_V2_LOAD_EMAIL_COUNT_BY_TEXT"));
}
public int Insert_Client_Login_Details(Client profile)
{
dbAccess db = new dbAccess();
db.AddParameter("@FirstName", profile.First_Name);
db.AddParameter("@LastName", profile.Last_Name);
db.AddParameter("@UserName", profile.User_Name);
db.AddParameter("@Password", profile.Password);
db.AddParameter("@Email", profile.Email);
db.AddParameter("@Usergroupid", profile.Privilage);
return db.ExecuteNonQuery("SP_CreateNewUser");
}
public int Load_User_Username_Count_By_Text(string Username)
{
dbAccess db = new dbAccess();
db.AddParameter("@Username", Username);
return Convert.ToInt32(db.ExecuteScalar("sp_checkuser"));
}
public int Change_User_Password(ChangePasswordClient client)
{
dbAccess db = new dbAccess();
db.AddParameter("@Username", client.User_Name);
db.AddParameter("@newPassword", client.New_Password);
return db.ExecuteNonQuery("SP_updatepassword");
}
public int update_client(Client profile)
{
dbAccess db = new dbAccess();
db.AddParameter("@First_Name", profile.First_Name);
db.AddParameter("@Last_Name", profile.Last_Name);
db.AddParameter("@User_Name", profile.User_Name);
db.AddParameter("@Email", profile.Email);
db.AddParameter("@Gender", profile.Privilage);
db.AddParameter("@Client_Name", profile.Client_Name);
db.AddParameter("@Description", profile.Description);
db.AddParameter("@Address1", profile.Address1);
db.AddParameter("@Address2", profile.Address2);
db.AddParameter("@City", profile.City);
db.AddParameter("@State", profile.State);
db.AddParameter("@Country", profile.Country);
db.AddParameter("@Region", profile.Region);
db.AddParameter("@Pincode", profile.Pincode);
db.AddParameter("@Phone", profile.Phone);
db.AddParameter("@Mobile", profile.Mobile);
db.AddParameter("@Info_Email", profile.Info_Email);
db.AddParameter("@Website", profile.Website);
db.AddParameter("@Login_Id", profile.Login_Id);
return db.ExecuteNonQuery("SP_TBL_CLIENT_PROFILE_UPDATE_V2");
}
public DataSet Bind_Price_Details()
{
dbAccess db = new dbAccess();
return db.ExecuteDataSet("Sp_select_Genereal ");
}
