public async Task <IList <SurveyDetail> > GetSurveyDetails(string username) { string spName = "GetSurveyDetails_NewAPI"; dbConnector objConn = new dbConnector(); SqlConnection Conn = objConn.GetConnection; List <SurveyDetail> getSurveyDetails = new List <SurveyDetail>(); Conn.Open(); try { SqlCommand objCommand = new SqlCommand(spName, Conn); objCommand.CommandType = CommandType.StoredProcedure; objCommand.Parameters.AddWithValue("@Soochnapreneur", username); SqlDataReader _Reader = await objCommand.ExecuteReaderAsync(); while (_Reader.Read()) { getSurveyDetails.Add(new SurveyDetail { Id = Convert.ToInt32(_Reader["Id"]), SurveyId = Convert.ToInt32(_Reader["SurveyId"]), Question = _Reader["Question"].ToString(), InputTypes = _Reader["InputTypes"].ToString(), HasSubQuestion = Convert.ToBoolean(_Reader["HasSubQuestion"]), SectionId = Convert.ToInt32(_Reader["SectionId"]), Condition = _Reader["Condition"].ToString(), ValidationMessage = _Reader["ValidationMessage"].ToString(), isMandatory = Convert.ToBoolean(_Reader["isMandatory"]), isAvailable = Convert.ToBoolean(_Reader["isAvailable"]), isSearchable = Convert.ToBoolean(_Reader["isSearchable"]), SelectValues = _Reader["SelectValues"].ToString(), LangId = Convert.ToInt32(_Reader["LangId"]), LinkQuestion = Convert.ToInt32(_Reader["LinkQuestion"]), ClientId = _Reader["ClientId"].ToString(), Size = Convert.ToInt32(_Reader["Size"]) }); } } catch (Exception ex) { throw ex; } finally { if (Conn != null) { if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } } } return(getSurveyDetails); }
public async Task <IList <SoochnaPreneur> > GetSoochnaPrenuer(string state) { string spName = "GetDEFSoochnaPreneur"; dbConnector objConn = new dbConnector(); SqlConnection Conn = objConn.GetConnection; Conn.Open(); try { List <SoochnaPreneur> SoochnaPreneurs = new List <SoochnaPreneur>(); if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } SqlCommand objCommand = new SqlCommand(spName, Conn); objCommand.CommandType = CommandType.StoredProcedure; objCommand.Parameters.AddWithValue("@State", state); SqlDataReader _Reader = await objCommand.ExecuteReaderAsync(); while (_Reader.Read()) { SoochnaPreneurs.Add(new SoochnaPreneur { UserName = _Reader["UserName"].ToString(), Name = _Reader["Name"].ToString(), StateName = _Reader["StateName"].ToString(), Mobile = _Reader["MobileNumber"].ToString(), Email = _Reader["Email"].ToString() }); } return(SoochnaPreneurs); } catch (Exception ex) { throw ex; } finally { if (Conn != null) { if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } } } }
public async Task <bool> SyncBeneficiary(IList <Beneficiary> Beneficiaries) { bool result = true; dbConnector objConn = new dbConnector(); SqlConnection Conn = objConn.GetConnection; Conn.Open(); try { foreach (var Ben in Beneficiaries) { if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } string spName = "GetBeneficiaryById"; if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } SqlCommand objCommand = new SqlCommand(spName, Conn); objCommand.CommandType = CommandType.StoredProcedure; objCommand.Parameters.AddWithValue("@ID", Ben.Id); int count = Convert.ToInt32(await objCommand.ExecuteScalarAsync()); if (count > 0) { result = await UpdateBeneficiary(Ben); } else { result = await AddBeneficiary(Ben); } } } catch (Exception) { result = false; throw; } finally { } return(result); }
public async Task <IList <SurveyData> > GetSurveyData(string username) { string spName = "GetSurveyData_NewAPI"; dbConnector objConn = new dbConnector(); SqlConnection Conn = objConn.GetConnection; List <SurveyData> getSurveyData = new List <SurveyData>(); Conn.Open(); try { SqlCommand objCommand = new SqlCommand(spName, Conn); objCommand.CommandType = CommandType.StoredProcedure; objCommand.Parameters.AddWithValue("@Soochnapreneur", username); SqlDataReader _Reader = await objCommand.ExecuteReaderAsync(); while (_Reader.Read()) { getSurveyData.Add(new SurveyData { Id = Convert.ToInt32(_Reader["Id"]), SurveyId = Convert.ToInt32(_Reader["SurveyId"]), SurveyDataId = _Reader["SurveyDataId"].ToString(), BeneficiaryId = Convert.ToInt32(_Reader["BeneficiaryId"]), SoochnaPrenuer = _Reader["SoochnaPrenuer"].ToString(), Latitude = _Reader["Latitude"].ToString(), Longitude = _Reader["Longitude"].ToString(), Timestamp = _Reader["Timestamp"].ToString() }); } } catch (Exception ex) { throw ex; } finally { if (Conn != null) { if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } } } return(getSurveyData); }
public async Task <IList <SurveyDataDetail> > GetSurveyDataDetails(string username) { string spName = "GetSurveyDataDetails_NewAPI"; dbConnector objConn = new dbConnector(); SqlConnection Conn = objConn.GetConnection; List <SurveyDataDetail> getSurveyDataDetails = new List <SurveyDataDetail>(); Conn.Open(); try { SqlCommand objCommand = new SqlCommand(spName, Conn); objCommand.CommandType = CommandType.StoredProcedure; objCommand.Parameters.AddWithValue("@Soochnapreneur", username); SqlDataReader _Reader = await objCommand.ExecuteReaderAsync(); while (_Reader.Read()) { getSurveyDataDetails.Add(new SurveyDataDetail { Id = Convert.ToInt32(_Reader["Id"]), SurveyDataId = _Reader["SurveyDataId"].ToString(), SurveyDetailsId = _Reader["SurveyDetailsId"].ToString(), SurveyDetailsData = _Reader["SurveyDetailsData"].ToString(), InputType = _Reader["InputType"].ToString(), SurveyId = Convert.ToInt32(_Reader["SurveyId"]), SurveyDataIdFK = Convert.ToInt64(_Reader["SurveyDataId_FK"]) }); } } catch (Exception ex) { throw ex; } finally { if (Conn != null) { if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } } } return(getSurveyDataDetails); }
public async Task <IList <SurveySection> > GetSurveySections(string username) { string spName = "GetSurveySections_NewAPI"; dbConnector objConn = new dbConnector(); SqlConnection Conn = objConn.GetConnection; List <SurveySection> getSurveySections = new List <SurveySection>(); Conn.Open(); try { SqlCommand objCommand = new SqlCommand(spName, Conn); objCommand.CommandType = CommandType.StoredProcedure; objCommand.Parameters.AddWithValue("@Soochnapreneur", username); SqlDataReader _Reader = await objCommand.ExecuteReaderAsync(); while (_Reader.Read()) { getSurveySections.Add(new SurveySection { Id = Convert.ToInt32(_Reader["Id"]), SurveyId = Convert.ToInt32(_Reader["SurveyId"]), SectionHeader = _Reader["SectionHeader"].ToString(), IsAvailable = Convert.ToBoolean(_Reader["IsAvailable"]), ClientId = Convert.ToInt32(_Reader["ClientId"]), SectionId = Convert.ToInt16(_Reader["SectionId"]) }); } } catch (Exception ex) { throw ex; } finally { if (Conn != null) { if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } } } return(getSurveySections); }
public async Task <Sync> GetSyncStatus(string syncFunctionName, string userName) { string spName = "GetSyncStatus"; dbConnector objConn = new dbConnector(); SqlConnection Conn = objConn.GetConnection; var sync = new Sync(); Conn.Open(); try { SqlCommand objCommand = new SqlCommand(spName, Conn); objCommand.CommandType = CommandType.StoredProcedure; objCommand.Parameters.AddWithValue("@SyncName", syncFunctionName); objCommand.Parameters.AddWithValue("@UserName", userName); SqlDataReader _Reader = await objCommand.ExecuteReaderAsync(); while (_Reader.Read()) { sync.Id = Convert.ToInt32(_Reader["Id"]); sync.SyncFunctionName = _Reader["SyncFunctionName"].ToString(); sync.SyncStatus = Convert.ToBoolean(_Reader["SyncStatus"]); sync.TimeStamp = Convert.ToDateTime(_Reader["Timestamp"]); sync.User = _Reader["Users"].ToString(); } } catch (Exception ex) { throw ex; } finally { if (Conn != null) { if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } } } return(sync); }
public async Task <bool> InsertSurveyDataDetails(IList <SurveyDataDetail> surveyData) { string spName = "UpsertSurveyDataDetails_NewAPI"; bool retResult = true; dbConnector objConn = new dbConnector(); SqlConnection Conn = objConn.GetConnection; Conn.Open(); try { foreach (var sData in surveyData) { SqlCommand objCommand = new SqlCommand(spName, Conn); objCommand.CommandType = CommandType.StoredProcedure; objCommand.Parameters.AddWithValue("@Id", sData.Id); objCommand.Parameters.AddWithValue("@SurveyDataId", sData.SurveyDataId); objCommand.Parameters.AddWithValue("@SurveyDetailsId", sData.SurveyDetailsId); objCommand.Parameters.AddWithValue("@SurveyDetailsData", sData.SurveyDetailsData); objCommand.Parameters.AddWithValue("@InputType", sData.InputType); objCommand.Parameters.AddWithValue("@SurveyId", sData.SurveyId); objCommand.Parameters.AddWithValue("@SurveyDataId_FK", sData.SurveyDataFK); await(objCommand.ExecuteNonQueryAsync()); } } catch (Exception ex) { retResult = false; } finally { if (Conn != null) { if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } } } return(retResult); }
public async Task <bool> InsertSurveyData(IList <SurveyData> surveyData) { string spName = "UpsertSurveyData_NewAPI"; bool retResult = true; dbConnector objConn = new dbConnector(); SqlConnection Conn = objConn.GetConnection; Conn.Open(); try { foreach (var sData in surveyData) { SqlCommand objCommand = new SqlCommand(spName, Conn); objCommand.CommandType = CommandType.StoredProcedure; objCommand.Parameters.AddWithValue("@SurveyId", sData.SurveyId); objCommand.Parameters.AddWithValue("@SurveyDataId", sData.SurveyDataId); objCommand.Parameters.AddWithValue("@SoochnaPrenuer", sData.SoochnaPrenuer); objCommand.Parameters.AddWithValue("@BeneficiaryId", sData.BeneficiaryId); objCommand.Parameters.AddWithValue("@Latitude", sData.Latitude); objCommand.Parameters.AddWithValue("@Longitude", sData.Longitude); await(objCommand.ExecuteNonQueryAsync()); } } catch (Exception ex) { retResult = false; } finally { if (Conn != null) { if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } } } return(retResult); }
public async Task <int> AddBeneficiary_LCAsync(LCBeneficiary beneficiary) { dbConnector objConn = new dbConnector(); SqlConnection Conn = objConn.GetConnection; Conn.Open(); int result = 0; try { if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } SqlCommand objCommand = new SqlCommand("AddBeneficiary_LC", Conn); objCommand.CommandType = CommandType.StoredProcedure; objCommand.Parameters.AddWithValue("@BeneficiaryId", beneficiary.Id); objCommand.Parameters.AddWithValue("@FirstName", !string.IsNullOrEmpty(beneficiary.FirstName) ? beneficiary.FirstName : string.Empty); objCommand.Parameters.AddWithValue("@LastName", !string.IsNullOrEmpty(beneficiary.LastName) ? beneficiary.LastName : string.Empty); objCommand.Parameters.AddWithValue("@FathersName", !string.IsNullOrEmpty(beneficiary.FathersName) ? beneficiary.FathersName : string.Empty); objCommand.Parameters.AddWithValue("@DOB", Convert.ToDateTime(beneficiary.DOB)); objCommand.Parameters.AddWithValue("@State", beneficiary.State); objCommand.Parameters.AddWithValue("@LCGenderCode", beneficiary.Gender); objCommand.Parameters.AddWithValue("@Age", beneficiary.Age); objCommand.Parameters.AddWithValue("@LCMaritalStatus", beneficiary.MaritalStatus); objCommand.Parameters.AddWithValue("@LCEmpStatus", beneficiary.EmpStatus); objCommand.Parameters.AddWithValue("@LCDisability", beneficiary.Disability); objCommand.Parameters.AddWithValue("@SoochnaPreneur", beneficiary.SoochnaPreneur); objCommand.Parameters.AddWithValue("@Address", beneficiary.Address); objCommand.Parameters.AddWithValue("@EMail", beneficiary.EMail); objCommand.Parameters.AddWithValue("@Phone", beneficiary.Phone); objCommand.Parameters.AddWithValue("@LCQualification", beneficiary.Qualification); if (beneficiary.DateOfRegistration != null) { objCommand.Parameters.AddWithValue("@DateOfRegistration", beneficiary.DateOfRegistration); } else { objCommand.Parameters.AddWithValue("@DateOfRegistration", DBNull.Value); } var response = Convert.ToInt32(await objCommand.ExecuteScalarAsync()); return(response); } catch { throw; } finally { if (Conn != null) { if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } } } }
public async Task <bool> AddBeneficiary(Beneficiary Beneficiary) { dbConnector objConn = new dbConnector(); SqlConnection Conn = objConn.GetConnection; Conn.Open(); int result = 0; try { if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } SqlCommand objCommand = new SqlCommand("AddBeneficiaryNew", Conn); objCommand.CommandType = CommandType.StoredProcedure; objCommand.Parameters.AddWithValue("@BeneficiaryId", Beneficiary.Id); objCommand.Parameters.AddWithValue("@Beneficiary ", Beneficiary.ParentId); objCommand.Parameters.AddWithValue("@FirstName", !string.IsNullOrEmpty(Beneficiary.FirstName) ? Beneficiary.FirstName : string.Empty); objCommand.Parameters.AddWithValue("@LastName", !string.IsNullOrEmpty(Beneficiary.LastName) ? Beneficiary.LastName : string.Empty); objCommand.Parameters.AddWithValue("@FathersName", !string.IsNullOrEmpty(Beneficiary.FathersName) ? Beneficiary.FathersName : string.Empty); objCommand.Parameters.AddWithValue("@HusbandsName", !string.IsNullOrEmpty(Beneficiary.HusbandsName) ? Beneficiary.HusbandsName : string.Empty); objCommand.Parameters.AddWithValue("@DOB", Convert.ToDateTime(Beneficiary.DOB)); objCommand.Parameters.AddWithValue("@IDProof", Beneficiary.IDProof); objCommand.Parameters.AddWithValue("@IDDetails ", !string.IsNullOrEmpty(Beneficiary.IDDetails) ? Beneficiary.IDDetails : string.Empty); objCommand.Parameters.AddWithValue("@State", Beneficiary.State); objCommand.Parameters.AddWithValue("@District", Beneficiary.District); objCommand.Parameters.AddWithValue("@Sex", Beneficiary.Sex); objCommand.Parameters.AddWithValue("@Age", Beneficiary.Age); objCommand.Parameters.AddWithValue("@Religion", Beneficiary.Religion); objCommand.Parameters.AddWithValue("@Socio", Beneficiary.Socio); objCommand.Parameters.AddWithValue("@Occupation", Beneficiary.Occupation); objCommand.Parameters.AddWithValue("@MaritalStatus ", Beneficiary.MaritalStatus); objCommand.Parameters.AddWithValue("@Category", Beneficiary.Category); objCommand.Parameters.AddWithValue("@Department", Beneficiary.Department); objCommand.Parameters.AddWithValue("@EmpStatus", Beneficiary.EmploymentStatus); objCommand.Parameters.AddWithValue("@VulGroup", Beneficiary.VulGroup); objCommand.Parameters.AddWithValue("@AnnualIncome", Beneficiary.AnnualIncome); objCommand.Parameters.AddWithValue("@Disability", Beneficiary.Disabilty); objCommand.Parameters.AddWithValue("@SoochnaPreneur", Beneficiary.SoochnaPreneur); objCommand.Parameters.AddWithValue("@Photo", Beneficiary.Photo); objCommand.Parameters.AddWithValue("@Relationship", Beneficiary.Relationship); objCommand.Parameters.AddWithValue("@Sickness", Beneficiary.Sickness); objCommand.Parameters.AddWithValue("@Address", Beneficiary.Address); objCommand.Parameters.AddWithValue("@EMail", Beneficiary.EMail); objCommand.Parameters.AddWithValue("@Phone", Beneficiary.Phone); objCommand.Parameters.AddWithValue("@PercentageDisability", Beneficiary.PercentageDisablity); objCommand.Parameters.AddWithValue("@Qualification", Beneficiary.Qualification); objCommand.Parameters.AddWithValue("@Block", Beneficiary.Block); objCommand.Parameters.AddWithValue("@Village", Beneficiary.Village); objCommand.Parameters.AddWithValue("@Panchayat", Beneficiary.Panchayat); if (Beneficiary.DateOfRegistration != null) { objCommand.Parameters.AddWithValue("@DateOfRegistration", Beneficiary.DateOfRegistration); } else { objCommand.Parameters.AddWithValue("@DateOfRegistration", DBNull.Value); } result = Convert.ToInt32(await objCommand.ExecuteScalarAsync()); if (result > 0) { return(true); } else { return(false); } } catch { throw; } finally { if (Conn != null) { if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } } } }
public async Task <bool> UpdateBeneficiary(Beneficiary Ben) { bool result = true; dbConnector objConn = new dbConnector(); SqlConnection Conn = objConn.GetConnection; Conn.Open(); try { //bool status = false; //DBParameterCollection paramCollection = new DBParameterCollection(); string spName = "UpdateBeneficiaryNew"; if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } SqlCommand objCommand = new SqlCommand(spName, Conn); objCommand.CommandType = CommandType.StoredProcedure; objCommand.Parameters.AddWithValue("@ID", Ben.Id); objCommand.Parameters.AddWithValue("@BeneficiaryId ", Ben.Id); objCommand.Parameters.AddWithValue("@Beneficiary ", Ben.ParentId); objCommand.Parameters.AddWithValue("@FirstName", !string.IsNullOrEmpty(Ben.FirstName) ? Ben.FirstName : string.Empty); objCommand.Parameters.AddWithValue("@LastName", !string.IsNullOrEmpty(Ben.LastName) ? Ben.LastName : string.Empty); objCommand.Parameters.AddWithValue("@FathersName", !string.IsNullOrEmpty(Ben.FathersName) ? Ben.FathersName : string.Empty); objCommand.Parameters.AddWithValue("@HusbandsName", !string.IsNullOrEmpty(Ben.HusbandsName) ? Ben.HusbandsName : string.Empty); objCommand.Parameters.AddWithValue("@DOB", Convert.ToDateTime(Ben.DOB)); objCommand.Parameters.AddWithValue("@IDProof", Ben.IDProof); objCommand.Parameters.AddWithValue("@IDDetails ", !string.IsNullOrEmpty(Ben.IDDetails) ? Ben.IDDetails : string.Empty); objCommand.Parameters.AddWithValue("@State", Ben.State); objCommand.Parameters.AddWithValue("@District", Ben.District); objCommand.Parameters.AddWithValue("@Sex", Ben.Sex); objCommand.Parameters.AddWithValue("@Age", Ben.Age); objCommand.Parameters.AddWithValue("@Religion", Ben.Religion); objCommand.Parameters.AddWithValue("@Socio", Ben.Socio); objCommand.Parameters.AddWithValue("@Occupation", Ben.Occupation); objCommand.Parameters.AddWithValue("@MaritalStatus ", Ben.MaritalStatus); objCommand.Parameters.AddWithValue("@Category", Ben.Category); objCommand.Parameters.AddWithValue("@Department", Ben.Department); objCommand.Parameters.AddWithValue("@EmpStatus", Ben.EmploymentStatus); objCommand.Parameters.AddWithValue("@VulGroup", Ben.VulGroup); objCommand.Parameters.AddWithValue("@AnnualIncome", Ben.AnnualIncome); objCommand.Parameters.AddWithValue("@Disability", Ben.Disabilty); objCommand.Parameters.AddWithValue("@SoochnaPreneur ", Ben.SoochnaPreneur); objCommand.Parameters.AddWithValue("@Photo", Ben.Photo); objCommand.Parameters.AddWithValue("@Relationship", Ben.Relationship); objCommand.Parameters.AddWithValue("@Sickness", Ben.Sickness); objCommand.Parameters.AddWithValue("@Address", Ben.Address); objCommand.Parameters.AddWithValue("@EMail", Ben.EMail); objCommand.Parameters.AddWithValue("@Phone", Ben.Phone); objCommand.Parameters.AddWithValue("@PercentageDisability", Ben.PercentageDisablity); objCommand.Parameters.AddWithValue("@Qualification", Ben.Qualification); objCommand.Parameters.AddWithValue("@Block", Ben.Block); objCommand.Parameters.AddWithValue("@Village", Ben.Village); objCommand.Parameters.AddWithValue("@Panchayat", Ben.Panchayat); int count = Convert.ToInt32(await objCommand.ExecuteScalarAsync()); if (count == 2) { result = true; } else if (count == 0) { result = true; } else { result = false; } } catch (Exception ex) { result = false; } finally { if (Conn != null) { if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } } } return(result); }
public async Task <IList <Beneficiary> > ListOfBeneficiaries(string SoochnaPreneur, int Beneficiary) { string spName = "GetBeneficiariesNew"; dbConnector objConn = new dbConnector(); SqlConnection Conn = objConn.GetConnection; Conn.Open(); try { List <Beneficiary> getBeneficiary = new List <Beneficiary>(); if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } SqlCommand objCommand = new SqlCommand(spName, Conn); objCommand.CommandType = CommandType.StoredProcedure; objCommand.Parameters.AddWithValue("@SoochnaPreneur", SoochnaPreneur); objCommand.Parameters.AddWithValue("@Beneficiary", Beneficiary); SqlDataReader _Reader = await objCommand.ExecuteReaderAsync(); while (_Reader.Read()) { getBeneficiary.Add(new Beneficiary { Id = Convert.ToInt64(_Reader["Id"]), ParentId = Beneficiary, FirstName = _Reader["FirstName"].ToString(), LastName = _Reader["LastName"].ToString(), FathersName = _Reader["FathersName"].ToString(), HusbandsName = _Reader["HusbandsName"].ToString(), //DateOfBirth = (_Reader["DateOfBirth"] != DBNull.Value && !_Reader["DateOfBirth"].ToString().Contains("1/1/0001")) ? _Reader["DateOfBirth"].ToString() : string.Empty, DOB = _Reader["DOB"] != DBNull.Value && _Reader["DOB"].ToString() != string.Empty ? Convert.ToDateTime(_Reader["DOB"].ToString()) : (DateTime?)null, IDProof = Convert.ToInt64(_Reader["IDProof"] != DBNull.Value ? Convert.ToInt64(_Reader["IDProof"]) : 0), IDDetails = _Reader["IDDetails"].ToString(), State = Convert.ToInt64(_Reader["State"]), District = Convert.ToInt64(_Reader["District"]), EngDistrictId = _Reader["EngDistrictId"] != DBNull.Value && _Reader["EngDistrictId"] != "" ? Convert.ToInt64(_Reader["EngDistrictId"]) : 0, Sex = Convert.ToInt16(_Reader["Sex"] != DBNull.Value ? _Reader["Sex"] : 0), Age = Convert.ToInt16(_Reader["Age"] != DBNull.Value ? _Reader["Age"] : 0), Religion = Convert.ToInt16(_Reader["Religion"] != DBNull.Value ? _Reader["Religion"] : 0), Department = Convert.ToInt16(_Reader["Department"] != DBNull.Value ? _Reader["Department"] : 0), EmploymentStatus = Convert.ToInt16(_Reader["EmpStatus"] != DBNull.Value ? _Reader["EmpStatus"] : 0), VulGroup = Convert.ToInt16(_Reader["VulGroup"] != DBNull.Value ? _Reader["VulGroup"] : 0), AnnualIncome = Convert.ToDouble(_Reader["AnnualIncome"] != DBNull.Value ? _Reader["AnnualIncome"] : 0), Disabilty = Convert.ToInt16(_Reader["Disablity"] != DBNull.Value ? _Reader["Disablity"] : 0), Photo = _Reader["Photo"].ToString(), SoochnaPreneur = SoochnaPreneur, Relationship = Convert.ToInt16(_Reader["Relationship"] != DBNull.Value ? _Reader["Relationship"] : 0), Sickness = Convert.ToInt16(_Reader["Sickness"] != DBNull.Value ? _Reader["Sickness"] : 0), Occupation = Convert.ToInt16(_Reader["Occupation"] != DBNull.Value ? _Reader["Occupation"] : 0), BeneficiaryId = Convert.ToInt16(_Reader["Beneficiary"] != DBNull.Value ? _Reader["Beneficiary"] : 0), PercentageDisablity = _Reader["PercentageDisability"] != DBNull.Value ? Convert.ToInt64(_Reader["PercentageDisability"]) : 0, Address = _Reader["Address"].ToString(), EMail = _Reader["EMail"].ToString(), Phone = _Reader["Phone"].ToString(), Qualification = _Reader["Qualification"].ToString(), DateOfRegistration = _Reader["DateOfRegistration"] != DBNull.Value && _Reader["DateOfRegistration"].ToString() != string.Empty ? Convert.ToDateTime(_Reader["DateOfRegistration"].ToString()) : (DateTime?)null, Socio = Convert.ToInt16(_Reader["Socio"] != DBNull.Value ? _Reader["Socio"] : 0), MaritalStatus = Convert.ToInt16(_Reader["MaritulStatus"] != DBNull.Value ? _Reader["MaritulStatus"] : 0), Category = Convert.ToInt16(_Reader["Category"] != DBNull.Value ? _Reader["Category"] : 0), Block = _Reader["Block"].ToString(), Village = _Reader["Village"].ToString(), Panchayat = _Reader["Panchayat"].ToString() }); } return(getBeneficiary); } catch (Exception ex) { throw ex; } finally { if (Conn != null) { if (Conn.State == ConnectionState.Open) { Conn.Close(); Conn.Dispose(); } } } }