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