public static int saveDataIntblChildLabourMainKa(tblChildLabourMainKa tblChildLabourMainKaClass)
{
string storeProcedureName = "sp_Insert_tblChildLabourMainKa";
try
{
int rowAffected = 0;
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = ILODBConfig.GetConnection();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = storeProcedureName;
cmd.Parameters.AddWithValue("@fldID", tblChildLabourMainKaClass.fldID);
cmd.Parameters.AddWithValue("@fldChildNameKa", tblChildLabourMainKaClass.fldChildNameKa);
cmd.Parameters.AddWithValue("@fldChildAgeKa", tblChildLabourMainKaClass.fldChildAgeKa);
cmd.Parameters.AddWithValue("@fldParentNameKa", tblChildLabourMainKaClass.fldParentNameKa);
cmd.Parameters.AddWithValue("@fldAddressKa", tblChildLabourMainKaClass.fldAddressKa);
cmd.Parameters.AddWithValue("@fldContactNoKa", tblChildLabourMainKaClass.fldContactNoKa);
//cmd.Parameters.AddWithValue("@fldNoteKa", tblChildLabourMainKaClass.fldNoteKa);
rowAffected = cmd.ExecuteNonQuery();
}
return rowAffected;
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
ILODBConfig.GetConnection().Close();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
tblMain mainClass = new tblMain();
mainClass.fldTypeID = 1;
mainClass.fldLocation = ddlMunicipality.SelectedItem.Text.Trim();
mainClass.fldSerialNo = txtFormSerialNo.Text.Trim();
mainClass.fldFormNo = int.Parse(txtFormNp.Text.Trim());
mainClass.fldFormFillPlace = txtFomFillPlace.Text.Trim();
mainClass.fldFormFillDate = DateTime.Parse(txtDateFormFill.Value.Trim());
mainClass.fldFormAgree = Convert.ToBoolean(int.Parse(rblFormAgree.SelectedValue));
mainClass.fldAnswererName = txtAnswererName.Text.Trim();
mainClass.fldAnsContactNo = txtAnsContactNo.Text.Trim();
mainClass.fldMainName = txtEmployerFullName.Text.Trim();
mainClass.fldMainProfessionID = int.Parse(ddlEmployerProfession.SelectedValue);
mainClass.fldMainCastID = int.Parse(ddlEmployerCast.SelectedValue);
mainClass.fldMainReligionID = int.Parse(ddlEmployerReligion.SelectedValue);
mainClass.fldMainStayTypeID = int.Parse(ddlHabitantStatus.SelectedValue);
mainClass.fldMainMenNo = int.Parse(txtEmployerFamilyMenNo.Text.Trim());
mainClass.fldMainWomenNo = int.Parse(txtEmployerFamilyWomenNo.Text.Trim());
mainClass.fldMainBoysNo = int.Parse(txtEmployerFamilyBoysNo.Text.Trim());
mainClass.fldMainGirlsNo = int.Parse(txtEmployerFamilyGirlsNo.Text.Trim());
mainClass.fldMainFamilyTotal = mainClass.fldMainMenNo + mainClass.fldMainWomenNo + mainClass.fldMainGirlsNo + mainClass.fldMainBoysNo;
mainClass.fldMainEducation = txtEmployerEducation.Text.Trim();
mainClass.fldSurveyerName = txtSurveyerName.Text.Trim();
mainClass.fldSubmitDate = DateTime.Parse(txtSubmitDates.Value.Trim());
mainClass.fldSurveyerNote = txtSurveyerNote.Text.Trim();
mainClass.fldMainNote = txtEmployerNote.Text.Trim();
mainClass.fldNote = "";
mainClass.fldWorkPlace = "";
tblAddress addPermanent = new tblAddress();
addPermanent.fldAddType = "स्थायी";
addPermanent.fldDistrict = int.Parse(drpPermanentDistrict.SelectedValue);
addPermanent.fldVillage = Convert.ToBoolean(int.Parse(rblPermanentVillage.SelectedValue));
addPermanent.fldVMName = drpPermanentMunorVdc.SelectedItem.Text.ToString();
addPermanent.fldWardNo = int.Parse(txtPermanentWardNo.Text.Trim());
addPermanent.fldTole = txtPermanentTole.Text.Trim();
addPermanent.fldHouseNo = txtPermanentHouseNo.Text.Trim();
addPermanent.fldAddNote = txtPermanetNote.Text.Trim();
tblAddress addTemp = new tblAddress();
addTemp.fldAddType = "अस्थायी";
addTemp.fldDistrict = int.Parse(drpTempDistrict.SelectedValue);
addTemp.fldVillage = Convert.ToBoolean(int.Parse(rblTempVillage.SelectedValue));
addTemp.fldVMName = drpTempMunOrVdc.SelectedItem.Text.ToString();
addTemp.fldWardNo = int.Parse(txtTempWardNo.Text.Trim());
addTemp.fldTole = txtTempTole.Text.Trim();
addTemp.fldHouseNo = txtTempHouseNo.Text.Trim();
addTemp.fldAddNote = txtTempNote.Text.Trim();
tblKnowledge knowledgeClass = new tblKnowledge();
knowledgeClass.fldChildRight = Convert.ToBoolean(int.Parse(ddlKnowChildRight.SelectedValue));
knowledgeClass.fldChildRightDesc = txtWhatIsChildRight.Text.Trim();
knowledgeClass.fldNoWorkBelow14 = Convert.ToBoolean(int.Parse(ddlNoChildLaborBelow14.SelectedValue));
knowledgeClass.fldAgreeNoWorkBelow14 = Convert.ToBoolean(int.Parse(ddlViewAboutNoChildLaborBelow14.SelectedValue));
knowledgeClass.fldNoWorkBelow14Desc = txtViewAboutNoChildLaborBelow14.Text.Trim();
knowledgeClass.fldChildLabourRisk = Convert.ToBoolean(int.Parse(ddlKnowThreeEffectsOfChildLabor.SelectedValue));
knowledgeClass.fldNoChildLabourDesc = "";
knowledgeClass.fldKnowChildAbuse = false;
knowledgeClass.fldKnowAdultAvailable = Convert.ToBoolean(int.Parse(ddlKnowMaturedLabor.SelectedValue));
knowledgeClass.fldUseAdultNotChild = Convert.ToBoolean(int.Parse(ddlUseAdultNotChild.SelectedValue));
knowledgeClass.fldUseAdultNotChildDesc = txtWhyMaturedLabor.Text.Trim();
tblChildLabour childLabourClass = new tblChildLabour();
childLabourClass.fldChildName = txtChildName.Text.Trim();
childLabourClass.fldChildGenderID = int.Parse(ddlChildSex.SelectedValue);
childLabourClass.fldChildBirthDate = DateTime.Parse(txtBirthDate.Value.Trim());
childLabourClass.fldChildAge = int.Parse(txtChildAge.Text.Trim());
childLabourClass.fldChildCastID = int.Parse(ddlChildCastInfo.SelectedValue);
childLabourClass.fldChildReligionID = int.Parse(ddlChildReligion.SelectedValue);
childLabourClass.fldChildHealth = txtChildPhysicalStatus.Text.Trim();
childLabourClass.fldChildBirthReg = Convert.ToBoolean(int.Parse(ddlIsBirthRegistration.SelectedValue));
childLabourClass.fldChildStayTypeID = int.Parse(ddlChildHome.SelectedValue);
childLabourClass.fldChildAdditionalIncome = txtOtherIncomeSource.Text.Trim();
tblChildLabourDetails childLabourDetailClass = new tblChildLabourDetails();
childLabourDetailClass.fldChildStudyStateID = int.Parse(ddlIsChildGoingStudy.SelectedValue);
childLabourDetailClass.fldChildStudyTypeID = int.Parse(ddlStudyType.SelectedValue);
childLabourDetailClass.fldChildSchool = txtSchoolOrCenterNameAndClass.Text.Trim();
childLabourDetailClass.fldChildSchoolGrade = int.Parse(txtSchoolOrCenterClass.Text.Trim());
childLabourDetailClass.fldChildSchoolExpenseID = int.Parse(ddlWhoPaysEducation.SelectedValue);
childLabourDetailClass.fldChildLeaveSchoolGrade = int.Parse(txtAtWhatClassSchoolLeft.Text.Trim());
childLabourDetailClass.fldChildLeaveSchoolDesc = txtWhySchoolLeft.Text.Trim();
childLabourDetailClass.fldChildTraining = Convert.ToBoolean(int.Parse(ddlWantVocationalTraining.SelectedValue));
childLabourDetailClass.fldChildTrainingPlace = txtWhereVocationalTraining.Text.Trim();
childLabourDetailClass.fldChildTrainingStay = txtWhereToStayDuringVocationalTraining.Text.Trim();
childLabourDetailClass.fldChildInterestedArea = txtWhatWantToDo.Text.Trim();
//childLabourDetailClass.fldChildStudyContinue = 0;
childLabourDetailClass.fldChildStudyHelpSelf = txtHelpYourself.Text.Trim();
childLabourDetailClass.fldChildStudyHelpFamily = txtHelpFamily.Text.Trim();
childLabourDetailClass.fldChildStudyHelpOther = txtHelpOther.Text.Trim();
tblChildWorkState childWorkClass = new tblChildWorkState();
childWorkClass.fldWorkStartTime = float.Parse(txtChildWorkedYear.Text.Trim()) + float.Parse(txtChildWorkedMonth.Text.Trim()) / 12;
childWorkClass.fldWorkPlaceKnow = Convert.ToBoolean(int.Parse(ddlParentKnowWorkingStation.SelectedValue));
childWorkClass.fldWorkContactTypeID = int.Parse(ddlParentContactFrequency.SelectedValue);
childWorkClass.fldWorkContact = Convert.ToBoolean(int.Parse(ddlIsAllowedToContactParent.SelectedValue));
childWorkClass.fldWorkTimePerDay = float.Parse(txtChildDailyHoursToWork.Text.Trim());
childWorkClass.fldWorkTimeDay = float.Parse(txtChildMorningWorkTime.Text.Trim());
childWorkClass.fldWorkTimeEvening = float.Parse(txtChildEveningWorkTime.Text.Trim());
childWorkClass.fldWorkDesc = txtChildWhatTasksToDo.Text.Trim();
childWorkClass.fldWorkPayAmonunt = float.Parse(txtMonthlySalary.Text.Trim());
childWorkClass.fldWorkPayTypeID = int.Parse(ddlSalaryObtainFrequency.Text.Trim());
childWorkClass.fldWorkPayReceiverID = int.Parse(ddlPayementReceiver.SelectedValue);
childWorkClass.fldWorkHoliday = Convert.ToBoolean(int.Parse(ddlIsVacation.SelectedValue));
childWorkClass.fldWorkHolidayID = int.Parse(ddlVacationFrequency.SelectedValue);
childWorkClass.fldWorkPayReceiverName = txtOtherPersonToTakeSalary.Text.Trim();
tblMainFamilyBehaviour mainFamilyBehaviourClass = new tblMainFamilyBehaviour();
mainFamilyBehaviourClass.fldLoveMost = int.Parse(ddlWhoLovesMost.SelectedValue);
string strLoveway = "";
for (int i = 0; i < chkLoveway.Items.Count; i++)
if (chkLoveway.Items[i].Selected)
{
strLoveway += chkLoveway.Items[i].Value + ";";
}
mainFamilyBehaviourClass.fldLoveWay = strLoveway;
mainFamilyBehaviourClass.fldAbuse = false;
mainFamilyBehaviourClass.fldAbusePerson = int.Parse(ddlWhoHatesMost.SelectedValue);
string strHateway = "";
for (int i = 0; i < chkAbuseType.Items.Count; i++)
if (chkAbuseType.Items[i].Selected)
{
strHateway += chkAbuseType.Items[i].Value + ";";
}
mainFamilyBehaviourClass.fldAbuseType = strHateway;
mainFamilyBehaviourClass.fldAbuseReport = Convert.ToBoolean(int.Parse(ddlProblemShare.SelectedValue));
mainFamilyBehaviourClass.fldAbuseReportDesc = txtProblemShareToWhom.Text.Trim();
mainFamilyBehaviourClass.fldFoodStatus = chkFooding.Checked;
mainFamilyBehaviourClass.fldSleepStatus = chkSleeping.Checked;
mainFamilyBehaviourClass.fldStayStatus = chkStaying.Checked;
mainFamilyBehaviourClass.fldEntertainmentStatus = chkEntertainment.Checked;
mainFamilyBehaviourClass.fldSecuritySeperateRoom = Convert.ToBoolean(int.Parse(ddlSeparateRoom.SelectedValue));
mainFamilyBehaviourClass.fldSecurityDesc = txtRequiredSecurityEnvironment.Text.Trim();
mainFamilyBehaviourClass.fldHealthStatusID = int.Parse(ddlHealthService.SelectedValue);
//mainFamilyBehaviourClass.fldCertificate=0
mainFamilyBehaviourClass.fldFuturePlan = txtFuturePlan.Text.Trim();
mainFamilyBehaviourClass.fldPlanReturnHome = Convert.ToBoolean(int.Parse(ddlWantToReturnChild.SelectedValue));
string strNoReturnHome = "";
for (int i = 0; i < chkWhyNotReturnChild.Items.Count; i++)
if (chkWhyNotReturnChild.Items[i].Selected)
{
strNoReturnHome += chkWhyNotReturnChild.Items[i].Value + ";";
}
mainFamilyBehaviourClass.fldNoPlanReturnHomeID = strNoReturnHome;
mainFamilyBehaviourClass.fldWhyLeaveHome = int.Parse(ddlLabourCause.SelectedValue);
tblAboutChildLabour aboutChildLabour = new tblAboutChildLabour();
aboutChildLabour.fldStayTypeID = 1;
aboutChildLabour.fldAdditionalIncome = "";
aboutChildLabour.fldChildLabour = false;
aboutChildLabour.fldChildBoysNo = int.Parse(txtChildBoyNoInOffice.Text.Trim());
aboutChildLabour.fldChildGirlsNo = int.Parse(txtChildGirlNoInOffice.Text.Trim());
aboutChildLabour.fldChildTotal = int.Parse(txtChildTotalNoInOffice.Text.Trim());
aboutChildLabour.fldChildSchoolYes = int.Parse(txtChildGoingSchoolNo.Text.Trim());
aboutChildLabour.fldChildSchoolNo = int.Parse(txtChildNotGoingSchoolNo.Text.Trim());
aboutChildLabour.fldSchoolName = txtChildShcoolName.Text.Trim();
aboutChildLabour.fldSchoolAddress = txtChildSchoolAddress.Text.Trim();
aboutChildLabour.fldLabourTakenID = int.Parse(ddlHowChildSearched.SelectedValue);
aboutChildLabour.fldLabourCause = "";
aboutChildLabour.fldLabourWentHow = "";
aboutChildLabour.fldJobAggrement = ddlIsEmploymentAgreement.SelectedValue.ToString();
string strJobAgreementPt = "";
for (int i = 0; i < chkJobAgreement.Items.Count; i++)
if (chkJobAgreement.Items[i].Selected)
{
strJobAgreementPt += chkJobAgreement.Items[i].Value + ";";
}
aboutChildLabour.fldJobAgreementPoints = strJobAgreementPt;
aboutChildLabour.fldChildWorkReason = txtMainResonToChildLabor.Text.Trim();
aboutChildLabour.fldTimeIntervalMonth = int.Parse(txtWhenChildStartedWork.Text.Trim());
aboutChildLabour.fldSalaryID = int.Parse(ddlSalaryInfo.SelectedValue);
aboutChildLabour.fldContactTimes = int.Parse(txtFamilyMeetNo.Text.Trim());
aboutChildLabour.fldLabourTypeID = 1;
tblChildLabourMainKa childLabourKa1 = new tblChildLabourMainKa();
tblChildLabourMainKa childLabourKa2 = new tblChildLabourMainKa();
tblChildLabourMainKa childLabourKa3 = new tblChildLabourMainKa();
tblChildLabourMainKa childLabourKa4 = new tblChildLabourMainKa();
childLabourKa1.fldChildNameKa = txtChildName.Text.Trim();
childLabourKa1.fldChildAgeKa = int.Parse(txtChildAge.Text.Trim());
childLabourKa1.fldParentNameKa = txtChildParentName.Text.Trim();
childLabourKa1.fldAddressKa = txtChildParentAddress.Text.Trim();
childLabourKa1.fldContactNoKa = txtChildParentContact.Text.Trim();
childLabourKa2.fldChildNameKa = txtChildName2.Text.Trim();
childLabourKa2.fldChildAgeKa = int.Parse(txtChidlAge3.Text.Trim());
childLabourKa2.fldParentNameKa = txtChildParentName2.Text.Trim();
childLabourKa2.fldAddressKa = txtChildParentAddress2.Text.Trim();
childLabourKa2.fldContactNoKa = txtChildParentContact2.Text.Trim();
childLabourKa3.fldChildNameKa = txtChildName3.Text.Trim();
childLabourKa3.fldChildAgeKa = int.Parse(txtChidlAge3.Text.Trim());
childLabourKa3.fldParentNameKa = txtChildParentName3.Text.Trim();
childLabourKa3.fldAddressKa = txtChildParentAddress3.Text.Trim();
childLabourKa3.fldContactNoKa = txtChildParentContact3.Text.Trim();
childLabourKa4.fldChildNameKa = txtChildName4.Text.Trim();
childLabourKa4.fldChildAgeKa = int.Parse(txtChidlAge4.Text.Trim());
childLabourKa4.fldParentNameKa = txtChildParentName4.Text.Trim();
childLabourKa4.fldAddressKa = txtChildParentAddress4.Text.Trim();
childLabourKa4.fldContactNoKa = txtChildParentContact4.Text.Trim();
ArrayList arr = new ArrayList();
if (childLabourKa1.fldChildNameKa != "")
arr.Add(childLabourKa1);
if (childLabourKa2.fldChildNameKa != "")
arr.Add(childLabourKa2);
if (childLabourKa3.fldChildNameKa != "")
arr.Add(childLabourKa3);
if (childLabourKa4.fldChildNameKa != "")
arr.Add(childLabourKa4);
int mainID = ILODBAccess.saveDataIntblMain(mainClass);
knowledgeClass.fldID = mainID;
ILODBAccess.saveDataIntblKnowledge(knowledgeClass);
childLabourClass.fldID = mainID;
int childLabourID = ILODBAccess.saveDataIntblChildLabour(childLabourClass);
childLabourDetailClass.fldID = mainID;
childLabourDetailClass.fldChildLabourID = childLabourID;
ILODBAccess.saveDataIntblChildLabourDetails(childLabourDetailClass);
aboutChildLabour.fldID = mainID;
ILODBAccess.saveDataIntblAboutChildLabour(aboutChildLabour);
for (int i = 0; i < arr.Count; i++)
{
tblChildLabourMainKa tmpChildMainKa = (tblChildLabourMainKa)arr[i];
tmpChildMainKa.fldID = mainID;
ILODBAccess.saveDataIntblChildLabourMainKa(tmpChildMainKa);
}
DataTable dtFamilyDetails = (DataTable)ViewState["CurrentData"];
if (dtFamilyDetails != null && dtFamilyDetails.Rows.Count > 0)
{
////insert the family details
for (int i = 0; i < dtFamilyDetails.Rows.Count; i++)
{
tblFamilyDetails tmpFamilyDetailsClass = new tblFamilyDetails();
tmpFamilyDetailsClass.fldChildLabourID = childLabourID;
tmpFamilyDetailsClass.fldID = mainID;
tmpFamilyDetailsClass.fldFamilyName = dtFamilyDetails.Rows[i][0].ToString();
DataTable dt = ILODBAccess.getDropDownData("fldGenderID", "tblGender", " fldGenderDesc=N'" + dtFamilyDetails.Rows[i][1].ToString() + "'");
tmpFamilyDetailsClass.fldFamilyGenderID = int.Parse(dt.Rows[0][0].ToString());
tmpFamilyDetailsClass.fldFamilyAge = int.Parse(dtFamilyDetails.Rows[i][2].ToString());
DataTable dt1 = ILODBAccess.getDropDownData("fldRelationID", "tblRelation", " fldRelationDesc=N'" + dtFamilyDetails.Rows[i][3].ToString() + "'");
tmpFamilyDetailsClass.fldFamilyRelationID = int.Parse(dt1.Rows[0][0].ToString());
tmpFamilyDetailsClass.fldFamilyEducation = dtFamilyDetails.Rows[i][4].ToString();
tmpFamilyDetailsClass.fldFamilyOccupation = dtFamilyDetails.Rows[i][5].ToString();
tmpFamilyDetailsClass.fldFamilyIdentitydoc = false;
tmpFamilyDetailsClass.fldFamilyLabourStatus = "";
tmpFamilyDetailsClass.fldFamilyCurState = dtFamilyDetails.Rows[i][6].ToString();
ILODBAccess.saveDataIntblFamilyDetails(tmpFamilyDetailsClass);
}
}
childWorkClass.fldID = mainID;
childWorkClass.fldChildLabourID = childLabourID;
ILODBAccess.saveDataIntblChildWorkState(childWorkClass);
mainFamilyBehaviourClass.fldID = mainID;
mainFamilyBehaviourClass.fldChildLabourID = childLabourID;
ILODBAccess.saveDataIntblMainFamilyBehaviour(mainFamilyBehaviourClass);
addPermanent.fldId = mainID;
addTemp.fldId = mainID;
ILODBAccess.saveDataIntblAddress(addPermanent);
ILODBAccess.saveDataIntblAddress(addTemp);
}
