//Save Textile Data
public dynamic SaveTextileData(TextileModel root)
{
dynamic obj = new ExpandoObject();
try
{
string data = SaveTextileData_helper(root);
if (data == "Success")
{
obj.Status = "Success";
obj.Reason = "Data Inserted Successfully.";
obj.Details = data;
}
else
{
obj.Status = "Failure";
obj.Reason = "Data Insertion Failed";
}
}
catch (Exception ex)
{
obj.Status = "Failure";
obj.Reason = GetException(ex.Message);
}
return(obj);
}
//Save Textile Data
public string SaveTextileData_helper(TextileModel obj)
{
try
{
cmd = new OracleCommand();
cmd.CommandText = @"insert into chenetha_persons_data(CITIZEN_NAME,FATHER_HUSBAND_NAME,AGE,DOOR_NO,VILLAGE_WARD_ID,MANDAL_ID,DISTRICT_ID,PINCODE,MOBILE_NUMBER,CH_UNIQUE_ID,UID_NUM,RATION_CARD_NO,PSS_STATUS,CASTE,TOTAL_FAMILY_MEMBERS,LOOM_STATUS,PIT_LOOM_OR_FRAME_LOOM,OWNED_OR_TEMPORARY_LOOM,TOTAL_LOOMS,HOUSE_TYPE,ANNUAL_INCOME,BANK_NAME,BANK_BRANCH,ACCOUNT_NO,IFSC_CODE,INSERTED_BY) values (:CITIZEN_NAME,:FATHER_HUSBAND_NAME,:AGE,:DOOR_NO,:VILLAGE_WARD_ID,:MANDAL_ID,:DISTRICT_ID,:PINCODE,:MOBILE_NUMBER,:CH_UNIQUE_ID,:UID_NUM,:RATION_CARD_NO,:PSS_STATUS,:CASTE,:TOTAL_FAMILY_MEMBERS,:LOOM_STATUS,:PIT_LOOM_OR_FRAME_LOOM,:OWNED_OR_TEMPORARY_LOOM,:TOTAL_LOOMS,:HOUSE_TYPE,:ANNUAL_INCOME,:BANK_NAME,:BANK_BRANCH,:ACCOUNT_NO,:IFSC_CODE,:INSERTED_BY)";
cmd.Parameters.Add(":CITIZEN_NAME", OracleDbType.Varchar2, 100).Value = obj.NAME;
cmd.Parameters.Add(":FATHER_HUSBAND_NAME", OracleDbType.Varchar2, 100).Value = obj.FATHERNAME;
cmd.Parameters.Add(":AGE", OracleDbType.Varchar2, 5).Value = obj.AGE;
cmd.Parameters.Add(":DOOR_NO", OracleDbType.Varchar2, 50).Value = obj.DOORNO;
cmd.Parameters.Add(":VILLAGE_WARD_ID", OracleDbType.Varchar2, 20).Value = obj.VILLAGEPANCHAYATH;
cmd.Parameters.Add(":MANDAL_ID", OracleDbType.Varchar2, 20).Value = obj.MANDAL;
cmd.Parameters.Add(":DISTRICT_ID", OracleDbType.Varchar2, 20).Value = obj.DISTRICT;
cmd.Parameters.Add(":PINCODE", OracleDbType.Varchar2, 10).Value = obj.PINCODE;
cmd.Parameters.Add(":MOBILE_NUMBER", OracleDbType.Varchar2, 10).Value = obj.MOBILE;
cmd.Parameters.Add(":CH_UNIQUE_ID", OracleDbType.Varchar2, 50).Value = obj.IDCARD;
cmd.Parameters.Add(":UID_NUM", OracleDbType.Varchar2, 12).Value = obj.AADHAAR;
cmd.Parameters.Add(":RATION_CARD_NO", OracleDbType.Varchar2, 50).Value = obj.RATION;
cmd.Parameters.Add(":PSS_STATUS", OracleDbType.Varchar2, 10).Value = obj.PSSREG;
cmd.Parameters.Add(":CASTE", OracleDbType.Varchar2, 50).Value = obj.CASTE;
cmd.Parameters.Add(":TOTAL_FAMILY_MEMBERS", OracleDbType.Varchar2, 10).Value = obj.FAMILYCOUNT;
cmd.Parameters.Add(":LOOM_STATUS", OracleDbType.Varchar2, 10).Value = obj.DOINGLOOM;
cmd.Parameters.Add(":PIT_LOOM_OR_FRAME_LOOM", OracleDbType.Varchar2, 100).Value = obj.LOOMTYPE;
cmd.Parameters.Add(":OWNED_OR_TEMPORARY_LOOM", OracleDbType.Varchar2, 100).Value = obj.LOOMOWNERSHIP;
cmd.Parameters.Add(":TOTAL_LOOMS", OracleDbType.Varchar2, 10).Value = obj.LOOMCOUNT;
cmd.Parameters.Add(":HOUSE_TYPE", OracleDbType.Varchar2, 100).Value = obj.HOUSETYPE;
cmd.Parameters.Add(":ANNUAL_INCOME", OracleDbType.Varchar2, 100).Value = obj.ANNINCOME;
cmd.Parameters.Add(":BANK_NAME", OracleDbType.Varchar2, 100).Value = obj.BANK;
cmd.Parameters.Add(":BANK_BRANCH", OracleDbType.Varchar2, 100).Value = obj.BRANCH;
cmd.Parameters.Add(":ACCOUNT_NO", OracleDbType.Varchar2, 100).Value = obj.ACCOUNT;
cmd.Parameters.Add(":IFSC_CODE", OracleDbType.Varchar2, 100).Value = obj.IFSC;
cmd.Parameters.Add(":INSERTED_BY", OracleDbType.Varchar2, 100).Value = obj.SUBMITTEDBY;
int k = getspsExecuteNonQuery(cmd);
if (k > 0)
{
return("Success");
}
else
{
return("Failure");
}
}
catch (Exception ex)
{
string mappath = HttpContext.Current.Server.MapPath("ExceptionLogs");
Task WriteTask = Task.Factory.StartNew(() => new Logdatafile().Write_ReportLog_Exception(mappath, "Error Save Textile Data :" + ex.Message.ToString()));
throw ex;
}
}
public IHttpActionResult SaveTextileData(dynamic data)
{
string value = token_gen.Authorize_aesdecrpty(data);
try
{
//string value = JsonConvert.SerializeObject(data);
TextileModel rootobj = JsonConvert.DeserializeObject <TextileModel>(value);
return(Ok(heahel.SaveTextileData(rootobj)));
}
catch (Exception ex)
{
CatchData.Status = "Failure";
CatchData.Reason = ServicesHelper.ThirdpartyMessage;
return(Ok(CatchData));
}
}
