public List<UserBranchesDetailsBO> LoadAllUserBranchesByUserID(int userId)
{
List<UserBranchesDetailsBO> userBranchesList=new List<UserBranchesDetailsBO>();
UserBranchesDetailsBO userBranch = new UserBranchesDetailsBO();
DBEgine dbEgine = new DBEgine();
try{
SqlParameter[] parms = new SqlParameter[1];
SqlParameter p1 = new SqlParameter();
p1.ParameterName = "UserID";
p1.SqlDbType = SqlDbType.Int;
p1.Direction = ParameterDirection.Input;
p1.Value = userId;
parms[0] = p1;
dbEgine.DBOpen();
SqlDataReader drUserBranches = dbEgine.ExecuteReader("UserManagement.UM_LoadUserBranchesByUserID", parms);
if (drUserBranches != null && drUserBranches.HasRows )
{
while(drUserBranches.Read()){
userBranch=FillUserBranches(drUserBranches);
userBranchesList.Add(userBranch);
}
}
return userBranchesList;
}
catch{
throw;
}
finally{
dbEgine.DBClose();
}
}
public int AddUserBranchDetails(DBEgine dbEgine,int userId,UserBranchesDetailsBO obj)
{
try {
SqlParameter[] paramArray = new SqlParameter[3];
SqlParameter branchIDParam = new SqlParameter();
branchIDParam.ParameterName = "@BranchID";
branchIDParam.SqlDbType = SqlDbType.Int;
branchIDParam.Direction = ParameterDirection.Input;
branchIDParam.Value = obj.BranchID;
paramArray[0] = branchIDParam;
SqlParameter userIDParam = new SqlParameter();
userIDParam.ParameterName = "@UserID";
userIDParam.SqlDbType = SqlDbType.Int;
userIDParam.Direction = ParameterDirection.Input;
userIDParam.Value = obj.UserID;
paramArray[1] = userIDParam;
SqlParameter isPrimaryParam = new SqlParameter();
isPrimaryParam.ParameterName = "@IsPrimary";
isPrimaryParam.SqlDbType = SqlDbType.Bit;
isPrimaryParam.Direction = ParameterDirection.Input;
isPrimaryParam.Value = obj.IsPrimary;
paramArray[2] = isPrimaryParam;
dbEgine.ExecNonQueryStoredProc("UserManagement.UM_AddUserBranchesDetails", paramArray);
return obj.BranchID;
}
catch
{
throw;
}
}
private UserBranchesDetailsBO FillUserBranches(SqlDataReader reader)
{
var userBranches = new UserBranchesDetailsBO();
userBranches.UserBranchID=reader.GetInt32( reader.GetOrdinal("UserBranchID"));
userBranches.UserID = reader.GetInt32(reader.GetOrdinal("UserID"));
userBranches.BranchID = reader.GetInt32(reader.GetOrdinal("BranchID"));
userBranches.IsPrimary = reader.GetBoolean(reader.GetOrdinal("IsPrimary"));
return userBranches;
}
public UserBranchesDetailsBO LoadUserBrancheByUserIDANDBranchID(int userId,int branchId)
{
List<UserBranchesDetailsBO> userBranchesList = new List<UserBranchesDetailsBO>();
UserBranchesDetailsBO userBranch = new UserBranchesDetailsBO();
DBEgine dbEgine = new DBEgine();
try
{
SqlParameter[] parms = new SqlParameter[2];
SqlParameter p1 = new SqlParameter();
p1.ParameterName = "UserID";
p1.SqlDbType = SqlDbType.Int;
p1.Direction = ParameterDirection.Input;
p1.Value = userId;
parms[0] = p1;
SqlParameter p2 = new SqlParameter();
p2.ParameterName = "BranchID";
p2.SqlDbType = SqlDbType.Int;
p2.Direction = ParameterDirection.Input;
p2.Value = branchId;
parms[1] = p2;
dbEgine.DBOpen();
SqlDataReader drUserBranches = dbEgine.ExecuteReader("UserManagement.UM_LoadUserBranchByUserIDANDBranchID", parms);
if (drUserBranches != null && drUserBranches.HasRows && drUserBranches.Read())
{
userBranch = FillUserBranches(drUserBranches);
}
return userBranch;
}
catch
{
throw;
}
finally
{
dbEgine.DBClose();
}
}
