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));
}
}
