public int UpdateAdminPassword(double AdminUserNo, string Password)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@AdminUserNo", AdminUserNo);
param[1] = new SqlParameter("@AdminUserPassword", Password);
return(DALCommon.ExecuteNonQuery("[sp_Admin_UpdateAdminUserPassword]", param));
}
public decimal UpdateMerchantCallBackURL(ModelLandingURL objModelLandingURL)
{
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@MerchantAccountNo", objModelLandingURL.MerchantAccountNo);
param[1] = new SqlParameter("@CallBackSuccessUrl", objModelLandingURL.MerchantSuccessURL);
param[2] = new SqlParameter("@CallBackRejectUrl", objModelLandingURL.MerchantFailURL);
return(DALCommon.ExecuteNonQuery("[sp_Admin_UpdateMerchantResponseURL]", param));
}
public int InsertAdminFormPages(string WebFormTitle, string WebFormURL, bool AppearToMenu, bool IsFormAction)
{
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@AdminWebFormTitle", WebFormTitle);
param[1] = new SqlParameter("@AdminWebFormURL", WebFormURL);
param[2] = new SqlParameter("@WillAppearToMenu", AppearToMenu);
param[3] = new SqlParameter("@IsFormActive", IsFormAction);
return(DALCommon.ExecuteNonQuery("sp_Admin_InsertAdminFormPages", param));
}
//new
public int InsertNewAdminUser(ModelAdminUser objModelAdminUser)
{
SqlParameter[] param = new SqlParameter[8];
param[0] = new SqlParameter("@strAdminUserName", objModelAdminUser.UserName);
param[1] = new SqlParameter("@strAdminUserPassword", objModelAdminUser.UserPassword);
param[2] = new SqlParameter("@strAdminUserFirstName", objModelAdminUser.UserFirstName);
param[3] = new SqlParameter("@strAdminUserLastName", objModelAdminUser.UserLastName);
param[4] = new SqlParameter("@strAdminUserEmail", objModelAdminUser.UserEmail);
param[5] = new SqlParameter("@strAdminUserMobile", objModelAdminUser.UserMobileNumber);
param[6] = new SqlParameter("@intAdminUserStatus", objModelAdminUser.UserAccountStatus);
param[7] = new SqlParameter("@intAdminUserType", objModelAdminUser.UserAccountType);
return(DALCommon.ExecuteNonQuery("[sp_Admin_InsertAdminUser]", param));
}
public int UpdateStudentSinngleFeeInfoByFeeId(ModelStudentFee objModelStudentFee)
{
SqlParameter[] param = new SqlParameter[10];
param[0] = new SqlParameter("@FeeId", objModelStudentFee.FeeId);
param[1] = new SqlParameter("@AdmissionFee", objModelStudentFee.AdmissionFee);
param[2] = new SqlParameter("@Admission", objModelStudentFee.Admission);
param[3] = new SqlParameter("@ReAdmissionFee", objModelStudentFee.ReAdmissionFee);
param[4] = new SqlParameter("@RegistrationFee", objModelStudentFee.RegistrationFee);
param[5] = new SqlParameter("@MonthlyFee", objModelStudentFee.MonthlyFee);
param[6] = new SqlParameter("@ComputerFee", objModelStudentFee.ComputerFee);
param[7] = new SqlParameter("@Fine", objModelStudentFee.Fine);
param[8] = new SqlParameter("@ExamFee", objModelStudentFee.ExamFee);
param[9] = new SqlParameter("@GeneratorFee", objModelStudentFee.GeneratorFee);
return(DALCommon.ExecuteNonQuery("[sp_Admin_UpdateStudentSinngleFeeInfoByFeeId]", param));
}
public bool SaveAdminWebFormPermission(int AdminUserNo, Array ArrayOfPermission)
{
SqlParameter[] param = new SqlParameter[5];
//Now Go For One By One Sector
for (int i = 0; i <= (ArrayOfPermission.Length / 4) - 1; i++)
{
param[0] = new SqlParameter("@AdminUserNo", AdminUserNo);
param[1] = new SqlParameter("@AdminUserWebFormNo", ArrayOfPermission.GetValue(i, 0));
param[2] = new SqlParameter("@HaveAddPermission", ArrayOfPermission.GetValue(i, 1));
param[3] = new SqlParameter("@HaveEditPermission", ArrayOfPermission.GetValue(i, 2));
param[4] = new SqlParameter("@HaveSearchPermission", ArrayOfPermission.GetValue(i, 3));
//Manage Permission
DALCommon.ExecuteNonQuery("sp_Admin_UpdateAdminPermission", param);
}
return(true);
}
