/// <summary>
/// Update Database Make data as Obsoluted
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void IsObsolete_CheckedChanged(Object sender, EventArgs e)
{
string message = string.Empty;
try
{
CheckBox chk = (CheckBox)sender;
GridViewRow gr = (GridViewRow)chk.Parent.Parent;
ViewState["BankBranchId"] = ((Literal)gr.FindControl("litBankBranchId")).Text;
BranchBLL objBranchBLL = new BranchBLL();
message = objBranchBLL.ObsoleteBranch(Convert.ToInt32(ViewState["BankBranchId"]), Convert.ToString(chk.Checked));
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data Updated successfully";
}
BindGrid();
ClearDetails();
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult GetEmployee()
{
try
{
int pageIndex = Convert.ToInt32(Request.QueryString["page"]);
int pageSize = Convert.ToInt32(Request.QueryString["limit"]);
string branchIds = Request.QueryString["id"];
string[] _ids = branchIds.Split(',');
int[] ids = Array.ConvertAll <string, int>(_ids, id =>
{
return(int.Parse(id));
});
EmployeeBLL eBll = new EmployeeBLL();
int rows = 0;
int totalPages = 0;
List <Employee> list = eBll.LoadPagedEntitys(pageIndex, pageSize, out rows, out totalPages, t => ids.Contains(t.branchId), true, t => t.Id);
if (list != null && list.Count > 0)
{
List <Branch> branchList = new BranchBLL().GetEntitys();
list.ForEach(t =>
{
branchList.ForEach(y =>
{
if (t.branchId == y.Id)
{
t.branchName = y.branchName;
}
});
});
List <Role> roleList = new RoleBLL().GetEntitys();
list.ForEach(t =>
{
roleList.ForEach(y =>
{
if (t.roleId == y.Id)
{
t.roleName = y.roleName;
}
});
});
List <Position> positionList = new PositionBLL().GetEntitys();
list.ForEach(t =>
{
positionList.ForEach(y =>
{
if (t.positionId == y.Id)
{
t.positionName = y.positionName;
}
});
});
}
string resJson = Common.Common.JsonSerialize(list);
resJson = "{total:" + rows + ",root:" + resJson + "}";
return(Content(resJson));
}
catch { }
return(Content("{}"));
}
public void UpdateResponsible()
{
//Prueba la asigna un responsable a la donación
//Creación del donador, un empleado (persona), la donación y el voluntario
DonorBM donor = create_donor();
PersonBM personBm = create_person();
DonationStatusBM statusBm = get_status(1);
DonationBLL donationBll = new DonationBLL();
DonationBM donationBm = new DonationBM(3, donor.donorId, statusBm, "Esta es una donación creada por un test.");
ResultBM donationResult = donationBll.SaveDonation(donationBm);
BranchBLL branchBll = new BranchBLL();
ResultBM branchResult = branchBll.GetBranch(1);
VolunteerBLL volunteerBll = new VolunteerBLL();
VolunteerBM volunteerBm = new VolunteerBM(personBm, branchResult.GetValue <BranchBM>());
ResultBM volunterResult = volunteerBll.SaveVolunteer(volunteerBm);
donationBm.volunteer = volunterResult.GetValue <VolunteerBM>();
ResultBM updateResult = donationBll.UpdateDonation(donationBm);
Assert.IsTrue(updateResult.IsValid(), "La operación debería ser válida.");
donationResult = donationBll.GetDonation(updateResult.GetValue <DonationBM>().id);
Assert.IsTrue(donationResult.IsValid(), "La operación debería ser válida.");
Assert.IsNotNull(donationResult.GetValue(), "Deería haber devuelto una donación.");
Assert.IsNotNull(donationResult.GetValue <DonationBM>().volunteer, "Deería haber devuelto un voluntario.");
Assert.AreEqual(donationResult.GetValue <DonationBM>().volunteer.volunteerId, volunterResult.GetValue <VolunteerBM>().volunteerId, "Debería ser el mismo voluntario.");
}
public ActionResult GetEmployee()
{
try
{
int pageIndex = Convert.ToInt32(Request.QueryString["page"]);
int pageSize = Convert.ToInt32(Request.QueryString["limit"]);
string branchIds = Request.QueryString["id"];
string[] _ids = branchIds.Split(',');
int[] ids = Array.ConvertAll<string, int>(_ids, id =>
{
return int.Parse(id);
});
EmployeeBLL eBll = new EmployeeBLL();
int rows = 0;
int totalPages = 0;
List<Employee> list = eBll.LoadPagedEntitys(pageIndex, pageSize, out rows, out totalPages, t => ids.Contains(t.branchId), true, t => t.Id);
if (list != null && list.Count > 0)
{
List<Branch> branchList = new BranchBLL().GetEntitys();
list.ForEach(t =>
{
branchList.ForEach(y =>
{
if (t.branchId == y.Id)
{
t.branchName = y.branchName;
}
});
});
List<Role> roleList = new RoleBLL().GetEntitys();
list.ForEach(t =>
{
roleList.ForEach(y =>
{
if (t.roleId == y.Id)
{
t.roleName = y.roleName;
}
});
});
List<Position> positionList = new PositionBLL().GetEntitys();
list.ForEach(t =>
{
positionList.ForEach(y =>
{
if (t.positionId == y.Id)
{
t.positionName = y.positionName;
}
});
});
}
string resJson = Common.Common.JsonSerialize(list);
resJson = "{total:" + rows + ",root:" + resJson + "}";
return Content(resJson);
}
catch { }
return Content("{}");
}
public ActionResult GetBranch()
{
BranchBLL bBll = new BranchBLL();
List <Branch> branchList = bBll.GetEntitys(t => t.sort);
List <BranchTree> list = new List <BranchTree>();
foreach (Branch branch in branchList)
{
if (branch.parent == 0)
{
BranchTree bTree = new BranchTree();
bTree.Id = branch.Id;
bTree.branchName = branch.branchName;
bTree.parent = branch.parent;
bTree.sort = branch.sort;
bTree.telPhone = branch.telPhone;
bTree.fax = branch.fax;
bTree.expanded = true;
bTree.leaf = false;
bTree.children = BranchEach(branchList, branch);
list.Add(bTree);
}
}
string resJson = Common.Common.JsonSerialize(list);
resJson = "{'checked':false,'children':" + resJson;
resJson += "}";
return(Content(resJson));
}
public ActionResult GetBranch()
{
BranchBLL bBll = new BranchBLL();
List<Branch> branchList = bBll.GetEntitys(t=>t.sort);
List<BranchTree> list = new List<BranchTree>();
foreach (Branch branch in branchList)
{
if (branch.parent == 0)
{
BranchTree bTree = new BranchTree();
bTree.Id = branch.Id;
bTree.branchName = branch.branchName;
bTree.parent = branch.parent;
bTree.sort = branch.sort;
bTree.telPhone = branch.telPhone;
bTree.fax = branch.fax;
bTree.expanded = true;
bTree.leaf = false;
bTree.children = BranchEach(branchList, branch);
list.Add(bTree);
}
}
string resJson = Common.Common.JsonSerialize(list);
resJson = "{'checked':false,'children':" + resJson;
resJson += "}";
return Content(resJson);
}
/// <summary>
/// Set Grid Data source
/// </summary>
/// <param name="addRow"></param>
/// <param name="deleteRow"></param>
private void BindBranches()
{
BranchBLL objBranchBLL = new BranchBLL();
int BankID = Convert.ToInt32(ViewState["BANK_ID"]);
grdBankBranchs.DataSource = objBranchBLL.GetAllBranches(BankID);
grdBankBranchs.DataBind();
}
/// <summary>
/// Search banks data from the database and set filterd data to Grid Data source
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnClearSearch_Click(object sender, EventArgs e)
{
ClearDetails();
BranchBLL objBranchBLL = new BranchBLL();
grdBankBranchs.DataSource = objBranchBLL.GetAllBranches(Convert.ToInt32(ViewState["BANK_ID"]));
grdBankBranchs.DataBind();
}
public ActionResult DeleteBranch()
{
string ids = Request.Form["ids"];
BranchBLL bBll = new BranchBLL();
if (bBll.DeletePhysicsById(ids))
{
return Content("{'success':'ok'}");
}
else
{
return Content("{}");
}
}
public ActionResult DeleteBranch()
{
string ids = Request.Form["ids"];
BranchBLL bBll = new BranchBLL();
if (bBll.DeletePhysicsById(ids))
{
return(Content("{'success':'ok'}"));
}
else
{
return(Content("{}"));
}
}
public void CreateVolunteer()
{
//Crea un donador
PersonBM personBm = create_person();
BranchBLL branchBll = new BranchBLL();
ResultBM brancResult = branchBll.GetBranch(1);
Assert.IsTrue(brancResult.IsValid(), "El donador debería existir.");
VolunteerBLL volunteerBll = new VolunteerBLL();
VolunteerBM volunteerBm = new VolunteerBM(personBm, brancResult.GetValue <BranchBM>());
ResultBM volunterResult = volunteerBll.SaveVolunteer(volunteerBm);
Assert.IsTrue(volunterResult.IsValid(), "El donador debería existir.");
Assert.IsNotNull(volunterResult.GetValue(), "Debería existir el voluntario.");
Assert.IsTrue(volunterResult.GetValue <VolunteerBM>().id > 0, "Debería existir el voluntario.");
}
/// <summary>
/// to bind the Bank Branches
/// </summary>
/// <param name="bankID"></param>
protected void BindBankBranches(int bankID)
{
ListItem firstListItem = new ListItem(ddlBranch.Items[0].Text, ddlBranch.Items[0].Value);
ddlBranch.Items.Clear();
if (bankID > 0)
{
BranchBLL objBranchBLL = new BranchBLL();
ddlBranch.DataSource = objBranchBLL.GetActiveBranches(bankID);
ddlBranch.DataTextField = "BRANCHNAME";
ddlBranch.DataValueField = "BankBranchId";
ddlBranch.DataBind();
}
ddlBranch.Items.Insert(0, firstListItem);
ddlBranch.SelectedIndex = 0;
}
public ActionResult Save()
{
Branch branch = new Branch();
try
{
string stated = Request.Form["stated"];
if (stated == "add")
{
branch.parent = Convert.ToInt32(Request.Form["Id"]);
}
else if (stated == "update")
{
branch.parent = Convert.ToInt32(Request.Form["parent"]);
branch.Id = Convert.ToInt32(Request.Form["Id"]);
}
branch.branchName = Request.Form["branchName"];
branch.telPhone = Request.Form["telPhone"];
branch.fax = Request.Form["fax"];
branch.expanded = Convert.ToInt32(Request.Form["expanded"]) == 0 ? false : true;
branch.leaf = Convert.ToInt32(Request.Form["leaf"]) == 0 ? false : true;
branch.sort = Convert.ToInt32(Request.Form["sort"]);
BranchBLL bBll = new BranchBLL();
if (stated == "add")
{
if (bBll.AddEntity(branch))
{
return(Content("{'success':'ok'}"));
}
}
else if (stated == "update")
{
if (bBll.ModifyEntity(branch))
{
return(Content("{'success':'ok'}"));
}
}
}
catch { }
return(Content("{}"));
}
/// <summary>
/// Save and Update Data into Database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
BranchBO objBranchBO = new BranchBO();
objBranchBO.BankBranchId = Convert.ToInt32(ViewState["BankBranchId"]);
objBranchBO.BankID = Convert.ToInt32(ViewState["BANK_ID"]);
objBranchBO.BranchName = txtBranchName0.Text.Trim();
objBranchBO.City = txtCity0.Text.Trim();
objBranchBO.SwiftCode = txtSwiftCode.Text.Trim();
objBranchBO.BANKCODE = txtBankCode.Text.Trim();
BranchBLL objBranchBLL = new BranchBLL();
string AlertMessage = string.Empty;
string message = string.Empty;
if (objBranchBO.BankBranchId == 0)
{
objBranchBO.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
message = objBranchBLL.AddBranch(objBranchBO);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
ClearDetails();
}
}
else
{
objBranchBO.UpdatedBy = Convert.ToInt32(Session["USER_ID"]);
message = objBranchBLL.UpdateBranch(objBranchBO);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
ClearDetails();
}
}
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
BindGrid();
}
/// <summary>
/// Set edit mode for edit comand
/// Delete data from the database for delete comand
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void grdBankBranchs_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditRow")
{
ViewState["BankBranchId"] = e.CommandArgument;
BranchBO objBranchBO = new BranchBO();
BranchBLL objBranchBLL = new BranchBLL();
objBranchBO = objBranchBLL.GetBranchById(Convert.ToInt32(ViewState["BankBranchId"]));
if (objBranchBO != null)
{
ViewState["BankBranchId"] = objBranchBO.BankBranchId;
txtBranchName0.Text = objBranchBO.BranchName;
txtCity0.Text = objBranchBO.City;
txtSwiftCode.Text = objBranchBO.SwiftCode;
txtBankCode.Text = objBranchBO.BANKCODE;
}
SetUpdateMode(true);
}
else if (e.CommandName == "DeleteRow")
{
string message = string.Empty;
int Branch = Convert.ToInt32(e.CommandArgument);
BranchBLL objBranchBLL = new BranchBLL();
message = objBranchBLL.DeleteBranch(Convert.ToInt32(e.CommandArgument));
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
ClearDetails();
}
message = "Data deleted successfully";
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
BindGrid();
}
}
public static void InitDB()
{
if (IsInited)
{
return;
}
UserBLL.Add(new Model.DBUser()
{
OpenID = "0001", BranchID = "001", Name = "唐赞飞", NickName = "飞", IsManager = true
});
UserBLL.Add(new Model.DBUser()
{
OpenID = "0002", BranchID = "001", Name = "唐观文", NickName = "唐观文", IsManager = true
});
UserBLL.Add(new Model.DBUser()
{
OpenID = "0003", BranchID = "001", Name = "欧阳石光", NickName = "时光", IsManager = false
});
BranchBLL.Add(new Model.DBBranch()
{
ID = "001", MasterID = "0002", Name = "县委组织部第一支部"
});
PointBLL.Add(new Model.DBPoint()
{
ID = "001", Name = "县委组织部会议室", QrCode = "XWZZBHYS", WifiName = "556", WifiMac = "FF-FF-FF-FF"
});
PointBLL.Add(new Model.DBPoint()
{
ID = "002", Name = "翡翠湾社区", QrCode = "FCWSQ", WifiName = "TPLink368E", WifiMac = "FF-FF-FF-FF"
});
PointBLL.Add(new Model.DBPoint()
{
ID = "003", Name = "凯旋城", QrCode = "KXC", WifiName = "TPLink368E", WifiMac = "FF-FF-FF-FF"
});
IsInited = true;
}
public ActionResult Save()
{
Branch branch = new Branch();
try
{
string stated = Request.Form["stated"];
if (stated == "add")
branch.parent = Convert.ToInt32(Request.Form["Id"]);
else if (stated == "update")
{
branch.parent = Convert.ToInt32(Request.Form["parent"]);
branch.Id = Convert.ToInt32(Request.Form["Id"]);
}
branch.branchName = Request.Form["branchName"];
branch.telPhone = Request.Form["telPhone"];
branch.fax = Request.Form["fax"];
branch.expanded = Convert.ToInt32(Request.Form["expanded"]) == 0 ? false : true;
branch.leaf = Convert.ToInt32(Request.Form["leaf"]) == 0 ? false : true;
branch.sort = Convert.ToInt32(Request.Form["sort"]);
BranchBLL bBll = new BranchBLL();
if (stated == "add")
{
if (bBll.AddEntity(branch))
{
return Content("{'success':'ok'}");
}
}
else if (stated == "update")
{
if (bBll.ModifyEntity(branch))
{
return Content("{'success':'ok'}");
}
}
}
catch { }
return Content("{}");
}
