/// <summary>
/// To add pap data into database
/// </summary>
/// <param name="objAddPAP"></param>
/// <returns></returns>
public string AddPAP(AddPAPBO objAddPAP)
{
string result = "";
OracleConnection myConnection;
OracleCommand myCommand;
myConnection = new OracleConnection(AppConfiguration.ConnectionString);
myCommand = new OracleCommand("USP_TRN_INS_PAPHOUSEHOLD", myConnection);
myCommand.Connection = myConnection;
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("PROJECTIDIN", objAddPAP.ProjectID);
myCommand.Parameters.Add("SurnameIN", objAddPAP.Surname);
myCommand.Parameters.Add("FirstnameIN", objAddPAP.Firstname);
myCommand.Parameters.Add("OthernameIN", objAddPAP.Othername);
myCommand.Parameters.Add("PAPNAMEIN", objAddPAP.Pap);
myCommand.Parameters.Add("INSTITUTION_", objAddPAP.Institution);
myCommand.Parameters.Add("PAPTYPE_", objAddPAP.PapType);
myCommand.Parameters.Add("PLOTREFERENCEIN", objAddPAP.Plot_ref);
myCommand.Parameters.Add("DESIGNATIONIN", objAddPAP.Designation);
myCommand.Parameters.Add("DISTRICTIN", objAddPAP.District);
myCommand.Parameters.Add("COUNTYIN", objAddPAP.County);
myCommand.Parameters.Add("SUBCOUNTYIN", objAddPAP.SubCounty);
myCommand.Parameters.Add("PARISHIN", objAddPAP.Parish);
myCommand.Parameters.Add("VILLAGEIN", objAddPAP.Village);
myCommand.Parameters.Add("RIGHTWAYIN", objAddPAP.Right_of_way);
myCommand.Parameters.Add("WAYLEAVESIN", objAddPAP.Wayleaves);
myCommand.Parameters.Add("ISDELETEDIN", "False");
myCommand.Parameters.Add("USERIDIN", objAddPAP.CreatedBy);
myCommand.Parameters.Add("PLOTLATITUDEIN", objAddPAP.Plotlatitude);
myCommand.Parameters.Add("PLOTLONGITUDEIN", objAddPAP.Plotlongitude);
myCommand.Parameters.Add("PAP_UIDIN", objAddPAP.Papuid);
//myCommand.Parameters.Add("RELIGIONIDIN", objAddPAP.CreatedBy);
//myCommand.Parameters.Add("optiongroupidIN", objAddPAP.CreatedBy);
//myCommand.Parameters.Add("literacylevelidIN", objAddPAP.CreatedBy);
//myCommand.Parameters.Add("occupationidIN", objAddPAP.CreatedBy);
//myCommand.Parameters.Add("papstatusidIN", objAddPAP.CreatedBy);
myCommand.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
myConnection.Open();
myCommand.ExecuteNonQuery();
if (myCommand.Parameters["errorMessage_"].Value != null)
{
result = myCommand.Parameters["errorMessage_"].Value.ToString();
}
else
{
result = string.Empty;
}
myConnection.Close();
return(result);
}
/// <summary>
/// To add pap data into database
/// </summary>
/// <param name="objAddPAP"></param>
/// <returns></returns>
public string AddPAP(AddPAPBO objAddPAP)
{
return((new AddPAPDAL()).AddPAP(objAddPAP));
}
/// <summary>
/// To save excel data to database
/// </summary>
/// <param name="dtPap"></param>
/// <param name="ProjectID"></param>
/// <param name="uID"></param>
/// <returns></returns>
public string SaveExcelData(DataTable dt, int ProjectID, string uID)
{
AddPAPBO objAddPAP;
string result = string.Empty;
string sPaps = string.Empty;
string fPaps = string.Empty;
string PapName = string.Empty, InstituteName = string.Empty;
OracleConnection myConnection;
OracleCommand myCommand;
myConnection = new OracleConnection(AppConfiguration.ConnectionString);
myCommand = new OracleCommand("USP_TRN_INS_PAPHOUSEHOLD", myConnection);
myCommand.Connection = myConnection;
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("PROJECTIDIN", "");
myCommand.Parameters.Add("SurnameIN", "");
myCommand.Parameters.Add("FirstnameIN", "");
myCommand.Parameters.Add("OthernameIN", "");
myCommand.Parameters.Add("PAPNAMEIN", "");
myCommand.Parameters.Add("INSTITUTION_", "");
myCommand.Parameters.Add("PAPTYPE_", "");
myCommand.Parameters.Add("PLOTREFERENCEIN", "");
myCommand.Parameters.Add("DESIGNATIONIN", "");
myCommand.Parameters.Add("DISTRICTIN", "");
myCommand.Parameters.Add("COUNTYIN", "");
myCommand.Parameters.Add("SUBCOUNTYIN", "");
myCommand.Parameters.Add("PARISHIN", "");
myCommand.Parameters.Add("VILLAGEIN", "");
myCommand.Parameters.Add("RIGHTWAYIN", "");
myCommand.Parameters.Add("WAYLEAVESIN", "");
myCommand.Parameters.Add("ISDELETEDIN", "");
myCommand.Parameters.Add("USERIDIN", "");
myCommand.Parameters.Add("PLOTLATITUDEIN", "");
myCommand.Parameters.Add("PLOTLONGITUDEIN", "");
myCommand.Parameters.Add("PAP_UIDIN", "");
myCommand.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
myConnection.Open();
int CountSuccess = 0, CountFail = 0;
foreach (DataRow dr in dt.Rows)
{
objAddPAP = new AddPAPBO();
objAddPAP.ProjectID = ProjectID;
objAddPAP.Surname = Convert.ToString(dr["SURNAME"]);
objAddPAP.Firstname = Convert.ToString(dr["FIRSTNAME"]);
objAddPAP.Othername = Convert.ToString(dr["OTHERNAME"]);
objAddPAP.Pap = Convert.ToString(dr["PAPNAME"]);//Renamed
objAddPAP.Institution = Convert.ToString(dr["INSTITUTION"]);
objAddPAP.PapType = Convert.ToString(dr["PapType"]);
objAddPAP.Plot_ref = Convert.ToString(dr["PLOTREFERENCE"]);
objAddPAP.Designation = Convert.ToString(dr["DESIGNATION"]);
objAddPAP.District = Convert.ToString(dr["DISTRICT"]);
objAddPAP.County = Convert.ToString(dr["COUNTY"]);
objAddPAP.SubCounty = Convert.ToString(dr["SUBCOUNTY"]);
objAddPAP.Parish = Convert.ToString(dr["PARISH"]);
objAddPAP.Village = Convert.ToString(dr["VILLAGE"]);
objAddPAP.Right_of_way = Convert.ToString(dr["RIGHTOFWAY"]);
objAddPAP.Wayleaves = Convert.ToString(dr["WAYLEAVES"]);
objAddPAP.Total = Convert.ToString(dr["TOTAL"]);
objAddPAP.Plotlatitude = Convert.ToString(dr["PLOTLATITUDE"]);
objAddPAP.Plotlongitude = Convert.ToString(dr["PLOTLONGITUDE"]);
objAddPAP.Papuid = Convert.ToString(dr["Papuid"]);
myCommand.Parameters["PROJECTIDIN"].Value = objAddPAP.ProjectID;
myCommand.Parameters["SurnameIN"].Value = objAddPAP.Surname;
myCommand.Parameters["FirstnameIN"].Value = objAddPAP.Firstname;
myCommand.Parameters["OthernameIN"].Value = objAddPAP.Othername;
myCommand.Parameters["PAPNAMEIN"].Value = objAddPAP.Surname.ToString() + " " + objAddPAP.Firstname;
if (objAddPAP.Institution.Trim() != "")
{
myCommand.Parameters["INSTITUTION_"].Value = objAddPAP.Institution;//INSTITUTION
}
else
{
myCommand.Parameters["INSTITUTION_"].Value = DBNull.Value; //INSTITUTION
}
if (objAddPAP.PapType.ToUpper() == "GROUPOWNER") // || objAddPAP.Group_Owner != null)
{
myCommand.Parameters["PAPTYPE_"].Value = "GRP";
}
else if (objAddPAP.PapType.ToUpper() == "INSTITUTION")// || !string.IsNullOrEmpty(objAddPAP.Institution))
{
myCommand.Parameters["PAPTYPE_"].Value = "INS";
}
else
{
myCommand.Parameters["PAPTYPE_"].Value = "IND";
}
myCommand.Parameters["PLOTREFERENCEIN"].Value = objAddPAP.Plot_ref;
myCommand.Parameters["DESIGNATIONIN"].Value = objAddPAP.Designation;
myCommand.Parameters["DISTRICTIN"].Value = objAddPAP.District;
myCommand.Parameters["COUNTYIN"].Value = objAddPAP.County;
myCommand.Parameters["SUBCOUNTYIN"].Value = objAddPAP.SubCounty;
myCommand.Parameters["PARISHIN"].Value = objAddPAP.Parish;
myCommand.Parameters["VILLAGEIN"].Value = objAddPAP.Village;
myCommand.Parameters["RIGHTWAYIN"].Value = objAddPAP.Right_of_way;
myCommand.Parameters["WAYLEAVESIN"].Value = objAddPAP.Wayleaves;
myCommand.Parameters["ISDELETEDIN"].Value = "False";
myCommand.Parameters["USERIDIN"].Value = uID;
myCommand.Parameters["PLOTLATITUDEIN"].Value = objAddPAP.Plotlatitude;
myCommand.Parameters["PLOTLONGITUDEIN"].Value = objAddPAP.Plotlongitude;
myCommand.Parameters["PAP_UIDIN"].Value = objAddPAP.Papuid;
myCommand.ExecuteNonQuery();
string resultMessage = string.Empty;
if (myCommand.Parameters["errorMessage_"].Value != null)
{
resultMessage = myCommand.Parameters["errorMessage_"].Value.ToString();
}
if (string.IsNullOrEmpty(resultMessage) || resultMessage == "null" || resultMessage == "")
{
result = string.Empty;
sPaps += "," + Convert.ToString(dr["Papuid"]);
CountSuccess++;
}
else
{
result = myCommand.Parameters["errorMessage_"].Value.ToString();
fPaps += ", " + Convert.ToString(dr["Papuid"]);
CountFail++;
}
}
myConnection.Close();
if (sPaps.Length > 0)
{
sPaps = sPaps.Remove(0, 1);
}
if (fPaps.Length > 0)
{
fPaps = fPaps.Remove(0, 1);
}
return(CountSuccess.ToString() + "|" + fPaps);
//return CountSuccess.ToString();
}
