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