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