public void Update(BOL_REQ_USAGE_FEE oREQ_USAGE_FEE, out string strMessage)
{
ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strUpdate);
oMaster.crudCommand.Parameters.Add(new SqlParameter("@UNIT_PRICE", oREQ_USAGE_FEE.UNIT_PRICE));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@AMOUNT", oREQ_USAGE_FEE.AMOUNT));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@UPDATED_AT", oREQ_USAGE_FEE.UPDATED_AT));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@UPDATED_BY", oREQ_USAGE_FEE.UPDATED_BY));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NO_BOX", oREQ_USAGE_FEE.COMPANY_NO_BOX));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@REQ_SEQ", oREQ_USAGE_FEE.REQ_SEQ));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@CONTRACT_CODE", oREQ_USAGE_FEE.CONTRACT_CODE));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@TYPE", oREQ_USAGE_FEE.TYPE));
oMaster.ExcuteQuery(6, out strMessage);
}
public bool CanUpdate(BOL_REQ_USAGE_FEE oREQ_USAGE_FEE, string FILE_CREATED, out string strMsg)
{
ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strGetUpdatedat);
oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NO_BOX", oREQ_USAGE_FEE.COMPANY_NO_BOX));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@REQ_SEQ", oREQ_USAGE_FEE.REQ_SEQ));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@CONTRACT_CODE", oREQ_USAGE_FEE.CONTRACT_CODE));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@TYPE", oREQ_USAGE_FEE.TYPE));
oMaster.crudCommand.Parameters.Add(new SqlParameter("@FILE_CREATED", FILE_CREATED));
oMaster.ExcuteQuery(4, out strMsg);
int count = oMaster.dtExcuted.Rows.Count;
if (count <= 0)
{
return(false);
}
else
{
return(true);
}
}
