// Save Services Url's Data
public dynamic SaveServices_helper(InternalURL root)
{
dynamic obj = new ExpandoObject();
try
{
Int32 UniuqeCode = GetUniqueCode(root);
UniuqeCode = UniuqeCode + 1;
root.URL_ID = root.SERVICE + (UniuqeCode < 9 ? ("0" + UniuqeCode.ToString()) : UniuqeCode.ToString());
DataTable data = SaveServices_data_helper(root);
if (data != null)
{
obj.Status = "Success";
obj.Reason = "Data Inserted Successfully.";
obj.Details = data;
}
else
{
obj.Status = "Failure";
obj.Reason = "No Data Found";
}
}
catch (Exception ex)
{
obj.Status = "Failure";
obj.Reason = ex.Message;
}
return(obj);
}
public dynamic LoadDepartments(InternalURL oj)
{
dynamic obj = new ExpandoObject();
try
{
DataTable dt = LoadDepartments_helper(oj);
if (dt != null && dt.Rows.Count > 0)
{
obj.Status = "Success";
obj.Reason = "";
obj.Details = dt;
}
else
{
obj.Status = "Failure";
obj.Reason = "No Data Found";
}
}
catch (Exception ex)
{
obj.Status = "Failure";
obj.Reason = ex.Message;
return(obj);
}
return(obj);
}
public IHttpActionResult SaveServicesURLData(dynamic data)
{
try
{
string value = JsonConvert.SerializeObject(data);
InternalURL rootobj = JsonConvert.DeserializeObject <InternalURL>(value);
var validresult = _valid.CheckServicesURL(rootobj);
if (validresult.Status == "Success")
{
return(Ok(Internalhel.SaveServices_helper(rootobj)));
}
else
{
CatchData.Status = "Failure";
CatchData.Reason = validresult.Reason;
return(Ok(CatchData));
}
}
catch (Exception ex)
{
CatchData.Status = "Failure";
CatchData.Reason = ex.Message;
return(Ok(CatchData));
}
}
// Get UniqueCode
public Int32 GetUniqueCode(InternalURL obj)
{
Int32 Cnt = 0;
try
{
var comd = new OracleCommand();
comd.InitialLONGFetchSize = 1000;
comd.CommandType = CommandType.Text;
comd.CommandText = "SELECT COUNT(*) AS COUNT FROM GSWS_URL_MASTER WHERE SD_ID=:SD_ID AND HOD_ID=:HOD_ID AND SCHEME_ID=:SCHEME_ID";
comd.Parameters.Add(":SD_ID", OracleDbType.Varchar2).Value = obj.DEPARTMENT;
comd.Parameters.Add(":HOD_ID", OracleDbType.Varchar2).Value = obj.HOD;
comd.Parameters.Add(":SCHEME_ID", OracleDbType.Varchar2).Value = obj.SERVICE;
DataTable data = GetgswsDataAdapter(comd);
if (data != null && data.Rows.Count > 0)
{
Cnt = Convert.ToInt32(data.Rows[0]["COUNT"]);
}
}
catch (WebException wex)
{
string mappath = HttpContext.Current.Server.MapPath("ExceptionLogs");
Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_ReportLog_Exception(mappath, "Error Get Unique code based on url :" + wex.Message.ToString()));
}
return(Cnt);
}
public DataTable LoadGeographicalData_helper(InternalURL oj)
{
try
{
cmd = new OracleCommand();
cmd.InitialLONGFetchSize = 1000;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GSWS_GET_SERVICE_DETAILS";
cmd.Parameters.Add("FTYPE", OracleDbType.Varchar2, 12).Value = oj.TYPE;
cmd.Parameters.Add("FPS_CODE", OracleDbType.Varchar2, 12).Value = oj.DEPARTMENT;
cmd.Parameters.Add("FGSWS_ID", OracleDbType.Varchar2, 12).Value = "";
cmd.Parameters.Add("FDIST_CODE", OracleDbType.Varchar2, 12).Value = oj.DISTRICT;
cmd.Parameters.Add("FMAND_CODE", OracleDbType.Varchar2, 12).Value = oj.MANDAL;
cmd.Parameters.Add("FVILL_CODE", OracleDbType.Varchar2, 12).Value = oj.PANCHAYAT;
cmd.Parameters.Add("P_CUR", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
DataTable dtstatus = comhel.GetgswsDataAdapter(cmd);
if (dtstatus != null && dtstatus.Rows.Count > 0)
{
return(dtstatus);
}
else
{
return(null);
}
}
catch (Exception ex)
{
string mappath = HttpContext.Current.Server.MapPath("InternalURLExceptionLogs");
Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_ReportLog_Exception(mappath, "Error From LoadDepartments:" + ex.Message.ToString()));
throw ex;
}
}
// save Services Url's
public DataTable SaveServices_data_helper(InternalURL obj)
{
try
{
var comd = new OracleCommand();
comd.InitialLONGFetchSize = 1000;
comd.CommandType = CommandType.StoredProcedure;
comd.CommandText = "GSWS_IN_URL_MASTER";
comd.Parameters.Add("P_TYPE", OracleDbType.Varchar2).Value = obj.TYPE;
comd.Parameters.Add("P_SD_ID", OracleDbType.Varchar2).Value = obj.DEPARTMENT;
comd.Parameters.Add("P_HOD_ID", OracleDbType.Varchar2).Value = obj.HOD;
comd.Parameters.Add("P_SCHEME_ID", OracleDbType.Varchar2).Value = obj.SERVICE;
comd.Parameters.Add("P_TYPE_OF_REQUEST", OracleDbType.Varchar2).Value = obj.REQUESTTYPE;
comd.Parameters.Add("P_URL_ID", OracleDbType.Varchar2).Value = obj.URL_ID;
comd.Parameters.Add("P_URL", OracleDbType.Varchar2).Value = obj.URL;
comd.Parameters.Add("P_URL_DESCRIPTION", OracleDbType.Varchar2).Value = obj.URLDESCRIPTION;
comd.Parameters.Add("P_ACCESS_LEVEL", OracleDbType.Varchar2).Value = obj.ACCESSLEVEL;
comd.Parameters.Add("P_DISTRICT_ID", OracleDbType.Varchar2).Value = obj.DISTRICT;
comd.Parameters.Add("P_MANDAL_ID", OracleDbType.Varchar2).Value = obj.MANDAL;
comd.Parameters.Add("P_GP_WARD_ID", OracleDbType.Varchar2).Value = obj.PANCHAYAT;
comd.Parameters.Add("P_USER_NAME", OracleDbType.Varchar2).Value = obj.USERNAME;
comd.Parameters.Add("P_PASSWORD", OracleDbType.Varchar2).Value = obj.PASSWORD;
comd.Parameters.Add("P_ENCRYPT_PASSWORD", OracleDbType.Varchar2).Value = string.IsNullOrEmpty(obj.ENCRYPT_PASSWORD) ? null : CryptLib.getHashSha256(obj.ENCRYPT_PASSWORD, 31);;
comd.Parameters.Add("P_TYPE_OF_SERVICE", OracleDbType.Varchar2).Value = obj.SERVICETYPE;
comd.Parameters.Add("P_UR_FLAG", OracleDbType.Varchar2).Value = obj.RUFLAG; //
comd.Parameters.Add("P_URL_DESC_TEL", OracleDbType.Varchar2).Value = obj.P_URL_DESC_TEL;
comd.Parameters.Add("DESIGN_R", OracleDbType.Varchar2).Value = obj.RURALDESIGNATION;
comd.Parameters.Add("DESIGN_U", OracleDbType.Varchar2).Value = obj.URBANDESIGNATION;
comd.Parameters.Add("P_CUR", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
DataTable data = GetgswsDataAdapter(comd);
if (data != null && data.Rows.Count > 0)
{
return(data);
}
else
{
return(null);
}
}
catch (WebException wex)
{
string mappath = HttpContext.Current.Server.MapPath("ExceptionLogs");
Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_ReportLog_Exception(mappath, "Error Save Services URL data :" + wex.Message.ToString()));
throw new Exception(wex.Message);
}
}
public IHttpActionResult LoadDepartments(dynamic data)
{
try
{
//string value = token_gen.Authorize_aesdecrpty(data);
string value = JsonConvert.SerializeObject(data);
InternalURL rootobj = JsonConvert.DeserializeObject <InternalURL>(value);
return(Ok(Internalhel.LoadDepartments(rootobj)));
}
catch (Exception ex)
{
CatchData.Status = "Failure";
CatchData.Reason = ex.Message;
return(Ok(CatchData));
}
}
