/// <summary>
/// Date Created: 11/Jan/2013
/// Created By: Josephine Gad
/// (description) Save Region to Database
/// </summary>
private void SaveUserRegion()
{
DataTable dt = null;
try
{
CheckBox uoCheckBoxSelect;
HiddenField uoHiddenFieldRegion;
Label uoLabelRegion;
List <UserRegionList> listAdded = new List <UserRegionList>();
List <UserRegionToAdd> listToBeAdded = new List <UserRegionToAdd>();
//List<UserRegionList> listToAdd = new List<UserRegionList>();
//Get the list of user's region
if (Session["UserRegionList"] != null)
{
listAdded = (List <UserRegionList>)Session["UserRegionList"];
}
else
{
foreach (ListViewItem item in uoListViewRegion.Items)
{
uoCheckBoxSelect = (CheckBox)item.FindControl("uoCheckBoxSelect");
uoHiddenFieldRegion = (HiddenField)item.FindControl("uoHiddenFieldRegion");
uoLabelRegion = (Label)item.FindControl("uoLabelRegion");
bool IsExist = false;
if (uoCheckBoxSelect.Enabled)
{
IsExist = true;
}
UserRegionList listAddedItem = new UserRegionList();
listAddedItem.RegionID = GlobalCode.Field2Int(uoHiddenFieldRegion.Value);
listAddedItem.RegionName = uoLabelRegion.Text;
listAddedItem.UserRegionID = 0;
listAddedItem.IsExist = IsExist;
listAdded.Add(listAddedItem);
}
}
dt = new DataTable();
dt.Columns.Add("UserName", typeof(string));
dt.Columns.Add("RegonID", typeof(string));
for (int i = 0; i < listAdded.Count; i++)
{
//UserRegionToAdd item = new UserRegionToAdd();
//item.RegionID = listAdded[i].RegionID;
//item.RegionName = listAdded[i].RegionName;
//listToBeAdded.Add(item);
DataRow r = dt.NewRow();
r["UserName"] = uoDropDownListUsers.SelectedValue;
r["RegonID"] = listAdded[i].RegionID;
dt.Rows.Add(r);
}
string strLogDescription = "Region of User added";
string strFunction = "SaveUserRegion";
//dt = getDataTable(listToBeAdded);
UserRightsBLL.SaveUserRegion(dt, uoHiddenFieldUser.Value, strLogDescription, strFunction, Path.GetFileName(Request.Path));
AlertMessage("User Region successfully saved.");
}
catch (Exception ex)
{
AlertMessage(ex.Message);
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
/// <summary>
/// Date Created: 11/Jan/2013
/// Created By: Josephine Gad
/// (description) Move Region from right to left list
/// </summary>
private void RemoveRegion()
{
CheckBox uoCheckBoxSelect;
HiddenField uoHiddenFieldRegion;
Label uoLabelRegion;
List <UserRegionList> listAdded = new List <UserRegionList>();
List <UserRegionToAdd> listToBeAdded = new List <UserRegionToAdd>();
//List<UserRegionList> listToAdd = new List<UserRegionList>();
//Get the list of user's region
if (Session["UserRegionList"] != null)
{
listAdded = (List <UserRegionList>)Session["UserRegionList"];
}
else
{
foreach (ListViewItem item in uoListViewRegion.Items)
{
uoCheckBoxSelect = (CheckBox)item.FindControl("uoCheckBoxSelect");
uoHiddenFieldRegion = (HiddenField)item.FindControl("uoHiddenFieldRegion");
uoLabelRegion = (Label)item.FindControl("uoLabelRegion");
bool IsExist = false;
if (uoCheckBoxSelect.Enabled)
{
IsExist = true;
}
UserRegionList listAddedItem = new UserRegionList();
listAddedItem.RegionID = GlobalCode.Field2Int(uoHiddenFieldRegion.Value);
listAddedItem.RegionName = uoLabelRegion.Text;
listAddedItem.UserRegionID = 0;
listAddedItem.IsExist = IsExist;
listAdded.Add(listAddedItem);
}
}
//Get the list of region to be added to user
if (Session["UserRegionToAdd"] != null)
{
listToBeAdded = (List <UserRegionToAdd>)Session["UserRegionToAdd"];
}
else
{
foreach (ListViewItem item in uoListViewRegionToAdd.Items)
{
uoCheckBoxSelect = (CheckBox)item.FindControl("uoCheckBoxSelect");
uoHiddenFieldRegion = (HiddenField)item.FindControl("uoHiddenFieldRegion");
uoLabelRegion = (Label)item.FindControl("uoLabelRegion");
UserRegionToAdd listItem = new UserRegionToAdd();
listItem.RegionID = GlobalCode.Field2Int(uoHiddenFieldRegion.Value);
listItem.RegionName = uoLabelRegion.Text;
listToBeAdded.Add(listItem);
}
}
//Get selected region to add
foreach (ListViewItem item in uoListViewRegion.Items)
{
uoCheckBoxSelect = (CheckBox)item.FindControl("uoCheckBoxSelect");
uoHiddenFieldRegion = (HiddenField)item.FindControl("uoHiddenFieldRegion");
uoLabelRegion = (Label)item.FindControl("uoLabelRegion");
if (uoCheckBoxSelect.Checked)
{
UserRegionToAdd listItem = new UserRegionToAdd();
listItem.RegionID = GlobalCode.Field2Int(uoHiddenFieldRegion.Value);
listItem.RegionName = uoLabelRegion.Text;
listToBeAdded.Add(listItem);
listAdded.RemoveAll(a => a.RegionID == GlobalCode.Field2Int(uoHiddenFieldRegion.Value));
}
}
listToBeAdded = listToBeAdded.OrderBy(a => a.RegionName).ToList();
listAdded = listAdded.OrderBy(a => a.RegionName).ToList();
Session["UserRegionToAdd"] = listToBeAdded;
Session["UserRegionList"] = listAdded;
uoListViewRegion.DataSource = listAdded;
uoListViewRegion.DataBind();
uoListViewRegionToAdd.DataSource = listToBeAdded;
uoListViewRegionToAdd.DataBind();
}
