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