/// <summary> /// Function to Update password /// </summary> /// <param name="userinfo"></param> public void ChangePasswordEdit(UserInfo userinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("ChangePasswordEdit", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@userId", SqlDbType.Decimal); sprmparam.Value = userinfo.UserId; sprmparam = sccmd.Parameters.Add("@userName", SqlDbType.VarChar); sprmparam.Value = userinfo.UserName; sprmparam = sccmd.Parameters.Add("@password", SqlDbType.VarChar); sprmparam.Value = userinfo.Password; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } }
public void UserAdd(UserInfo infoUser) { UserSP spUser = new UserSP(); try { spUser.UserAdd(infoUser); } catch (Exception ex) { MessageBox.Show("UBLL1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to get particular values from account group table based on the parameter /// </summary> /// <param name="userId"></param> /// <returns></returns> public UserInfo UserView(decimal userId) { UserInfo infoUser = new UserInfo(); UserSP spUser = new UserSP(); try { infoUser=spUser.UserView( userId); } catch (Exception ex) { MessageBox.Show("UBLL1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return infoUser; }
/// <summary> /// Function to get particular values from account group table based on the parameter /// </summary> /// <param name="userId"></param> /// <returns></returns> public UserInfo UserView(decimal userId) { UserInfo userinfo = new UserInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("UserView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@userId", SqlDbType.Decimal); sprmparam.Value = userId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { userinfo.UserId = decimal.Parse(sdrreader[0].ToString()); userinfo.UserName = sdrreader[1].ToString(); userinfo.Password = sdrreader[2].ToString(); userinfo.Active = bool.Parse(sdrreader[3].ToString()); userinfo.RoleId = decimal.Parse(sdrreader[4].ToString()); userinfo.Narration = sdrreader[5].ToString(); userinfo.ExtraDate = DateTime.Parse(sdrreader[6].ToString()); userinfo.Extra1 = sdrreader[7].ToString(); userinfo.Extra2 = sdrreader[8].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return userinfo; }
/// <summary> /// Function to insert values to account group Table /// </summary> /// <param name="userinfo"></param> public void UserAdd(UserInfo userinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("UserAdd", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@userName", SqlDbType.VarChar); sprmparam.Value = userinfo.UserName; sprmparam = sccmd.Parameters.Add("@password", SqlDbType.VarChar); sprmparam.Value = userinfo.Password; sprmparam = sccmd.Parameters.Add("@active", SqlDbType.Bit); sprmparam.Value = userinfo.Active; sprmparam = sccmd.Parameters.Add("@roleId", SqlDbType.Decimal); sprmparam.Value = userinfo.RoleId; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = userinfo.Narration; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = userinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = userinfo.Extra2; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } }