public bool AddMUser(MUser muser, int cnt) { commandcollection = new SqlCommand[cnt]; count = 0; SqlCommand cmd = null; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "AddMUser"; cmd.Parameters.AddWithValue("@UserCode", muser.UserCode); cmd.Parameters.AddWithValue("@UsersUserCode", muser.UsersUserCode); cmd.Parameters.AddWithValue("@UserName", muser.UserName); cmd.Parameters.AddWithValue("@Password", muser.Password); cmd.Parameters.AddWithValue("@UserAddress", muser.UserAddress); cmd.Parameters.AddWithValue("@PhoneNo", muser.PhoneNo); cmd.Parameters.AddWithValue("@UserType", muser.UserType); cmd.Parameters.AddWithValue("@CityCode", muser.CityCode); cmd.Parameters.AddWithValue("@IsClose", muser.IsClose); cmd.Parameters.AddWithValue("@FkAccYearNo", muser.FkAccYearNo); cmd.Parameters.AddWithValue("@FkCompanyNo", muser.FkCompanyNo); cmd.Parameters.AddWithValue("@FkLocationNo", muser.FkLocationNo); SqlParameter outparameter = new SqlParameter(); outparameter.ParameterName = "@ReturnID"; outparameter.Direction = ParameterDirection.Output; outparameter.DbType = DbType.Int32; cmd.Parameters.Add(outparameter); commandcollection[count] = cmd; count = count + 1; return(true); }
public bool DeleteMUser(MUser muser) { SqlCommand cmd = null; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "DeleteMUser"; cmd.Parameters.AddWithValue("@UserCode", muser.UserCode); if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true) { return(true); } else { muser.msg = ObjTrans.ErrorMessage; return(false); } }
public MUser ModifyMUserByID(long ID) { SqlConnection Con = new SqlConnection(CommonFunctions.ConStr); string sql; SqlCommand cmd; sql = "Select * from MUser where UserCode =" + ID; cmd = new SqlCommand(sql, Con); cmd.Connection = Con; Con.Open(); cmd.CommandType = CommandType.Text; SqlDataReader dr; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (dr.HasRows) { MUser MM = new MUser(); while (dr.Read()) { MM.UserCode = Convert.ToInt32(dr["UserCode"]); if (!Convert.IsDBNull(dr["UsersUserCode"])) { MM.UsersUserCode = Convert.ToString(dr["UsersUserCode"]); } if (!Convert.IsDBNull(dr["UserName"])) { MM.UserName = Convert.ToString(dr["UserName"]); } if (!Convert.IsDBNull(dr["Password"])) { MM.Password = Convert.ToString(dr["Password"]); } if (!Convert.IsDBNull(dr["UserAddress"])) { MM.UserAddress = Convert.ToString(dr["UserAddress"]); } if (!Convert.IsDBNull(dr["PhoneNo"])) { MM.PhoneNo = Convert.ToString(dr["PhoneNo"]); } if (!Convert.IsDBNull(dr["UserType"])) { MM.UserType = Convert.ToInt32(dr["UserType"]); } if (!Convert.IsDBNull(dr["CityCode"])) { MM.CityCode = Convert.ToInt64(dr["CityCode"]); } if (!Convert.IsDBNull(dr["IsClose"])) { MM.IsClose = Convert.ToInt32(dr["IsClose"]); } if (!Convert.IsDBNull(dr["FkAccYearNo"])) { MM.FkAccYearNo = Convert.ToInt64(dr["FkAccYearNo"]); } if (!Convert.IsDBNull(dr["FkCompanyNo"])) { MM.FkCompanyNo = Convert.ToInt64(dr["FkCompanyNo"]); } if (!Convert.IsDBNull(dr["FkLocationNo"])) { MM.FkLocationNo = Convert.ToInt64(dr["FkLocationNo"]); } if (!Convert.IsDBNull(dr["ModifiedBy"])) { MM.ModifiedBy = Convert.ToString(dr["ModifiedBy"]); } } dr.Close(); return(MM); } else { dr.Close(); } return(new MUser()); }