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