public Tuple <bool, bool> Post(StackOpeningEntity stackOpeningEntity = null)
{
ManageSQLConnection manageSQL = new ManageSQLConnection();
ManageStackCard manageStack = new ManageStackCard();
if (!string.IsNullOrEmpty(stackOpeningEntity.StackNo) && !string.IsNullOrEmpty(stackOpeningEntity.CurrYear))
{
if (stackOpeningEntity.CurrYear.Length != 4 || stackOpeningEntity.CurrYear.ToUpper() == "NULL")
{
return(new Tuple <bool, bool>(false, false));
}
bool isInserted = false;
DataSet ds = new DataSet();
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@OBDate", stackOpeningEntity.ObStackDate));
sqlParameters.Add(new KeyValuePair <string, string>("@CurYear", stackOpeningEntity.CurrYear));
sqlParameters.Add(new KeyValuePair <string, string>("@GodownCode", stackOpeningEntity.GodownCode));
sqlParameters.Add(new KeyValuePair <string, string>("@StackNo", stackOpeningEntity.StackNo));
ds = manageSQL.GetDataSetValues("FetchStackCard", sqlParameters);
var result = manageStack.CheckStackCard(ds);
if (!result)
{
isInserted = manageSQL.InsertStackOpening(stackOpeningEntity);
}
isInserted = manageSQL.InsertStackOpening(stackOpeningEntity);
return(new Tuple <bool, bool>(result, isInserted));
}
else
{
return(new Tuple <bool, bool>(false, false));
}
}
public bool InsertStackOpening(StackOpeningEntity stackOpeningEntity)
{
// string Rowid = string.Empty;
using (sqlConnection = new SqlConnection(GlobalVariable.ConnectionString))
{
DataSet ds = new DataSet();
sqlCommand = new SqlCommand();
try
{
if (sqlConnection.State == 0)
{
sqlConnection.Open();
}
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandText = "InsertStackDetails";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@GodownCode", stackOpeningEntity.GodownCode);
sqlCommand.Parameters.AddWithValue("@CommodityCode", stackOpeningEntity.CommodityCode);
sqlCommand.Parameters.AddWithValue("@StackNo", stackOpeningEntity.StackNo);
sqlCommand.Parameters.AddWithValue("@StackBalanceBags", stackOpeningEntity.Bags);
sqlCommand.Parameters.AddWithValue("@StackBalanceWeight", stackOpeningEntity.Weights);
sqlCommand.Parameters.AddWithValue("@ObStackDate", stackOpeningEntity.ObStackDate);
sqlCommand.Parameters.AddWithValue("@CurYear", stackOpeningEntity.CurrYear);
sqlCommand.Parameters.AddWithValue("@ExportFlag", "N");
sqlCommand.Parameters.AddWithValue("@RegionCode", stackOpeningEntity.RegionCode);
sqlCommand.Parameters.AddWithValue("@Tycode", stackOpeningEntity.Tycode);
sqlCommand.Parameters.AddWithValue("@Flag1", "R");
sqlCommand.Parameters.AddWithValue("@Flag2", "0");
//sqlCommand.Parameters.AddWithValue("@clstackdate", stackOpeningEntity.clstackdate);
sqlCommand.ExecuteNonQuery();
sqlCommand.Parameters.Clear();
sqlCommand.Dispose();
// objTrans.Commit();
return(true);
}
catch (Exception ex)
{
AuditLog.WriteError(ex.Message + " : " + ex.StackTrace);
return(false);
}
finally
{
if (sqlConnection.State == 0)
{
sqlConnection.Open();
}
sqlCommand.Dispose();
ds.Dispose();
dataAdapter = null;
}
}
}
