public static bool SavePerson(ATTPerson objPerson)
{
try
{
return(PCS.COMMON.DLL.DLLPerson.AddPersonnelDetails(objPerson));
}
catch (Exception ex)
{
throw ex;
}
}
public static ATTPerson GetPersonWithPersonnelAttributeByID(double personID)
{
object conn;
try
{
conn = DLLPerson.GetConnection();
}
catch (Exception ex)
{
throw ex;
return(null);
}
try
{
DataRow row = DLLPerson.GetPersonWithPersonnelAttributeByID(conn, personID).Rows[0];
ATTPerson person = new ATTPerson();
person.PId = double.Parse(row["P_ID"].ToString());
person.FirstName = row["FIRST_NAME"].ToString();
person.MidName = row["MID_NAME"].ToString();
person.SurName = row["SUR_NAME"].ToString();
person.Gender = row["GENDER"].ToString();
person.DOB = row["DOB"].ToString();
person.MaritalStatus = row["MARTIAL_STATUS"].ToString();
person.CountryId = row["country_id"] == System.DBNull.Value ? (int?)null : int.Parse(row["country_id"].ToString());
person.BirthDistrict = row["birth_district"] == System.DBNull.Value ? (int?)null : int.Parse(row["birth_district"].ToString());
person.ReligionId = row["religion_id"] == System.DBNull.Value ? (int?)null : int.Parse(row["religion_id"].ToString());
person.Photo = row["p_photo"] as byte[];
person.LstPersonAddress = BLLPersonAddress.GetPersonAddress(conn, personID);
person.LstPersonPhone = BLLPersonPhone.GetPersonPhone(conn, personID);
person.LstPersonEMail = BLLPersonEMail.GetPersonEMail(conn, personID);
person.LstPersonQualification = BLLPersonQualification.GetPersonQualification(conn, personID);
//person.ls
return(person);
}
catch (Exception ex)
{
throw ex;
}
finally
{
DLLPerson.CloseConnection(conn);
}
}
void LoadEmployeePersonnelDetails(object sender, EventArgs e)
{
try
{
ATTPerson person = BLLPerson.GetPersonWithPersonnelAttributeByID(double.Parse(this.txtPersonID.Text));
this.txtFName_Rqd.Text = person.FirstName.ToString().Trim();
this.txtMName.Text = person.MidName.ToString().Trim();
this.txtSurName_Rqd.Text = person.SurName.ToString().Trim();
this.txtDOB_DT.Text = person.DOB.ToString().Trim();
if (person.Gender.ToString().Trim() != "")
{
this.ddlGender.SelectedValue = person.Gender.ToString().Trim();
}
if (person.MaritalStatus.ToString().Trim() != "")
{
this.ddlMarStatus.SelectedValue = person.MaritalStatus.ToString().Trim();
}
if (person.CountryId.ToString() != "")
{
this.ddlCountry.SelectedValue = person.CountryId.ToString();
}
if (person.BirthDistrict.ToString() != "")
{
this.ddlBirthDistrict.SelectedValue = person.BirthDistrict.ToString();
}
if (person.ReligionId.ToString() != "")
{
this.ddlReligion.SelectedValue = person.ReligionId.ToString();
}
this.LoadPersonAttributes(person);
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
public static ATTPerson GetPersonnelDetails(object obj, double personID)
{
ATTPerson person = new ATTPerson();
try
{
person.LstPersonAddress = BLLPersonAddress.GetPersonAddress(obj, personID);
person.LstPersonEMail = BLLPersonEMail.GetPersonEMail(obj, personID);
person.LstPersonPhone = BLLPersonPhone.GetPersonPhone(obj, personID);
person.LstPersonQualification = BLLPersonQualification.GetPersonQualification(obj, personID);
person.LstPersonTraining = BLLPersonTraining.GetPersonTraining(obj, personID);
person.LstPersonDocuments = BLLPersonDocuments.GetPersonDocuments(obj, personID, null);
return(person);
}
catch (Exception ex)
{
throw ex;
}
}
public static ATTPerson GetPersons(double personID, string personDocActive)
{
//List<ATTVDC> lstVDCs = new List<ATTVDC>();
ATTPerson obj = new ATTPerson();
foreach (DataRow row in DLLPerson.GetPersonDetails(personID).Rows)
{
obj.PId = double.Parse(row["P_ID"].ToString());
obj.FirstName = row["FIRST_NAME"].ToString();
obj.MidName = (row["MID_NAME"] == System.DBNull.Value) ? "" : row["MID_NAME"].ToString();
obj.SurName = row["SUR_NAME"].ToString();
obj.DOB = row["DOB"] == System.DBNull.Value ? "" : row["DOB"].ToString();
obj.Gender = row["GENDER"] == System.DBNull.Value ? "" : row["GENDER"].ToString();
obj.MaritalStatus = row["MARTIAL_STATUS"] == System.DBNull.Value ? "" : row["MARTIAL_STATUS"].ToString();
//this.ddlCountry.SelectedValue
if (row["BIRTH_DISTRICT"] == System.DBNull.Value)
{
obj.BirthDistrict = null;
}
else
{
obj.BirthDistrict = int.Parse(row["BIRTH_DISTRICT"].ToString());
}
//obj.BirthDistrict = row["BIRTH_DISTRICT"] == System.DBNull.Value ? 0 :int.Parse( row["BIRTH_DISTRICT"].ToString());
obj.ReligionId = row["RELIGION_ID"] == System.DBNull.Value ? 0 : int.Parse(row["RELIGION_ID"].ToString());
//this.txtIdentityMark.Text=objPerson.i
obj.IniType = int.Parse(row["INI_TYPE"].ToString());
obj.IniUnit = int.Parse(row["INI_UNIT"].ToString());
obj.EntityType = row["ENTITY_TYPE"].ToString();
obj.LstPersonAddress = BLLPersonAddress.GetPersonAddress(null, obj.PId);
obj.LstPersonPhone = BLLPersonPhone.GetPersonPhone(null, obj.PId);
obj.LstPersonEMail = BLLPersonEMail.GetPersonEMail(null, obj.PId);
obj.LstRelatives = BLLRelatives.GetRelatives(null, obj.PId);
obj.LstPersonDocuments = BLLPersonDocuments.GetPersonDocuments(null, obj.PId, personDocActive);
}
return(obj);
}
public static ATTLawyerPerson GetLawyerWithDetailInfoByID(double PID)
{
try
{
ATTLawyerPerson obj = new ATTLawyerPerson();
ATTPerson objPerson = BLLPerson.GetPersonWithPersonnelAttributeByID(PID);
//ATTPerson GetPersonWithPersonnelAttributeByID
obj.PId = PID;
obj.FirstName = objPerson.FirstName;
obj.MidName = objPerson.MidName;
obj.SurName = objPerson.SurName;
obj.Gender = objPerson.Gender;
obj.DOB = objPerson.DOB;
obj.MaritalStatus = objPerson.MaritalStatus;
obj.CountryId = objPerson.CountryId;
obj.BirthDistrict = objPerson.BirthDistrict;
obj.ReligionId = objPerson.ReligionId;
obj.Photo = objPerson.Photo;
obj.LstPersonAddress = objPerson.LstPersonAddress;
obj.LstPersonPhone = objPerson.LstPersonPhone;
obj.LstPersonEMail = objPerson.LstPersonEMail;
obj.LstPersonQualification = objPerson.LstPersonQualification;
obj.LstLawyer = BLLLawyer.GetLawyerDetails(PID);
return(obj);
}
catch (Exception ex)
{
throw(ex);
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
ATTFacultyMember objFacultyMember = null;
ATTParticipantPost objparticipantPost;
ATTPerson objPerson;
ATTParticipant objParticipant = null;
byte[] ImageData = new byte[0];
int? intCountryId = null;
int? intBirthDistrict = null;
int? intReligion = null;
ATTUserLogin user = (ATTUserLogin)Session["Login_User_Detail"];
string strUser = user.UserName;
int intOrgID = user.OrgID;
int intFacultyID = int.Parse(Session["FacultyID"].ToString());
if (this.txtProgramID.Text != "")
{
if (this.ddlPost.SelectedIndex == 0)
{
this.lblStatusMessage.Text = "Select Post of Participant";
this.programmaticModalPopup.Show();
return;
}
}
if (this.ddlPost.SelectedIndex > 0)
{
if (this.ddlPostLevel.SelectedIndex == 0)
{
this.lblStatusMessage.Text = "Select Post Level";
this.programmaticModalPopup.Show();
return;
}
}
try
{
if (this.ddlCountry.SelectedIndex > 0)
{
intCountryId = int.Parse(this.ddlCountry.SelectedValue.ToString());
}
if (this.ddlBirthDistrict.SelectedIndex > 0)
{
intBirthDistrict = int.Parse(this.ddlBirthDistrict.SelectedValue.ToString());
}
//Following code has been disabled since ddlReligion not required. Ashok.
//if (this.ddlReligion.SelectedIndex > 0)
// intReligion = int.Parse(this.ddlReligion.SelectedValue.ToString());
objPerson = new ATTPerson(
0,
this.txtFName_Rqd.Text.Trim(),
this.txtMName.Text.Trim(),
this.txtSurName_Rqd.Text.Trim(),
this.txtDOB.Text.Trim(),
((this.ddlGender.SelectedIndex <= 0) ? "" : (this.ddlGender.SelectedValue)),
((this.ddlMarStatus.SelectedIndex <= 0) ? "" : (this.ddlMarStatus.SelectedValue)),
this.txtFatherName.Text.Trim(),
this.txtGFatherName.Text.Trim(),
intCountryId,
intBirthDistrict,
intReligion,
user.OrgID,
104,
((Label)this.Master.FindControl("lblUsername")).Text,
DateTime.Parse(Session["EngDate"].ToString()),
ImageData,
"P"
);
if (this.txtProgramID.Text == "")
{
objFacultyMember = new ATTFacultyMember(intOrgID, intFacultyID, 0, Session["NepDate"].ToString(), "");
objFacultyMember.ObjPerson = objPerson;
}
else
{
objParticipant = new ATTParticipant(intOrgID, int.Parse(this.txtProgramID.Text.ToString()), 0, "", Session["NepDate"].ToString(), "");
objParticipant.ObjPerson = objPerson;
}
if (this.ddlPost.SelectedIndex > 0)
{
objparticipantPost = new ATTParticipantPost(0, int.Parse(ddlPost.SelectedValue.ToString()), int.Parse(ddlPostLevel.SelectedValue.ToString()), Session["NepDate"].ToString());
objparticipantPost.Action = "A";
if (this.txtProgramID.Text == "")
{
objFacultyMember.LstParticipantPost.Add(objparticipantPost);
}
else
{
objParticipant.LstParticipantPost.Add(objparticipantPost);
}
}
foreach (GridViewRow row in this.grdAddress.Rows)
{
if (CheckNullString(row.Cells[10].Text.ToString()) != "")
{
int?intDistrict = null;
int?intVDC = null;
int?intWard = null;
if (CheckNullString(row.Cells[7].Text.ToString()) != "")
{
intDistrict = int.Parse(CheckNullString(row.Cells[7].Text.ToString()));
}
if (CheckNullString(row.Cells[8].Text.ToString()) != "")
{
intVDC = int.Parse(CheckNullString(row.Cells[8].Text.ToString()));
}
if (CheckNullString(row.Cells[5].Text.ToString()) != "")
{
intWard = int.Parse(CheckNullString(row.Cells[5].Text.ToString()));
}
ATTPersonAddress PersonAddressATT = new ATTPersonAddress
(
0,
row.Cells[1].Text,
int.Parse(row.Cells[11].Text),
intDistrict,
intVDC,
intWard,
CheckNullString(row.Cells[6].Text),
CheckNullString(row.Cells[9].Text),
((Label)this.Master.FindControl("lblUsername")).Text,
DateTime.Parse(Session["EngDate"].ToString())
);
PersonAddressATT.Action = CheckNullString(row.Cells[10].Text.ToString());
objPerson.LstPersonAddress.Add(PersonAddressATT);
}
}
foreach (GridViewRow row in this.grdPhone.Rows)
{
if (CheckNullString(row.Cells[7].Text.ToString()) != "")
{
ATTPersonPhone PersonPhoneATT = new ATTPersonPhone
(
0,
row.Cells[1].Text,
int.Parse(row.Cells[3].Text),
CheckNullString(row.Cells[4].Text),
CheckNullString(row.Cells[5].Text),
CheckNullString(row.Cells[6].Text),
((Label)this.Master.FindControl("lblUsername")).Text,
DateTime.Parse(Session["EngDate"].ToString())
);
PersonPhoneATT.Action = CheckNullString(row.Cells[7].Text.ToString());
objPerson.LstPersonPhone.Add(PersonPhoneATT);
}
}
foreach (GridViewRow row in this.grdEMail.Rows)
{
if (CheckNullString(row.Cells[7].Text) != "")
{
ATTPersonEMail PersonEMailATT = new ATTPersonEMail
(
0,
row.Cells[1].Text,
int.Parse(row.Cells[3].Text),
CheckNullString(row.Cells[4].Text),
CheckNullString(row.Cells[5].Text),
CheckNullString(row.Cells[6].Text),
((Label)this.Master.FindControl("lblUsername")).Text,
DateTime.Parse(Session["EngDate"].ToString())
);
PersonEMailATT.Action = CheckNullString(row.Cells[7].Text.ToString());
objPerson.LstPersonEMail.Add(PersonEMailATT);
}
}
if (this.txtProgramID.Text == "")
{
BLLFacultyMember.SaveFacultyMember(objFacultyMember);
}
else
{
BLLParticipant.SaveParticipant(objParticipant);
}
ClearControls();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
protected void btnAddPerson_Click(object sender, EventArgs e)
{
int iniUnit = 3;
double orgID = 0;
int iniType = 9;
string strUser = "******";
List <ATTPerson> PersonLST = (string)Session["AppOrResp"] == "A" ? (List <ATTPerson>)Session["Appellant"] : (List <ATTPerson>)Session["Respondant"];
ATTPerson objPerson = new ATTPerson();
if (this.txtOrgID.Text.Trim() != "")
{
orgID = double.Parse(this.txtOrgID.Text.Trim());
}
#region "PERSONTABLE"
objPerson = new ATTPerson(orgID, this.txtOrgName_RQD.Text.Trim(),
"", "",
"", "",
"",
"", "", null, null, null,
iniUnit, iniType, strUser, DateTime.Now, new byte[0]);
//objPerson.FullName = this.txtOrgName_RQD.Text.Trim() + " " + this.txtMName.Text.Trim() + " " + this.txtSurName_Rqd.Text.Trim();
//objPerson.EntityType = "P";
#endregion
objPerson.FirstName = this.txtOrgName_RQD.Text.Trim();
// objPerson.FullName = this.txtOrgName_RQD.Text.Trim();
objPerson.IniUnit = 9;
objPerson.IniType = 9;
objPerson.EntryBy = "manoz";
objPerson.EntityType = "O";
objPerson.Photo = new byte[0];
objPerson.RegdNO = this.txtRegNo.Text.Trim();
objPerson.PanNo = this.txtPanNo.Text.Trim();
#region "ADDRESS"
int? intDistrictAddress = null;
int? intVDCAddress = null;
int? intWardAddress = null;
string strAddressAction = "";
ATTPersonAddress PersonAddressATT = null;
if (this.ddlDistrict.SelectedIndex > 0)
{
intDistrictAddress = int.Parse(this.ddlDistrict.SelectedValue);
}
if (this.ddlVDC.SelectedIndex > 0)
{
intVDCAddress = int.Parse(this.ddlVDC.SelectedValue);
}
if (this.ddlWard.SelectedIndex > 0)
{
intWardAddress = int.Parse(this.ddlWard.SelectedValue);
}
PersonAddressATT = new ATTPersonAddress
(
0, "P", 1, intDistrictAddress, intVDCAddress, intWardAddress, this.txtTole.Text.Trim(), "Y", strUser, DateTime.Now
);
if (((this.ddlDistrict.SelectedIndex > 0) || (this.txtTole.Text.Trim() != "")))
{
strAddressAction = "E";
}
if (((this.ddlDistrict.SelectedIndex > 0) || (this.txtTole.Text.Trim() != "")))
{
strAddressAction = "A";
}
if (((this.ddlDistrict.SelectedIndex <= 0) && (this.txtTole.Text.Trim() == "")))
{
strAddressAction = "D";
}
if (strAddressAction != "")
{
PersonAddressATT.Action = strAddressAction;
strAddressAction = "";
objPerson.LstPersonAddress.Add(PersonAddressATT);
}
strAddressAction = "";
intDistrictAddress = null;
intVDCAddress = null;
intWardAddress = null;
#endregion
#region "PHONE"
foreach (GridViewRow row in this.grdPhone.Rows)
{
if (CheckNull.NullString(row.Cells[7].Text.ToString()) != "")
{
ATTPersonPhone PersonPhoneATT = new ATTPersonPhone(0, row.Cells[1].Text, int.Parse(row.Cells[3].Text.ToString()),
CheckNull.NullString(row.Cells[4].Text.ToString()), CheckNull.NullString(row.Cells[5].Text.ToString()),
CheckNull.NullString(row.Cells[6].Text.ToString()), strUser, DateTime.Now);
PersonPhoneATT.Action = CheckNull.NullString(row.Cells[7].Text.ToString());
objPerson.LstPersonPhone.Add(PersonPhoneATT);
}
}
#endregion
#region "EMAIL"
foreach (GridViewRow row in this.grdEMail.Rows)
{
if (CheckNull.NullString(row.Cells[7].Text.ToString()) != "")
{
ATTPersonEMail PersonEMailATT = new ATTPersonEMail(0, row.Cells[1].Text, int.Parse(row.Cells[3].Text.ToString()),
CheckNull.NullString(row.Cells[4].Text.ToString()), CheckNull.NullString(row.Cells[5].Text.ToString()),
CheckNull.NullString(row.Cells[6].Text.ToString()), strUser, DateTime.Now);
PersonEMailATT.Action = CheckNull.NullString(row.Cells[7].Text.ToString());
objPerson.LstPersonEMail.Add(PersonEMailATT);
}
}
#endregion
PersonLST.Add(objPerson);
if ((string)Session["AppOrResp"] == "A")
{
Session["Appellant"] = PersonLST;
}
else
{
Session["Respondant"] = PersonLST;
}
this.grdPerson.DataSource = PersonLST;
this.grdPerson.DataBind();
//this.
}
protected void btnAddPerson_Click(object sender, EventArgs e)
{
if (txtFromDate_RQD.Text == "")
{
this.lblStatusMessage.Text = "Enter From Date First";
this.programmaticModalPopup.Show();
return;
}
int iniUnit = 3;
double empID = 0;
int iniType = 9;
int? intCountryId = null;
int? intBirthDistrict = null;
int? intReligion = null;
ATTPerson objPerson = new ATTPerson();
if (this.txtPersonID.Text.Trim() != "")
{
empID = double.Parse(this.txtPersonID.Text.Trim());
}
if (this.ddlCountry.SelectedIndex > 0)
{
intCountryId = int.Parse(this.ddlCountry.SelectedValue.ToString());
}
if (this.ddlBirthDistrict.SelectedIndex > 0)
{
intBirthDistrict = int.Parse(this.ddlBirthDistrict.SelectedValue.ToString());
}
if (this.ddlReligion.SelectedIndex > 0)
{
intReligion = int.Parse(this.ddlReligion.SelectedValue.ToString());
}
#region "PERSONTABLE"
objPerson = new ATTPerson(empID, this.txtFName_Rqd.Text.Trim(),
this.txtMName.Text.Trim(), this.txtSurName_Rqd.Text.Trim(),
this.txtDOB_DT.Text.Trim(), ((this.ddlGender.SelectedIndex <= 0) ? "" : (this.ddlGender.SelectedValue)),
((this.ddlMarStatus.SelectedIndex <= 0) ? "" : (this.ddlMarStatus.SelectedValue)),
"", "", intCountryId, intBirthDistrict, intReligion,
iniUnit, iniType, strUser, DateTime.Now, new byte[0]);
//objPerson.FullName = this.txtFName_Rqd.Text.Trim() + " " + this.txtMName.Text.Trim() + " " + this.txtSurName_Rqd.Text.Trim();
objPerson.EntityType = "P";
#endregion
#region "ADDRESS"
int? intDistrictAddress = null;
int? intVDCAddress = null;
int? intWardAddress = null;
string strAddressAction = "";
ATTPersonAddress PersonAddressATT = null;
if (this.ddlDistrict.SelectedIndex > 0)
{
intDistrictAddress = int.Parse(this.ddlDistrict.SelectedValue);
}
if (this.ddlVDC.SelectedIndex > 0)
{
intVDCAddress = int.Parse(this.ddlVDC.SelectedValue);
}
if (this.ddlWard.SelectedIndex > 0)
{
intWardAddress = int.Parse(this.ddlWard.SelectedValue);
}
PersonAddressATT = new ATTPersonAddress
(
0, "P", 1, intDistrictAddress, intVDCAddress, intWardAddress, this.txtTole.Text.Trim(), "Y", strUser, DateTime.Now
);
if (((this.ddlDistrict.SelectedIndex > 0) || (this.txtTole.Text.Trim() != "")) && (hdnPerAddress.Value != "0"))
{
strAddressAction = "E";
}
if (((this.ddlDistrict.SelectedIndex > 0) || (this.txtTole.Text.Trim() != "")) && (hdnPerAddress.Value == "0"))
{
strAddressAction = "A";
}
// if (((this.ddlDistrict.SelectedIndex <= 0) && (this.txtTole.Text.Trim() == "")) && (hdnPerAddress.Value != "0")) strAddressAction = "D";
if (strAddressAction != "")
{
PersonAddressATT.Action = strAddressAction;
strAddressAction = "";
objPerson.LstPersonAddress.Add(PersonAddressATT);
}
strAddressAction = "";
intDistrictAddress = null;
intVDCAddress = null;
intWardAddress = null;
if (this.ddlDistrictTemp.SelectedIndex > 0)
{
intDistrictAddress = int.Parse(this.ddlDistrictTemp.SelectedValue);
}
if (this.ddlVDCTemp.SelectedIndex > 0)
{
intVDCAddress = int.Parse(this.ddlVDCTemp.SelectedValue);
}
if (this.ddlWardTemp.SelectedIndex > 0)
{
intWardAddress = int.Parse(this.ddlWardTemp.SelectedValue);
}
PersonAddressATT = new ATTPersonAddress
(
0, "T", 1, intDistrictAddress, intVDCAddress, intWardAddress, this.txtToleTemp.Text.Trim(), "Y", strUser, DateTime.Now
);
if (((this.ddlDistrictTemp.SelectedIndex > 0) || (this.txtToleTemp.Text.Trim() != "")) && (hdnTempAddress.Value != "0"))
{
strAddressAction = "E";
}
if (((this.ddlDistrictTemp.SelectedIndex > 0) || (this.txtToleTemp.Text.Trim() != "")) && (hdnTempAddress.Value == "0"))
{
strAddressAction = "A";
}
//if (((this.ddlDistrictTemp.SelectedIndex <= 0) && (this.txtToleTemp.Text.Trim() == "")) && (hdnTempAddress.Value != "0")) strAddressAction = "D";
if (strAddressAction != "")
{
PersonAddressATT.Action = strAddressAction;
strAddressAction = "";
objPerson.LstPersonAddress.Add(PersonAddressATT);
}
#endregion
#region "PHONE"
foreach (GridViewRow row in this.grdPhone.Rows)
{
if (CheckNull.NullString(row.Cells[7].Text.ToString()) != "")
{
ATTPersonPhone PersonPhoneATT = new ATTPersonPhone(0, row.Cells[1].Text, int.Parse(row.Cells[3].Text.ToString()),
CheckNull.NullString(row.Cells[4].Text.ToString()), CheckNull.NullString(row.Cells[5].Text.ToString()),
CheckNull.NullString(row.Cells[6].Text.ToString()), strUser, DateTime.Now);
PersonPhoneATT.Action = CheckNull.NullString(row.Cells[7].Text.ToString());
objPerson.LstPersonPhone.Add(PersonPhoneATT);
}
}
#endregion
#region "EMAIL"
foreach (GridViewRow row in this.grdEMail.Rows)
{
if (CheckNull.NullString(row.Cells[7].Text.ToString()) != "")
{
ATTPersonEMail PersonEMailATT = new ATTPersonEMail(0, row.Cells[1].Text, int.Parse(row.Cells[3].Text.ToString()),
CheckNull.NullString(row.Cells[4].Text.ToString()), CheckNull.NullString(row.Cells[5].Text.ToString()),
CheckNull.NullString(row.Cells[6].Text.ToString()), strUser, DateTime.Now);
PersonEMailATT.Action = CheckNull.NullString(row.Cells[7].Text.ToString());
objPerson.LstPersonEMail.Add(PersonEMailATT);
}
}
#endregion
#region "RELATIVES AND BENEFICIARIES"
//foreach (GridViewRow row in this.grdEmpRelatives.Rows)
//{
// int? countryID = null;
// int? birthDistrict = null;
// int? religionID = null;
// if ( CheckNull.NullString(row.Cells[11].Text) != "")
// birthDistrict = int.Parse(row.Cells[11].Text);
// byte[] RelativeImageData = new byte[0];
// ATTPerson objRelativePerson = new ATTPerson
// (double.Parse(row.Cells[1].Text), row.Cells[2].Text, CheckNull.NullString(row.Cells[3].Text), CheckNull.NullString(row.Cells[4].Text),
// CheckNull.NullString(row.Cells[8].Text), CheckNull.NullString(row.Cells[6].Text), CheckNull.NullString(row.Cells[9].Text), "", "",
// countryID, birthDistrict, religionID, iniUnit, iniType, strUser, DateTime.Now, RelativeImageData);
// CheckBox cb = (CheckBox)row.Cells[17].FindControl("chkRelativeActive");
// CheckBox cbIsBen = (CheckBox)row.Cells[16].FindControl("chkIsBeneficiary");
// CheckBox cbWasBen = (CheckBox)row.Cells[20].FindControl("chkWasBeneficiary");
// ATTEmployeeBeneficiary EmpBeneficiaryATT = new ATTEmployeeBeneficiary(0, 0, null, null);
// if ((cbIsBen.Checked) && (!cbWasBen.Checked))
// EmpBeneficiaryATT.Action = "A";
// else if ((!cbIsBen.Checked) && (cbWasBen.Checked))
// {
// EmpBeneficiaryATT.Action = "E";
// EmpBeneficiaryATT.ToDate = DateTime.Now.Date.ToString("dd/MM/yyyy");
// }
// EmpBeneficiaryATT.EntryBy = strUser;
// ATTRelatives RelativesATT = new ATTRelatives(0, 0, int.Parse(row.Cells[13].Text), (cb.Checked ? "Y" : "N"));
// RelativesATT.Occupation = CheckNull.NullString(row.Cells[15].Text);
// RelativesATT.EntryBy = strUser;
// if ( CheckNull.NullString(row.Cells[18].Text) == "A")
// RelativesATT.Action = "A";
// else
// RelativesATT.Action = "E";
// RelativesATT.ObjPerson = objRelativePerson;
// EmpBeneficiaryATT.ObjRelatives = RelativesATT;
// objEmployee.LstEmployeeBeneficiary.Add(EmpBeneficiaryATT);
//}
#endregion
List <ATTWitnessSearch> WSearchLST = (List <ATTWitnessSearch>)Session["WSearch"];
ATTWitnessSearch objWSearch = new ATTWitnessSearch();
ATTWitnessPerson objCaesAndlitigant = (ATTWitnessPerson)Session["CaseAndLitigant"];//brought from witness person form caseID and litigantId
List <ATTWitnessSearch> PersonList = new List <ATTWitnessSearch>();
objWSearch.CaseID = objCaesAndlitigant.CaseID;
objWSearch.LItigantID = objCaesAndlitigant.LitigantID;
objWSearch.PersonID = 0;
objWSearch.WitnessID = 0;
objWSearch.WitnessName = this.txtFName_Rqd.Text.Trim() + " " + this.txtMName.Text.Trim() + " " + this.txtSurName_Rqd.Text.Trim();
objWSearch.FromDate = this.txtFromDate_RQD.Text;
objWSearch.Action = "A";
objWSearch.ObjPerson = objPerson;
WSearchLST.Add(objWSearch);
PersonList.Add(objWSearch);
Session["WSearch"] = WSearchLST;
this.grdPerson.DataSource = PersonList;
this.grdPerson.DataBind();
ClearControls();
}
protected void btnOK_Click(object sender, EventArgs e)
{
ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]);
int iniUnit = 9;
double empID = 0;
int iniType = 5;//Application ID
int? intCountryId = null;
int? intBirthDistrict = null;
int? intReligion = null;
string strUser = "******"; //user.UserName;
List <ATTPerson> PersonLST = new List <ATTPerson>();
ATTPerson objPerson = new ATTPerson();
if (this.txtPersonID.Text.Trim() != "")
{
empID = double.Parse(this.txtPersonID.Text.Trim());
}
if (this.ddlCountry.SelectedIndex > 0)
{
intCountryId = int.Parse(this.ddlCountry.SelectedValue.ToString());
}
if (this.ddlBirthDistrict.SelectedIndex > 0)
{
intBirthDistrict = int.Parse(this.ddlBirthDistrict.SelectedValue.ToString());
}
if (this.ddlReligion.SelectedIndex > 0)
{
intReligion = int.Parse(this.ddlReligion.SelectedValue.ToString());
}
#region "PERSONTABLE"
objPerson = new ATTPerson
(
empID,
this.txtFName_Rqd.Text.Trim(),
this.txtMName.Text.Trim(),
this.txtSurName_Rqd.Text.Trim(),
this.txtDOB_DT.Text.Trim(),
((this.ddlGender.SelectedIndex <= 0) ? "" : (this.ddlGender.SelectedValue)),
((this.ddlMarStatus.SelectedIndex <= 0) ? "" : (this.ddlMarStatus.SelectedValue)),
"",
"",
intCountryId,
intBirthDistrict,
intReligion,
iniUnit,
iniType,
strUser,
DateTime.Now,
new byte[0]
);
objPerson.FullName = this.txtFName_Rqd.Text.Trim() + " " + this.txtMName.Text.Trim() + " " + this.txtSurName_Rqd.Text.Trim();
objPerson.EntityType = "P";
#endregion
#region "ADDRESS"
int? intDistrictAddress = null;
int? intVDCAddress = null;
int? intWardAddress = null;
string strAddressAction = "";
ATTPersonAddress PersonAddressATT = null;
if (this.ddlDistrict.SelectedIndex > 0)
{
intDistrictAddress = int.Parse(this.ddlDistrict.SelectedValue);
}
if (this.ddlVDC.SelectedIndex > 0)
{
intVDCAddress = int.Parse(this.ddlVDC.SelectedValue);
}
if (this.ddlWard.SelectedIndex > 0)
{
intWardAddress = int.Parse(this.ddlWard.SelectedValue);
}
PersonAddressATT = new ATTPersonAddress
(
0, "P", int.Parse(hdnPerAddress.Value.ToString()), intDistrictAddress, intVDCAddress, intWardAddress, this.txtTole.Text.Trim(), "Y", strUser, DateTime.Now
);
if (((this.ddlDistrict.SelectedIndex > 0) || (this.txtTole.Text.Trim() != "")) && (hdnPerAddress.Value != "0"))
{
strAddressAction = "E";
}
if (((this.ddlDistrict.SelectedIndex > 0) || (this.txtTole.Text.Trim() != "")) && (hdnPerAddress.Value == "0"))
{
strAddressAction = "A";
}
if (((this.ddlDistrict.SelectedIndex <= 0) && (this.txtTole.Text.Trim() == "")) && (hdnPerAddress.Value != "0"))
{
strAddressAction = "D";
}
if (strAddressAction != "")
{
PersonAddressATT.Action = strAddressAction;
strAddressAction = "";
objPerson.LstPersonAddress.Add(PersonAddressATT);
}
strAddressAction = "";
intDistrictAddress = null;
intVDCAddress = null;
intWardAddress = null;
if (this.ddlDistrictTemp.SelectedIndex > 0)
{
intDistrictAddress = int.Parse(this.ddlDistrictTemp.SelectedValue);
}
if (this.ddlVDCTemp.SelectedIndex > 0)
{
intVDCAddress = int.Parse(this.ddlVDCTemp.SelectedValue);
}
if (this.ddlWardTemp.SelectedIndex > 0)
{
intWardAddress = int.Parse(this.ddlWardTemp.SelectedValue);
}
PersonAddressATT = new ATTPersonAddress
(
0, "T", int.Parse(hdnTempAddress.Value.ToString()), intDistrictAddress, intVDCAddress, intWardAddress, this.txtToleTemp.Text.Trim(), "Y", strUser, DateTime.Now
);
if (((this.ddlDistrictTemp.SelectedIndex > 0) || (this.txtToleTemp.Text.Trim() != "")) && (hdnTempAddress.Value != "0"))
{
strAddressAction = "E";
}
if (((this.ddlDistrictTemp.SelectedIndex > 0) || (this.txtToleTemp.Text.Trim() != "")) && (hdnTempAddress.Value == "0"))
{
strAddressAction = "A";
}
if (((this.ddlDistrictTemp.SelectedIndex <= 0) && (this.txtToleTemp.Text.Trim() == "")) && (hdnTempAddress.Value != "0"))
{
strAddressAction = "D";
}
if (strAddressAction != "")
{
PersonAddressATT.Action = strAddressAction;
strAddressAction = "";
objPerson.LstPersonAddress.Add(PersonAddressATT);
}
#endregion
#region "PHONE"
foreach (GridViewRow row in this.grdPhone.Rows)
{
if (CheckNull.NullString(row.Cells[7].Text.ToString()) != "")
{
ATTPersonPhone PersonPhoneATT = new ATTPersonPhone(0, row.Cells[1].Text, int.Parse(row.Cells[3].Text.ToString()),
CheckNull.NullString(row.Cells[4].Text.ToString()), CheckNull.NullString(row.Cells[5].Text.ToString()),
CheckNull.NullString(row.Cells[6].Text.ToString()), strUser, DateTime.Now);
PersonPhoneATT.Action = CheckNull.NullString(row.Cells[7].Text.ToString());
objPerson.LstPersonPhone.Add(PersonPhoneATT);
}
}
#endregion
#region "EMAIL"
foreach (GridViewRow row in this.grdEMail.Rows)
{
if (CheckNull.NullString(row.Cells[7].Text.ToString()) != "")
{
ATTPersonEMail PersonEMailATT = new ATTPersonEMail(0, row.Cells[1].Text, int.Parse(row.Cells[3].Text.ToString()),
CheckNull.NullString(row.Cells[4].Text.ToString()), CheckNull.NullString(row.Cells[5].Text.ToString()),
CheckNull.NullString(row.Cells[6].Text.ToString()), strUser, DateTime.Now);
PersonEMailATT.Action = CheckNull.NullString(row.Cells[7].Text.ToString());
objPerson.LstPersonEMail.Add(PersonEMailATT);
}
}
#endregion
PersonLST.Add(objPerson);
try
{
BLLPerson.SavePerson(PersonLST);
this.ClearME();
this.lblStatusMessage.Text = "Person has been saved successfully.";
this.programmaticModalPopup.Show();
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
void LoadPersonAttributes(ATTPerson person)
{
try
{
if (person.LstPersonAddress.Count > 0)
{
foreach (ATTPersonAddress PersonAddress in person.LstPersonAddress)
{
if (PersonAddress.AdTypeId == "P")
{
//ClearAddressControls("P");
this.hdnPerAddress.Value = PersonAddress.AdSNo.ToString();
this.imgDelPerAddress.Visible = true;
if (PersonAddress.District != null)
{
this.ddlDistrict.SelectedValue = PersonAddress.District.ToString();
this.ddlDistrict_SelectedIndexChanged(new object(), new EventArgs());
if (PersonAddress.VDC != null)
{
this.ddlVDC.SelectedValue = PersonAddress.VDC.ToString();
this.ddlVDC_SelectedIndexChanged(new object(), new EventArgs());
if (PersonAddress.Ward != null)
{
this.ddlWard.SelectedValue = PersonAddress.Ward.ToString();
}
}
}
this.txtTole.Text = PersonAddress.Tole.Trim();
}
else if (PersonAddress.AdTypeId == "T")
{
//ClearAddressControls("T");
this.hdnTempAddress.Value = PersonAddress.AdSNo.ToString();
this.imgDelTempAddress.Visible = true;
if (PersonAddress.District != null)
{
this.ddlDistrictTemp.SelectedValue = PersonAddress.District.ToString();
this.ddlDistrictTemp_SelectedIndexChanged(new object(), new EventArgs());
if (PersonAddress.VDC != null)
{
this.ddlVDCTemp.SelectedValue = PersonAddress.VDC.ToString();
this.ddlVDCTemp_SelectedIndexChanged(new object(), new EventArgs());
if (PersonAddress.Ward != null)
{
this.ddlWardTemp.SelectedValue = PersonAddress.Ward.ToString();
}
}
}
this.txtToleTemp.Text = PersonAddress.Tole.Trim();
}
}
}
if (person.LstPersonPhone.Count > 0)
{
Session["PhoneTbl"] = GenericListToDataTable(person.LstPersonPhone);
this.grdPhone.DataSource = Session["PhoneTbl"];
this.grdPhone.DataBind();
}
if (person.LstPersonEMail.Count > 0)
{
Session["EMailTbl"] = GenericListToDataTable(person.LstPersonEMail);
this.grdEMail.DataSource = Session["EMailTbl"];
this.grdEMail.DataBind();
}
}
catch (Exception ex)
{
this.lblStatusMessage.Text = ex.Message;
this.programmaticModalPopup.Show();
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
int iniUnit = 3;
double empID = 0;
int iniType = 9;
int? intCountryId = null;
int? intBirthDistrict = null;
int? intReligion = null;
List <ATTPerson> lstPerson = new List <ATTPerson>();
ATTPerson objPerson = new ATTPerson();
if (this.txtPersonID.Text.Trim() != "")
{
empID = double.Parse(this.txtPersonID.Text.Trim());
}
if (this.ddlCountry.SelectedIndex > 0)
{
intCountryId = int.Parse(this.ddlCountry.SelectedValue.ToString());
}
if (this.ddlBirthDistrict.SelectedIndex > 0)
{
intBirthDistrict = int.Parse(this.ddlBirthDistrict.SelectedValue.ToString());
}
if (this.ddlReligion.SelectedIndex > 0)
{
intReligion = int.Parse(this.ddlReligion.SelectedValue.ToString());
}
#region "PERSONTABLE"
objPerson = new ATTPerson(empID, this.txtFName_Rqd.Text.Trim(),
this.txtMName.Text.Trim(), this.txtSurName_Rqd.Text.Trim(),
this.txtDOB_DT.Text.Trim(), ((this.ddlGender.SelectedIndex <= 0) ? "" : (this.ddlGender.SelectedValue)),
((this.ddlMarStatus.SelectedIndex <= 0) ? "" : (this.ddlMarStatus.SelectedValue)),
"", "", intCountryId, intBirthDistrict, intReligion,
iniUnit, iniType, strUser, DateTime.Now, new byte[0]);
//objPerson.FullName = this.txtFName_Rqd.Text.Trim() + " " + this.txtMName.Text.Trim() + " " + this.txtSurName_Rqd.Text.Trim();
objPerson.EntityType = "P";
#endregion
#region "ADDRESS"
int? intDistrictAddress = null;
int? intVDCAddress = null;
int? intWardAddress = null;
string strAddressAction = "";
ATTPersonAddress PersonAddressATT = null;
if (this.ddlDistrict.SelectedIndex > 0)
{
intDistrictAddress = int.Parse(this.ddlDistrict.SelectedValue);
}
if (this.ddlVDC.SelectedIndex > 0)
{
intVDCAddress = int.Parse(this.ddlVDC.SelectedValue);
}
if (this.ddlWard.SelectedIndex > 0)
{
intWardAddress = int.Parse(this.ddlWard.SelectedValue);
}
PersonAddressATT = new ATTPersonAddress
(
0, "P", 1, intDistrictAddress, intVDCAddress, intWardAddress, this.txtTole.Text.Trim(), "Y", strUser, DateTime.Now
);
//if (((this.ddlDistrict.SelectedIndex > 0) || (this.txtTole.Text.Trim() != "")) && (hdnPerAddress.Value != "0")) strAddressAction = "E";
//if (((this.ddlDistrict.SelectedIndex > 0) || (this.txtTole.Text.Trim() != "")) && (hdnPerAddress.Value == "0")) strAddressAction = "A";
//// if (((this.ddlDistrict.SelectedIndex <= 0) && (this.txtTole.Text.Trim() == "")) && (hdnPerAddress.Value != "0")) strAddressAction = "D";
strAddressAction = "A";
if (strAddressAction != "")
{
PersonAddressATT.Action = strAddressAction;
strAddressAction = "";
objPerson.LstPersonAddress.Add(PersonAddressATT);
}
strAddressAction = "";
intDistrictAddress = null;
intVDCAddress = null;
intWardAddress = null;
strAddressAction = "A";
if (this.ddlDistrictTemp.SelectedIndex > 0)
{
intDistrictAddress = int.Parse(this.ddlDistrictTemp.SelectedValue);
}
if (this.ddlVDCTemp.SelectedIndex > 0)
{
intVDCAddress = int.Parse(this.ddlVDCTemp.SelectedValue);
}
if (this.ddlWardTemp.SelectedIndex > 0)
{
intWardAddress = int.Parse(this.ddlWardTemp.SelectedValue);
}
PersonAddressATT = new ATTPersonAddress
(
0, "T", 1, intDistrictAddress, intVDCAddress, intWardAddress, this.txtToleTemp.Text.Trim(), "Y", strUser, DateTime.Now
);
//if (((this.ddlDistrictTemp.SelectedIndex > 0) || (this.txtToleTemp.Text.Trim() != "")) && (hdnTempAddress.Value != "0")) strAddressAction = "E";
// if (((this.ddlDistrictTemp.SelectedIndex > 0) || (this.txtToleTemp.Text.Trim() != "")) && (hdnTempAddress.Value == "0")) strAddressAction = "A";
//if (((this.ddlDistrictTemp.SelectedIndex <= 0) && (this.txtToleTemp.Text.Trim() == "")) && (hdnTempAddress.Value != "0")) strAddressAction = "D";
strAddressAction = "A";
if (strAddressAction != "")
{
PersonAddressATT.Action = strAddressAction;
strAddressAction = "";
objPerson.LstPersonAddress.Add(PersonAddressATT);
}
#endregion
#region "PHONE"
foreach (GridViewRow row in this.grdPhone.Rows)
{
if (CheckNull.NullString(row.Cells[7].Text.ToString()) != "")
{
ATTPersonPhone PersonPhoneATT = new ATTPersonPhone(0, row.Cells[1].Text, int.Parse(row.Cells[3].Text.ToString()),
CheckNull.NullString(row.Cells[4].Text.ToString()), CheckNull.NullString(row.Cells[5].Text.ToString()),
CheckNull.NullString(row.Cells[6].Text.ToString()), strUser, DateTime.Now);
PersonPhoneATT.Action = CheckNull.NullString(row.Cells[7].Text.ToString());
objPerson.LstPersonPhone.Add(PersonPhoneATT);
}
}
#endregion
#region "EMAIL"
foreach (GridViewRow row in this.grdEMail.Rows)
{
if (CheckNull.NullString(row.Cells[7].Text.ToString()) != "")
{
ATTPersonEMail PersonEMailATT = new ATTPersonEMail(0, row.Cells[1].Text, int.Parse(row.Cells[3].Text.ToString()),
CheckNull.NullString(row.Cells[4].Text.ToString()), CheckNull.NullString(row.Cells[5].Text.ToString()),
CheckNull.NullString(row.Cells[6].Text.ToString()), strUser, DateTime.Now);
PersonEMailATT.Action = CheckNull.NullString(row.Cells[7].Text.ToString());
objPerson.LstPersonEMail.Add(PersonEMailATT);
}
}
#endregion
//lstPerson.Add(objPerson);
double PersonID = 0;
if (this.txtPersonID.Text.Trim() != "")
{
PersonID = double.Parse(this.txtPersonID.Text.Trim());
}
lstPerson.Add(objPerson);
if (lstPerson.Count > 0)
{
Session["MelMilaapKartaaInfo"] = lstPerson;
// Session["PersonID"] = objPerson.PId;
ClearControls();
Response.Redirect("MelMilaapKartaa.aspx");
}
else
{
lblStatusMessage.Text = "Person List doesn't contain information";
programmaticModalPopup.Show();
return;
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
int iniUnit = 3;
double empID = 0;
int iniType = 9;
int? intCountryId = null;
int? intBirthDistrict = null;
int? intReligion = null;
List <ATTPerson> lstPerson = new List <ATTPerson>();
ATTPerson objPerson = new ATTPerson();
if (this.txtPersonID.Text.Trim() != "")
{
empID = double.Parse(this.txtPersonID.Text.Trim());
}
if (this.ddlCountry.SelectedIndex > 0)
{
intCountryId = int.Parse(this.ddlCountry.SelectedValue.ToString());
}
if (this.ddlBirthDistrict.SelectedIndex > 0)
{
intBirthDistrict = int.Parse(this.ddlBirthDistrict.SelectedValue.ToString());
}
if (this.ddlReligion.SelectedIndex > 0)
{
intReligion = int.Parse(this.ddlReligion.SelectedValue.ToString());
}
#region "PERSONTABLE"
objPerson = new ATTPerson(empID, this.txtFName_Rqd.Text.Trim(),
this.txtMName.Text.Trim(), this.txtSurName_Rqd.Text.Trim(),
this.txtDOB_DT.Text.Trim(), ((this.ddlGender.SelectedIndex <= 0) ? "" : (this.ddlGender.SelectedValue)),
((this.ddlMarStatus.SelectedIndex <= 0) ? "" : (this.ddlMarStatus.SelectedValue)),
"", "", intCountryId, intBirthDistrict, intReligion,
iniUnit, iniType, strUser, DateTime.Now, new byte[0]);
//objPerson.FullName = this.txtFName_Rqd.Text.Trim() + " " + this.txtMName.Text.Trim() + " " + this.txtSurName_Rqd.Text.Trim();
objPerson.EntityType = "P";
#endregion
#region "ADDRESS"
int? intDistrictAddress = null;
int? intVDCAddress = null;
int? intWardAddress = null;
string strAddressAction = "";
ATTPersonAddress PersonAddressATT = null;
if (this.ddlDistrict.SelectedIndex > 0)
{
intDistrictAddress = int.Parse(this.ddlDistrict.SelectedValue);
}
if (this.ddlVDC.SelectedIndex > 0)
{
intVDCAddress = int.Parse(this.ddlVDC.SelectedValue);
}
if (this.ddlWard.SelectedIndex > 0)
{
intWardAddress = int.Parse(this.ddlWard.SelectedValue);
}
PersonAddressATT = new ATTPersonAddress
(
0, "P", 1, intDistrictAddress, intVDCAddress, intWardAddress, this.txtTole.Text.Trim(), "Y", strUser, DateTime.Now
);
if (((this.ddlDistrict.SelectedIndex > 0) || (this.txtTole.Text.Trim() != "")) && (hdnPerAddress.Value != "0"))
{
strAddressAction = "E";
}
if (((this.ddlDistrict.SelectedIndex > 0) || (this.txtTole.Text.Trim() != "")) && (hdnPerAddress.Value == "0"))
{
strAddressAction = "A";
}
// if (((this.ddlDistrict.SelectedIndex <= 0) && (this.txtTole.Text.Trim() == "")) && (hdnPerAddress.Value != "0")) strAddressAction = "D";
if (strAddressAction != "")
{
PersonAddressATT.Action = strAddressAction;
strAddressAction = "";
objPerson.LstPersonAddress.Add(PersonAddressATT);
}
strAddressAction = "";
intDistrictAddress = null;
intVDCAddress = null;
intWardAddress = null;
if (this.ddlDistrictTemp.SelectedIndex > 0)
{
intDistrictAddress = int.Parse(this.ddlDistrictTemp.SelectedValue);
}
if (this.ddlVDCTemp.SelectedIndex > 0)
{
intVDCAddress = int.Parse(this.ddlVDCTemp.SelectedValue);
}
if (this.ddlWardTemp.SelectedIndex > 0)
{
intWardAddress = int.Parse(this.ddlWardTemp.SelectedValue);
}
PersonAddressATT = new ATTPersonAddress
(
0, "T", 1, intDistrictAddress, intVDCAddress, intWardAddress, this.txtToleTemp.Text.Trim(), "Y", strUser, DateTime.Now
);
if (((this.ddlDistrictTemp.SelectedIndex > 0) || (this.txtToleTemp.Text.Trim() != "")) && (hdnTempAddress.Value != "0"))
{
strAddressAction = "E";
}
if (((this.ddlDistrictTemp.SelectedIndex > 0) || (this.txtToleTemp.Text.Trim() != "")) && (hdnTempAddress.Value == "0"))
{
strAddressAction = "A";
}
//if (((this.ddlDistrictTemp.SelectedIndex <= 0) && (this.txtToleTemp.Text.Trim() == "")) && (hdnTempAddress.Value != "0")) strAddressAction = "D";
if (strAddressAction != "")
{
PersonAddressATT.Action = strAddressAction;
strAddressAction = "";
objPerson.LstPersonAddress.Add(PersonAddressATT);
}
#endregion
#region "PHONE"
foreach (GridViewRow row in this.grdPhone.Rows)
{
if (CheckNull.NullString(row.Cells[7].Text.ToString()) != "")
{
ATTPersonPhone PersonPhoneATT = new ATTPersonPhone(0, row.Cells[1].Text, int.Parse(row.Cells[3].Text.ToString()),
CheckNull.NullString(row.Cells[4].Text.ToString()), CheckNull.NullString(row.Cells[5].Text.ToString()),
CheckNull.NullString(row.Cells[6].Text.ToString()), strUser, DateTime.Now);
PersonPhoneATT.Action = CheckNull.NullString(row.Cells[7].Text.ToString());
objPerson.LstPersonPhone.Add(PersonPhoneATT);
}
}
#endregion
#region "EMAIL"
foreach (GridViewRow row in this.grdEMail.Rows)
{
if (CheckNull.NullString(row.Cells[7].Text.ToString()) != "")
{
ATTPersonEMail PersonEMailATT = new ATTPersonEMail(0, row.Cells[1].Text, int.Parse(row.Cells[3].Text.ToString()),
CheckNull.NullString(row.Cells[4].Text.ToString()), CheckNull.NullString(row.Cells[5].Text.ToString()),
CheckNull.NullString(row.Cells[6].Text.ToString()), strUser, DateTime.Now);
PersonEMailATT.Action = CheckNull.NullString(row.Cells[7].Text.ToString());
objPerson.LstPersonEMail.Add(PersonEMailATT);
}
}
#endregion
lstPerson.Add(objPerson);
if (BLLPerson.SavePerson(lstPerson))
{
Session["PersonName"] = lstPerson[0].FullName;
Session["PersonID"] = double.Parse(lstPerson[0].PId.ToString());
ClearControls();
}
// btnOK.Attributes.Add("OnClick", "self.close()");
}
public static double AddPersonnelDetails(ATTPerson objPerson, OracleTransaction Tran)
{
double personID = 0;
try
{
OracleParameter[] paramArray = new OracleParameter[17];
paramArray[0] = Utilities.GetOraParam(":p_P_ID", objPerson.PId, OracleDbType.Double, ParameterDirection.InputOutput);
paramArray[1] = Utilities.GetOraParam(":p_FIRST_NAME", objPerson.FirstName, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[2] = Utilities.GetOraParam(":p_MID_NAME", objPerson.MidName, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[3] = Utilities.GetOraParam(":p_SUR_NAME", objPerson.SurName, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[4] = Utilities.GetOraParam(":p_DOB", objPerson.DOB, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[5] = Utilities.GetOraParam(":p_GENDER", objPerson.Gender, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[6] = Utilities.GetOraParam(":p_MARTIAL_STATUS", objPerson.MaritalStatus, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[7] = Utilities.GetOraParam(":p_FATHER_NAME", objPerson.FatherName, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[8] = Utilities.GetOraParam(":p_GFATHER_NAME", objPerson.GFatherName, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[9] = Utilities.GetOraParam(":p_COUNTRY_ID", objPerson.CountryId, OracleDbType.Int64, ParameterDirection.Input);
paramArray[10] = Utilities.GetOraParam(":p_BIRTH_DISTRICT", objPerson.BirthDistrict, OracleDbType.Int64, ParameterDirection.Input);
paramArray[11] = Utilities.GetOraParam(":p_RELIGION_ID", objPerson.ReligionId, OracleDbType.Int64, ParameterDirection.Input);
paramArray[12] = Utilities.GetOraParam(":p_INI_UNIT", objPerson.IniUnit, OracleDbType.Int64, ParameterDirection.Input);
paramArray[13] = Utilities.GetOraParam(":p_INI_TYPE", objPerson.IniType, OracleDbType.Varchar2, ParameterDirection.Input);
paramArray[14] = Utilities.GetOraParam(":p_ENTRY_BY", objPerson.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input);
if (objPerson.Photo != null && objPerson.Photo.Length <= 0)
{
paramArray[15] = Utilities.GetOraParam(":p_PHOTO", null, OracleDbType.Blob, ParameterDirection.Input);
}
else
{
paramArray[15] = Utilities.GetOraParam(":p_PHOTO", objPerson.Photo, OracleDbType.Blob, ParameterDirection.Input);
}
paramArray[16] = Utilities.GetOraParam(":p_ENTITY_TYPE", objPerson.EntityType, OracleDbType.Varchar2, ParameterDirection.Input);
if (objPerson.PId == 0)
{
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, "SP_ADD_PERSONS", paramArray[0], paramArray);
}
else if (objPerson.PId > 0)
{
SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, "SP_EDIT_PERSONS", paramArray[0], paramArray);
}
personID = double.Parse(paramArray[0].Value.ToString());
if (objPerson.LstPersonAddress.Count > 0)
{
DLLPersonAddress.AddPersonAddress(objPerson.LstPersonAddress, Tran, personID);
}
if (objPerson.LstPersonPhone.Count > 0)
{
DLLPersonPhone.AddPersonPhone(objPerson.LstPersonPhone, Tran, personID);
}
if (objPerson.LstPersonEMail.Count > 0)
{
DLLPersonEMail.AddPersonEMail(objPerson.LstPersonEMail, Tran, personID);
}
if (objPerson.LstPersonQualification.Count > 0)
{
DLLPersonQualification.AddPersonQualifications(objPerson.LstPersonQualification, Tran, personID);
}
if (objPerson.LstPersonTraining.Count > 0)
{
DLLPersonTraining.AddPersonTrainings(objPerson.LstPersonTraining, Tran, personID);
}
if (objPerson.LstPersonDocuments.Count > 0)
{
DLLPersonDocuments.SavePersonDocuments(objPerson.LstPersonDocuments, Tran, personID);
}
return(personID);
}
catch (OracleException oex)
{
PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError();
throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message));
}
}
