public Tuple <bool, string> Post(TenderDetailsEntity tenderDetailsEntity = null)
{
//if (tenderDetailsEntity.Type == 2)
//{
// ManageSQLForTenderDetails manageSQLConnection = new ManageSQLForTenderDetails();
// return manageSQLConnection.InsertTenderDetails(tenderDetailsEntity);
//}
//else
//{
ManageSQLForTenderDetails manageSQLConnection = new ManageSQLForTenderDetails();
return(manageSQLConnection.InsertTenderDetails(tenderDetailsEntity));
//}
}
public Tuple <bool, string> InsertTenderDetails(TenderDetailsEntity entity)
{
SqlTransaction objTrans = null;
using (sqlConnection = new SqlConnection(GlobalVariable.ConnectionString))
{
DataSet ds = new DataSet();
sqlCommand = new SqlCommand();
try
{
if (sqlConnection.State == 0)
{
sqlConnection.Open();
}
objTrans = sqlConnection.BeginTransaction();
//sqlCommand.Transaction = objTrans;
//sqlCommand.Connection = sqlConnection;
sqlCommand.Parameters.Clear();
sqlCommand.Dispose();
sqlCommand = new SqlCommand();
sqlCommand.Transaction = objTrans;
sqlCommand.Connection = sqlConnection;
if (entity.Type == 2)
{
sqlCommand.CommandText = "InsertTenderQuantityDetails";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@TenderQtyID", entity.TenderQtyID);
sqlCommand.Parameters.AddWithValue("@Quantity", entity.AdditionalQty);
sqlCommand.Parameters.AddWithValue("@OrderNumber", entity.OrderNumber);
}
else
{
sqlCommand.CommandText = "InsertTenderDetails";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@TenderDetID", entity.TenderDetId);
sqlCommand.Parameters.AddWithValue("@TenderId", entity.TenderId);
sqlCommand.Parameters.AddWithValue("@OrderNumber", entity.OrderNumber);
sqlCommand.Parameters.AddWithValue("@OrderDate", entity.OrderDate);
sqlCommand.Parameters.AddWithValue("@TenderDate", entity.TenderDate);
sqlCommand.Parameters.AddWithValue("@CompletedDate", entity.CompletedDate);
sqlCommand.Parameters.AddWithValue("@ITCode", entity.ITCode);
sqlCommand.Parameters.AddWithValue("@Quantity", entity.Quantity);
sqlCommand.Parameters.AddWithValue("@Remarks", entity.Remarks);
}
sqlCommand.ExecuteNonQuery();
objTrans.Commit();
return(new Tuple <bool, string>(true, GlobalVariable.SavedMessage));
}
catch (Exception ex)
{
objTrans.Rollback();
AuditLog.WriteError(ex.Message + " : " + ex.StackTrace);
return(new Tuple <bool, string>(false, GlobalVariable.ErrorMessage));
}
finally
{
sqlConnection.Close();
sqlCommand.Dispose();
ds.Dispose();
}
}
}
