public string UpdateMaterial(Material material, string userid)
{
string resultMsg = string.Empty;
try
{
ProcParam param = new ProcParam(16)
{
ProcedureName = "MASTER_PACK.M_MATERIAL_UPD"
};
param.AddParamInput(0, "strMTL_SEQ_NO", material.MTL_SEQ_NO);
param.AddParamInput(1, "strMTL_CODE", material.MTL_CODE);
param.AddParamInput(2, "strMTL_NAME", material.MTL_NAME);
param.AddParamInput(3, "strMTL_GRADE", material.MTL_GRADE);
param.AddParamInput(4, "strMTL_COLOR", material.MTL_COLOR);
param.AddParamInput(5, "strUNIT", material.UNIT);
param.AddParamInput(6, "strSTD_QTY", material.STD_QTY);
param.AddParamInput(7, "strMIN_QTY", material.MIN_QTY);
param.AddParamInput(8, "strMAX_QTY", material.MAX_QTY);
param.AddParamInput(9, "strPARTY_ID", material.PARTY_ID);
if (material.MTL_IMAGE != null)
{
param.AddParamBLOBInput(10, "strMTL_IMAGE", OracleDbType.Blob, this.BitmapToByteArray(material.MTL_IMAGE));
}
else
{
param.AddParamInput(10, "strMTL_IMAGE", DBNull.Value);
}
param.AddParamInput(11, "strLOCATION_ID", material.LOCATION_ID);
param.AddParamInput(12, "strREMARK", material.REMARK);
param.AddParamInput(13, "strUSER_ID", userid);
param.AddParamInput(14, "strREC_STAT", (material.REC_STAT ? "Y" : "N"));
param.AddParamOutput(15, "RESULTMSG", OracleDbType.Varchar2, 255);
GlobalDB.Instance.DataAc.ExecuteNonQuery(param);
if (GlobalDB.Instance.LastException != null)
{
throw GlobalDB.Instance.LastException;
}
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
OracleString result = (OracleString)param.ReturnValue(15);
if (!result.IsNull)
{
resultMsg = result.Value;
}
}
catch (Exception ex)
{
throw ex;
}
return(resultMsg);
}
public string UpdateProduct(Product prod, string userid)
{
string resultMsg = string.Empty;
try
{
ProcParam param = new ProcParam(17)
{
ProcedureName = "MASTER_PACK.M_PRODUCT_UPD"
};
param.AddParamInput(0, "strPROD_SEQ_NO", prod.PROD_SEQ_NO);
param.AddParamInput(1, "strPRODUCT_NO", prod.PRODUCT_NO);
param.AddParamInput(2, "strPRODUCT_NAME", prod.PRODUCT_NAME);
param.AddParamInput(3, "strMATERIAL_TYPE", prod.MATERIAL_TYPE);
param.AddParamInput(4, "strPRODUCTION_TYPE", prod.PRODUCTION_TYPE);
param.AddParamInput(5, "strMC_NO", prod.MC_NO);
param.AddParamInput(6, "strBOX_QTY", prod.BOX_QTY);
param.AddParamInput(7, "strUNIT", prod.UNIT);
if (prod.PROD_IMAGE != null)
{
param.AddParamBLOBInput(8, "strPROD_IMAGE", OracleDbType.Blob, this.BitmapToByteArray(prod.PROD_IMAGE)); //this.BitmapToByteArray(prod.PROD_IMAGE)
}
else
{
param.AddParamInput(8, "strPROD_IMAGE", DBNull.Value); //this.BitmapToByteArray(prod.PROD_IMAGE)
}
//param.AddParamBLOBInput(8, "strPROD_IMAGE", OracleDbType.Blob, this.BitmapToByteArray(prod.PROD_IMAGE));
param.AddParamInput(9, "strREMARK", prod.REMARK);
param.AddParamInput(10, "strREC_STAT", (prod.REC_STAT ? "Y" : "N"));
param.AddParamInput(11, "strUSER_ID", userid);
//add new parameter on 07-Jun-2011
param.AddParamInput(12, "strCUST_PROD_NO", prod.CUST_PROD_NO);
param.AddParamInput(13, "strBUYER", prod.BUYER_PRICE);
param.AddParamInput(14, "strSELLING", prod.SELLING_PRICE);
param.AddParamInput(15, "strCOST", prod.COST_PRICE);
param.AddParamOutput(16, "RESULTMSG", OracleDbType.Varchar2, 255);
GlobalDB.Instance.DataAc.ExecuteNonQuery(param);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
OracleString result = (OracleString)param.ReturnValue(16);
if (!result.IsNull)
{
resultMsg = result.Value;
}
}
catch (Exception ex)
{
throw ex;
}
return(resultMsg);
}