public decimal UpdateDeliveryDetail(Delivery_Detail_Info Obj_Info) { Delivery_DetailDA Obj_da = new Delivery_DetailDA(); try { return(Obj_da.UpdateDeliveryDetail(Obj_Info)); } catch (Exception ex) { Common.log.Error(ex.ToString()); return(-1); } }
public decimal InsertDeliveryDetail(Delivery_Detail_Info Obj_Info) { try { OracleParameter paramReturn = new OracleParameter("p_result", OracleDbType.Decimal, ParameterDirection.Output); OracleHelper.ExecuteNonQuery(Common.gConnectString, CommandType.StoredProcedure, "pkg_delivery_detail.proc_deli_detail_insert", new OracleParameter("p_delivery_id", OracleDbType.Decimal, Obj_Info.Delivery_DetailID, ParameterDirection.Input), new OracleParameter("p_status", OracleDbType.Decimal, Obj_Info.Status, ParameterDirection.Input), new OracleParameter("p_url", OracleDbType.Varchar2, Obj_Info.Url, ParameterDirection.Input), new OracleParameter("p_createdby", OracleDbType.Varchar2, Obj_Info.CreatedBy, ParameterDirection.Input), new OracleParameter("p_createddate", OracleDbType.Date, Obj_Info.CreatedDate, ParameterDirection.Input), paramReturn); return(Convert.ToDecimal(paramReturn.Value.ToString())); } catch (Exception ex) { Common.log.Error(ex.ToString()); return(-1); } }