public static SaMIProfiles GetSaMIProfile(int SaMIProfileID) { SaMIProfiles objSaMIProfiles = new SaMIProfiles(); return (SaMIProfiles)(new SaMIProfileDAO().FillDTO(objSaMIProfiles, "SaMIProfileID=" + SaMIProfileID)); }
public static int UpdateProfile(SaMIProfiles objSaMIProfiles) { return new SaMIProfileDAO().UpdateProfile(objSaMIProfiles); }
public static int DeleteProfile(SaMIProfiles objSaMIProfiles) { return new SaMIProfileDAO().DeleteProfile(objSaMIProfiles); }
public int DeleteProfile(SaMIProfiles objSaMIProfiles) { int rowsaffected = -1; BeginTransaction(); try { String[] UpdateProperties = new String[] { "Status" }; rowsaffected = Update(objSaMIProfiles, UpdateProperties); CommitTransaction(); } catch (Exception e) { RollBackTransaction(); rowsaffected = -1; } return rowsaffected; }
public static int InsertProfile(SaMIProfiles objSaMIProfiles) { objSaMIProfiles.SaMIProfileNumber = new SaMIProfileDAO().GenerateRegistrationNumber(objSaMIProfiles.DistrictID); return new SaMIProfileDAO().InsertProfile(objSaMIProfiles); }
public int UpdateProfile(SaMIProfiles objSaMIProfiles) { int rowsaffected = -1; BeginTransaction(); try { String[] UpdateProperties = new String[] { "SaMIProfileNumber", "RegistrationDate", "DistrictID", "Gender", "FirstName", "MiddleName", "LastName", "CasteID", "IsDiscriminated", "Address", "AddressDistrictID", "VDCID", "Ward", "AddressTemp", "AddressDistrictIDTemp", "VDCTemp", "WardTemp", "VisitorPhone", "FamilyMemberPhone", "AgeGroupID", "EducationalStatusID", "MaritalStatusID", "NoOfChildren", "NoOfAdultMale", "NoOfAdultFemale", "OccupationTypeID", "UpdatedBy", "UpdatedDate", "ICKnowledgeID", "FrequencyOfVisit", "ReasonForVisiting", "ValidRegions", "EthnicityID", "Status", "FamilyHeadName", "FamilyHeadRelation", "SyncStatus" }; rowsaffected = Update(objSaMIProfiles, UpdateProperties); CommitTransaction(); } catch (Exception e) { RollBackTransaction(); rowsaffected = -1; } return rowsaffected; }
public int InsertProfile(SaMIProfiles objSaMIProfiles) { objSaMIProfiles.SaMIProfileID = 1; BeginTransaction(); try { objSaMIProfiles.SaMIProfileID = Insert(objSaMIProfiles); CommitTransaction(); } catch (Exception ex) { RollBackTransaction(); objSaMIProfiles.SaMIProfileID = -1; } return objSaMIProfiles.SaMIProfileID; }
protected void gvSaMIProfile_RowCommand(object sender, GridViewCommandEventArgs e) { SaMIProfiles objSamiProfile = new SaMIProfiles(); if (e.CommandName.Equals("cmdDelete")) { int SaMIProfileID = Convert.ToInt32(e.CommandArgument); objSamiProfile.SaMIProfileID = SaMIProfileID; objSamiProfile.Status = 0; int rowaffected = SaMIProfileBO.DeleteProfile(objSamiProfile); LoadProfiles(); } }
//protected void btnSaveAndClose_Click(object sender, EventArgs e) //{ // SaMIProfileBO.UpdateProfile(MapSaMIProfilesDTO()); // ClearForeignEmployemntExperience(); // LoadPreviousFEExperience(Convert.ToInt32(hfSaMIProfileID.Value)); // //LoadPreviousFEExperiences(Convert.ToInt32(hfSaMIProfileID.Value)); // LoadValidRegions(Convert.ToInt32(ddlEthnicity.SelectedValue)); // Response.Redirect("Index.aspx"); //} SaMIProfiles MapSaMIProfilesDTO() { SaMIProfiles objSaMIProfiles = new SaMIProfiles(); objSaMIProfiles.SaMIProfileID = Convert.ToInt32(Request.QueryString.Get("ID")); objSaMIProfiles.SaMIProfileNumber = txtSaMIProfileNumber.Text.Trim(); objSaMIProfiles.RegistrationDate = Convert.ToDateTime(txtRegistrationDate.Text.Trim()); objSaMIProfiles.DistrictID = Convert.ToInt32(ddlDistrict.SelectedValue); if (rbMale.Checked) objSaMIProfiles.Gender = "M"; else objSaMIProfiles.Gender = "F"; objSaMIProfiles.FirstName = txtFirstName.Text.Trim(); objSaMIProfiles.MiddleName = txtMiddleName.Text.Trim(); objSaMIProfiles.LastName = txtLastName.Text.Trim(); objSaMIProfiles.CasteID = Convert.ToInt32(Request.Params["ctl00$MainContent$ddlCaste"]); objSaMIProfiles.EthnicityID = Convert.ToInt32(ddlEthnicity.SelectedValue); string ValidRegions = string.Empty; for (int j = 0; j < rbValidRegions.Items.Count; j++) { if (rbValidRegions.Items[j].Selected == true) { if (j == 0) ValidRegions = rbValidRegions.Items[j].Value; else ValidRegions = ValidRegions + "," + rbValidRegions.Items[j].Value; } } objSaMIProfiles.ValidRegions = ValidRegions; objSaMIProfiles.Address = txtAddress.Text.Trim(); objSaMIProfiles.AddressDistrictID = Convert.ToInt32(ddlAddressDistrict.SelectedValue); objSaMIProfiles.VDCID = Convert.ToInt32(ddlVDC.SelectedValue); objSaMIProfiles.Ward = txtWard.Text; objSaMIProfiles.VisitorPhone = txtVisitorPhone.Text; objSaMIProfiles.FamilyMemberPhone = txtFamilyMemberPhone.Text.Trim(); objSaMIProfiles.AgeGroupID = Convert.ToInt32(ddlAgeGroup.SelectedValue); objSaMIProfiles.EducationalStatusID = Convert.ToInt32(ddlEducationalStatus.SelectedValue); objSaMIProfiles.MaritalStatusID = Convert.ToInt32(ddlMaritalStatus.SelectedValue); objSaMIProfiles.ICKnowledgeID = Convert.ToInt32(ddlICKnowledge.SelectedValue); objSaMIProfiles.FrequencyOfVisit = Convert.ToInt32(ddlFrequencyOfVisit.SelectedValue); objSaMIProfiles.ReasonForVisiting = Convert.ToInt32(ddlReasonOfVisit.SelectedValue); objSaMIProfiles.FamilyHeadName = txtFamilyHeadName.Text; objSaMIProfiles.FamilyHeadRelation = txtFamilyHeadRelation.Text; objSaMIProfiles.UpdatedBy = UserAuthentication.GetUserId(this.Page); objSaMIProfiles.UpdatedDate = DateTime.Now; objSaMIProfiles.Status = 1; objSaMIProfiles.SyncStatus = 0; return objSaMIProfiles; }
public SaMIProfiles MapSaMIProfileDTO(String data) { Boolean blnSameAsPermanent = false; SaMIProfiles objSaMIProfiles = new SaMIProfiles(); String[] arrData = data.Split(','); foreach (String cdata in arrData) { string[] val = cdata.Split(':'); switch (val[0]) { case "informationSource": objSaMIProfiles.InformationSource = val[1]; break; case "registrationDate": String strDate = Regex.Unescape(val[1]); using (StreamWriter _testData = new StreamWriter(HttpContext.Current.Server.MapPath("~/data.txt"), true)) { _testData.WriteLine(strDate); } objSaMIProfiles.RegistrationDate = Convert.ToDateTime(strDate); break; case "district": objSaMIProfiles.DistrictID = AppCommonBO.GetOptionValue(val[1], "DistrictName", "DistrictID", "tbl_districts"); break; case "gender": if (val[1] == "Male") objSaMIProfiles.Gender = "M"; else objSaMIProfiles.Gender = "F"; break; case "fname": objSaMIProfiles.FirstName = val[1]; break; case "mname": objSaMIProfiles.MiddleName = val[1]; break; case "lname": objSaMIProfiles.LastName = val[1]; break; case "age": objSaMIProfiles.AgeGroupID = AppCommonBO.GetOptionValue(val[1], "AgeGroupDesc", "AgeGroupID", "tbl_age_groups"); break; case "casteCaste": objSaMIProfiles.CasteID = AppCommonBO.GetOptionValue(val[1], "CasteName", "CasteID", "tbl_caste"); break; case "casteEthnicity": break; case "isDiscriminated": if (val[1] == "true") objSaMIProfiles.IsDiscriminated = 1; else objSaMIProfiles.IsDiscriminated = 0; break; case "phone": objSaMIProfiles.VisitorPhone = val[1]; break; case "phoneFamily": objSaMIProfiles.FamilyMemberPhone = val[1]; break; case "permanentDistrict": objSaMIProfiles.AddressDistrictID = AppCommonBO.GetOptionValue(val[1], "DistrictName", "DistrictID", "tbl_districts"); break; case "permanentVDC": objSaMIProfiles.VDCID = AppCommonBO.GetOptionValue(val[1], "VDCName", "VDCID", "tbl_VDC"); break; case "permanentWard": objSaMIProfiles.Ward = val[1]; break; case "permanentDetails": objSaMIProfiles.Address = val[1]; break; case "temporarySameAsPermanent": if (val[1] == "true") blnSameAsPermanent = true; break; case "temporaryDistrict": if(!blnSameAsPermanent) objSaMIProfiles.AddressDistrictIDTemp = AppCommonBO.GetOptionValue(val[1], "DistrictName", "DistrictID", "tbl_districts"); break; case "temporaryVDC": if (!blnSameAsPermanent) objSaMIProfiles.VDCIDTemp = AppCommonBO.GetOptionValue(val[1], "VDCName", "VDCID", "tbl_VDC"); break; case "temporaryWard": if (!blnSameAsPermanent) objSaMIProfiles.WardTemp = val[1]; break; case "temporaryDetails": if (!blnSameAsPermanent) objSaMIProfiles.AddressTemp = val[1]; break; case "educationalStatus": objSaMIProfiles.EducationalStatusID = AppCommonBO.GetOptionValue(val[1], "EducationalStatusDesc", "EducationalStatusID", "tbl_educational_status"); break; case "presentOccupation": objSaMIProfiles.OccupationTypeID = AppCommonBO.GetOptionValue(val[1], "OccupationTypeDesc", "OccupationTypeID", "tbl_occupation_types"); break; case "maritalStatus": objSaMIProfiles.MaritalStatusID = AppCommonBO.GetOptionValue(val[1], "MaritalStatusDesc", "MaritalStatusID", "tbl_marital_status"); break; case "familyMembersA": if (val[1] != "Select") objSaMIProfiles.NoOfChildMale = Convert.ToInt32(val[1]); break; case "familyMembersB": if (val[1] != "Select") objSaMIProfiles.NoOfChildFemale = Convert.ToInt32(val[1]); break; case "familyMembersC": if (val[1] != "Select") objSaMIProfiles.NoOfAdultMale = Convert.ToInt32(val[1]); break; case "familyMembersD": if (val[1] != "Select") objSaMIProfiles.NoOfAdultFemale = Convert.ToInt32(val[1]); break; case "username": break; case "registrationNumber": objSaMIProfiles.RegistrationNumber = val[1]; break; case "howYouKnowIC": if (val[1] != "Select") objSaMIProfiles.ICKnowledgeID = AppCommonBO.GetOptionValue(val[1], "ICKnowledgeDesc", "ICKnowledgeID", "tbl_ic_knowledges"); break; case "frequencyOfVisit": if (val[1] == "Once") objSaMIProfiles.FrequencyOfVisit = 1; else objSaMIProfiles.FrequencyOfVisit = 2; break; case "reasonForVisiting": if (val[1] == "General Information") objSaMIProfiles.ReasonForVisiting = 1; else objSaMIProfiles.ReasonForVisiting = 2; break; case "gpsLongitude": try { objSaMIProfiles.GPSLongitude = Convert.ToDecimal(val[1]); } catch (Exception ex) { } break; case "gpsLatitude": try { objSaMIProfiles.GPSLatitude = Convert.ToDecimal(val[1]); } catch (Exception ex) { } break; default: break; } } if (blnSameAsPermanent) { objSaMIProfiles.AddressDistrictIDTemp = objSaMIProfiles.AddressDistrictID; objSaMIProfiles.VDCIDTemp = objSaMIProfiles.VDCID; objSaMIProfiles.WardTemp = objSaMIProfiles.Ward; objSaMIProfiles.AddressTemp = objSaMIProfiles.Address; } return objSaMIProfiles; }