public string SaveUser(DTO.UserMaster Ob)
{
string res = "";
if (CheckDuplicateUserPin(Ob) == true)
{
res = "User pin is already in Use, Please enter new Pin.";
return(res);
}
if (CheckDuplicateUserBarcode(Ob) == true)
{
res = "User Barcode is already in use, Please change the barcode.";
return(res);
}
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_UserMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", Ob.UserId);
cmd.Parameters.AddWithValue("@UserPassword", Ob.UserPassword);
cmd.Parameters.AddWithValue("@UserTypeCode", Ob.UserTypeCode);
cmd.Parameters.AddWithValue("@UserBranchCode", Ob.UserBranchCode);
cmd.Parameters.AddWithValue("@UserName", Ob.UserName);
cmd.Parameters.AddWithValue("@UserAddress", Ob.UserAddress);
cmd.Parameters.AddWithValue("@UserPhoneNumber", Ob.UserPhoneNumber);
cmd.Parameters.AddWithValue("@UserMobileNumber", Ob.UserMobileNumber);
cmd.Parameters.AddWithValue("@UserEmailId", Ob.UserEmailId);
cmd.Parameters.AddWithValue("@UserActive", Ob.UserActive);
cmd.Parameters.AddWithValue("@Userbarcode", Ob.UserBarcode);
cmd.Parameters.AddWithValue("@UserPin", Ob.UserPin);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 1);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
private bool CheckDuplicateUserBarcode(DTO.UserMaster Ob)
{
SqlCommand cmd = new SqlCommand();
SqlDataReader sdr = null;
bool status = false;
try
{
cmd.CommandText = "sp_UserMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Userbarcode", Ob.UserBarcode);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 6);
sdr = PrjClass.ExecuteReader(cmd);
if (sdr.Read())
{
status = true;
}
else
{
status = false;
}
}
catch (Exception ex) { }
finally
{
sdr.Close();
sdr.Dispose();
cmd.Dispose();
}
return(status);
}
public DataSet BindGrid(DTO.UserMaster Ob)
{
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
cmd.CommandText = "sp_UserMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 3);
ds = PrjClass.GetData(cmd);
return(ds);
}
public DataSet WorkshopSearchAndShowAll(DTO.UserMaster Ob)
{
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
cmd.CommandText = "sp_UserMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserName", Ob.UserName);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 12);
ds = PrjClass.GetData(cmd);
return(ds);
}
public string SaveUser(DTO.UserMaster Ob)
{
return DAL.DALFactory.Instance.DAL_UserMaster.SaveUser(Ob);
}
public DataSet WorkshopSearchAndShowAll(DTO.UserMaster Ob)
{
return DAL.DALFactory.Instance.DAL_UserMaster.WorkshopSearchAndShowAll(Ob);
}
public DataSet BindWorkShopUserGrid(DTO.UserMaster Ob)
{
return DAL.DALFactory.Instance.DAL_UserMaster.BindWorkShopUserGrid(Ob);
}
public string UpdateWorkshopUser(DTO.UserMaster Ob)
{
return DAL.DALFactory.Instance.DAL_UserMaster.UpdateWorkshopUser(Ob);
}
public DataSet FillTextBoxes(DTO.UserMaster Ob)
{
return DAL.DALFactory.Instance.DAL_UserMaster.FillTextBoxes(Ob);
}
