public DataSet AddUserProfile(UserProfileBo userprofileBo)
{
var transactionStatus = new TransactionStatus();
var userprofile = BuiltUserProfileDomain(userprofileBo);
string sbc = DESEncrypt(userprofile.Pswd);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@opReturnValue", SqlDbType.Int), //0
new SqlParameter("@authority_Id", userprofile.Authority_Id), //0
new SqlParameter("@user_Name", userprofile.User_Name), //3
new SqlParameter("@firstname", userprofile.Firstname), //4
new SqlParameter("@lastname", userprofile.Lastname), //5
new SqlParameter("@pswd", DESEncrypt(userprofile.Pswd)), //6
new SqlParameter("@activated_By", "admin"), //7
new SqlParameter("@department", "LMK"), //8
new SqlParameter("@created_On", System.DateTime.Now), //9
new SqlParameter("@modified_On", System.DateTime.Now), //10
new SqlParameter("@pswd_Reset_On", System.DateTime.Now), //11
new SqlParameter("@UserType", userprofile.UserType), //12
};
Params[0].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddUserProfile", Params);
ds.Locale = CultureInfo.InvariantCulture;
return(ds);
}
public TransactionStatus UpdateUserProfile(UserProfileBo userprofileBo)
{
CemexDb con = new CemexDb();
SqlParameter[] Params1 =
{
// new SqlParameter("@Authority_Id",AuthId),//10 @
new SqlParameter("@user_Id", userprofileBo.User_Id), //10 @
// new SqlParameter("@PropId",PropId),//10 @
};
DataSet ds1 = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_GetUserPwsd", Params1);
string oldpwd = ds1.Tables[0].Rows[0][0].ToString();
// return ds;
var transactionStatus = new TransactionStatus();
var userprofile = BuiltUserProfileDomain(userprofileBo);
if (oldpwd == userprofile.Pswd)
{
oldPassword = userprofile.Pswd;
}
else
{
oldPassword = DESEncrypt(userprofile.Pswd);
}
// string abc = DESEncrypt(userprofile.Pswd);
// CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@opReturnValue", SqlDbType.Int), //12
new SqlParameter("@user_Id", userprofile.User_Id), //0
new SqlParameter("@authority_Id", userprofile.Authority_Id), //0
new SqlParameter("@user_Name", userprofile.User_Name), //3
new SqlParameter("@firstname", userprofile.Firstname), //4
new SqlParameter("@lastname", userprofile.Lastname), //5
new SqlParameter("@pswd", oldPassword), //6
new SqlParameter("@activated_By", "admin"), //7
new SqlParameter("@department", "LMK"), //8
new SqlParameter("@modified_On", System.DateTime.Now), //10
new SqlParameter("@pswd_Reset_On", System.DateTime.Now) //11
};
Params[0].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_UpdateUserProfile", Params);
ds.Locale = CultureInfo.InvariantCulture;
return(transactionStatus);
}
private UserProfile BuiltUserProfileDomain(UserProfileBo userprofileBo)
{
return((UserProfile) new UserProfile().InjectFrom(userprofileBo));
}