public bool UpdateETNNumber(ETNNumberModel model, ref string msg)
{
bool result = true;
try
{
List <SqlParameter> listParameters = new List <SqlParameter>();
listParameters.Add(ProviderManager.CreateParameter("@CargoWiseKey", model.CaroWiseKey, SqlDbType.VarChar));
listParameters.Add(ProviderManager.CreateParameter("@ETNNumber", model.ETNNumber, SqlDbType.VarChar));
if (!string.IsNullOrEmpty(model.GIBInvoiceNumber))
{
listParameters.Add(ProviderManager.CreateParameter("@GIBInvoiceNumber", model.GIBInvoiceNumber, SqlDbType.VarChar));
}
result = ProviderManager.ExecuteSP("ETNNumberUpdate", listParameters, ref msg);
}
catch (Exception ex)
{
msg = String.Format("Error in UpdateETNNumber.Insert()!\r\n->{0}", ex.Message);
result = false;
}
return(result);
}
public bool GetCargoWiseFileChargeLine(CargoWiseFileChargeLineModel model, ref string msg)
{
bool result = true;
try
{
List <SqlParameter> listParameters = new List <SqlParameter>();
listParameters.Add(ProviderManager.CreateParameter("@Key", model.Key, SqlDbType.VarChar));
listParameters.Add(ProviderManager.CreateParameter("@GovernmentTransactionNo", model.GovernmentTransactionNo, SqlDbType.VarChar));
result = ProviderManager.ExecuteSP("CargoWiseFileChargeLineGet", listParameters, this, ref msg);
}
catch (Exception ex)
{
msg = String.Format("Error in CargoWiseFileChargeLineProvider.Insert()!\r\n->{0}", ex.Message);
result = false;
}
return(result);
}
