//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)); } }