public void LoadMaster()
{
try
{
//ClientAge
GridViewSearchMaster.Columns[8].Visible = true;
//ClientDOB
GridViewSearchMaster.Columns[9].Visible = true;
List <FBClientsInfo> items;
FBClientsController controller = new FBClientsController();
items = controller.FBClients_Search(this.PortalId, txtLastName.Text.ToString().Replace("'", "''").Trim(),
"",
"",
hidClientIDMaster.Value,
"",
"", "", "0");
GridViewSearchMaster.DataSource = items;
GridViewSearchMaster.DataBind();
}
catch (Exception ex)
{
Exceptions.ProcessModuleLoadException(this, ex);
}
}
public void FillClientRecord(int clientID)
{
try
{
// lblMessage.Text = "";
//load the item
FBClientsController controller = new FBClientsController();
FBClientsInfo item = controller.FBClients_GetByID(this.PortalId, clientID);
if (item != null)
{
// Response.Write(item);
StringBuilder builder = new StringBuilder();
string ClientInfo = "";
string _phoneType = "";
if (item.ClientPhoneType == "0")
{
_phoneType = "";
}
else
{
_phoneType = item.ClientPhoneType + " ";
}
//Set Page Name
SetPageName("Christmas Toys Voucher for " + item.ClientFirstName + " " + item.ClientLastName);
// QUICK VIEW SECTION
ClientInfo = item.ClientFirstName + " " + item.ClientLastName + " - " + item.ClientAddress + ", " + item.ClientTown + ", " + item.ClientState + " " + item.ClientZipCode
+ "<br />" + _phoneType.ToString() + "Phone: " + item.ClientPhone
+ "<br />Entry Date: " + item.CreatedOnDate.ToShortDateString()
+ "<br /><font color='Red'>Client ID: " + item.ClientID + "</font>";
lblMessage.Text = ClientInfo.ToString();
}
else
{
Response.Redirect(DotNetNuke.Common.Globals.NavigateURL(), true);
}
}
catch (Exception ex)
{
Exceptions.ProcessModuleLoadException(this, ex);
}
}
protected void Merge(int MasterClientID, int ChildClientID)
{
FBClientsController controller = new FBClientsController();
int result = controller.FBClients_Merge(MasterClientID, ChildClientID);
if (result == 1)
{
lblMsg.Text = "Merge was done.";
}
else
{
lblMsg.Text = "Merge blew up.";
}
}
public void SearchClients()
{
try
{
// DEAL WITH INCLUDE INACTIVE CHECKBOX
string Should_I_IncludeInactives = "";
if (cbxIncludeInactive.Checked)
{
Should_I_IncludeInactives = "0";
}
else
{
Should_I_IncludeInactives = "1";
}
//ClientAge
GridViewSearch.Columns[10].Visible = true;
//ClientDOB
GridViewSearch.Columns[11].Visible = true;
List <FBClientsInfo> items;
FBClientsController controller = new FBClientsController();
items = controller.FBClients_Search(this.PortalId, txtLastName.Text.ToString().Replace("'", "''").Trim(),
txtClientIdCard.Text.ToString().Trim(),
txtFirstName.Text.ToString().Replace("'", "''").Trim(),
txtClientId.Text.ToString(),
txtAddress.Text.ToString(),
ddlCity.SelectedValue.ToString(), ddlClientType.SelectedValue.ToString(), Should_I_IncludeInactives.ToString());
GridViewSearch.DataSource = items;
GridViewSearch.DataBind();
//ClAddFamMemFirstName
GridViewSearch.Columns[15].Visible = false;
//ClAddFamMemLastName
GridViewSearch.Columns[16].Visible = false;
}
catch (Exception ex)
{
Exceptions.ProcessModuleLoadException(this, ex);
}
}
public void LoadChild()
{
try
{
List <FBClientsInfo> items;
FBClientsController controller = new FBClientsController();
items = controller.FBClients_Search(this.PortalId, txtLastName.Text.ToString().Replace("'", "''").Trim(),
txtClientIdCard.Text.ToString().Trim(),
txtFirstName.Text.ToString().Replace("'", "''").Trim(),
txtClientId.Text.ToString(),
txtAddress.Text.ToString(),
ddlCity.SelectedValue.ToString(), "", "0");
GridViewSearchChild.DataSource = items;
GridViewSearchChild.DataBind();
}
catch (Exception ex)
{
Exceptions.ProcessModuleLoadException(this, ex);
}
}
public void SearchClientAFMs()
{
try
{
// DEAL WITH INCLUDE INACTIVE CHECKBOX
string Should_I_IncludeInactives = "";
if (cbxIncludeInactive.Checked)
{
Should_I_IncludeInactives = "0";
}
else
{
Should_I_IncludeInactives = "1";
}
GridViewSearch.Columns[15].Visible = true;
GridViewSearch.Columns[16].Visible = true;
//ClientAge
GridViewSearch.Columns[10].Visible = false;
//ClientDOB
GridViewSearch.Columns[11].Visible = false;
List <FBClientsInfo> items;
FBClientsController controller = new FBClientsController();
items = controller.FBClients_Search_AFM(this.PortalId, txtLastNameAFM.Text.ToString().Replace("'", "''").Trim(),
txtFirstNameAFM.Text.ToString().Replace("'", "''").Trim(), Should_I_IncludeInactives.ToString());
//GridViewSearch.Rows. = null;
GridViewSearch.DataSource = items;
GridViewSearch.DataBind();
}
catch (Exception ex)
{
Exceptions.ProcessModuleLoadException(this, ex);
}
}
public void SaveImageToDatabase(string imageData)
{
try
{
FBClientsController controller = new FBClientsController();
FBClientsInfo item = new FBClientsInfo();
byte[] imageBytes = Convert.FromBase64String(imageData.Replace("data:image/png;base64,", String.Empty));
item.ClientID = clientId;
item.IDPhoto = imageBytes;
item.CreatedByUserID = this.UserId;
controller.FBClients_IDPhoto_Insert(item);
FillClientRecord(clientId);
}
catch (Exception ex)
{
Exceptions.ProcessModuleLoadException(this, ex);
}
}
public void FillClientRecord(int clientID)
{
try
{
//load the item
FBClientsController controller = new FBClientsController();
FBClientsInfo item = controller.FBClients_GetByID(this.PortalId, clientID);
if (item != null)
{
LabelClientInfo.Text = item.ClientFirstName + ' ' + item.ClientLastName + " - ";
LabelClientInfo.Text += item.ClientAddress + ", " + item.ClientTown + ", " + item.ClientState + " " + item.ClientZipCode;
if (item.IDPhoto != null)
{
ImageIDClient.Visible = true;
byte[] imagem = (byte[])(item.IDPhoto);
string PROFILE_PIC = Convert.ToBase64String(imagem);
ImageIDClient.ImageUrl = String.Format("data:image/png;base64,{0}", PROFILE_PIC);
ImageIDClient.AlternateText = item.ClientFirstName + ' ' + item.ClientLastName;
}
else
{
ImageIDClient.Visible = false;
}
}
else
{
Response.Redirect(DotNetNuke.Common.Globals.NavigateURL(), true);
}
}
catch (Exception ex)
{
Exceptions.ProcessModuleLoadException(this, ex);
}
}
public void FillAFMGrid()
{
try
{
gvAFM.DataSource = "";
// gvAFM.DataBind();
List <FBClientsInfo> items;
FBClientsController controller = new FBClientsController();
items = controller.FBxMas_AFM_PrintTicket(clientId);
gvAFM.DataSource = items;
gvAFM.DataBind();
//bool _isValidBOB = true;
//bool _isVerified = true;
//foreach (GridViewRow tt in gvAFM.Rows)
//{
// if (tt.RowType == DataControlRowType.DataRow)
// {
// string age = tt.Cells[7].Text;
// if (age == "-1")
// {
// _isValidBOB = false;
// break;
// }
// }
//}
//foreach (GridViewRow vv in gvAFM.Rows)
//{
// if (vv.RowType == DataControlRowType.DataRow)
// {
// // gvAFM.Columns[7].Visible = true;
// string verify = vv.Cells[8].Text;
// if (verify.ToString().ToLower() == "false")
// {
// _isVerified = false;
// break;
// }
// }
//}
//gvAFM.Columns[8].Visible = false;
//if (_isValidBOB == false)
//{
// lblMessage.Text += "<br />" + Localization.GetString("ErrorNoDateOfBirthAFM", this.LocalResourceFile);
// lblMessage.Visible = true;
//}
//if (_isVerified == false)
//{
// lblMessage.Text += "<br />" + Localization.GetString("ErrorNoAFMVerify", this.LocalResourceFile);
// lblMessage.Visible = true;
//}
}
catch (Exception ex)
{
Exceptions.ProcessModuleLoadException(this, ex);
}
}
