public bool InsertOpeningBalanceMaster(OpeningBalanceEntity openingBalanceList)
{
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
var result = manageSQLConnection.InsertOpeningBalanceMaster(openingBalanceList);
return(result);
}
public bool InsertOpeningBalanceMaster(OpeningBalanceEntity openingBalanceList)
{
// 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 = "InsertOpeningBalanceMaster";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@GodownCode", openingBalanceList.GodownCode);
sqlCommand.Parameters.AddWithValue("@RegionCode", openingBalanceList.RegionCode);
sqlCommand.Parameters.AddWithValue("@CommodityCode", openingBalanceList.CommodityCode);
sqlCommand.Parameters.AddWithValue("@BookBalanceBags", openingBalanceList.BookBalanceBags);
sqlCommand.Parameters.AddWithValue("@BookBalanceWeight", openingBalanceList.BookBalanceWeight);
sqlCommand.Parameters.AddWithValue("@PhysicalBalanceBags", openingBalanceList.PhysicalBalanceBags);
sqlCommand.Parameters.AddWithValue("@PhysicalBalanceWeight", openingBalanceList.PhysicalBalanceWeight);
sqlCommand.Parameters.AddWithValue("@CumulitiveShortage", openingBalanceList.CumulitiveShortage);
sqlCommand.Parameters.AddWithValue("@ObDate", openingBalanceList.ObDate);
sqlCommand.Parameters.AddWithValue("@PurchaseRate", "0");
// sqlCommand.Parameters.AddWithValue("@CurYear", "0");
sqlCommand.Parameters.AddWithValue("@ExportFlag", "N");
sqlCommand.Parameters.AddWithValue("@Excess", "0");
sqlCommand.Parameters.AddWithValue("@Flag1", "");
sqlCommand.Parameters.AddWithValue("@Flag2", "-");
sqlCommand.Parameters.AddWithValue("@Receipts", "0.0");
sqlCommand.Parameters.AddWithValue("@Issues", "0.0");
sqlCommand.Parameters.AddWithValue("@TransferIn", "0.0");
sqlCommand.Parameters.AddWithValue("@TransferOut", "0.0");
sqlCommand.Parameters.AddWithValue("@WriteOff", "0.0");
sqlCommand.Parameters.AddWithValue("@ExcessReceipt", "0.0");
sqlCommand.Parameters.AddWithValue("@Others", "0.0");
sqlCommand.Parameters.AddWithValue("@Balance", "0");
//sqlCommand.Parameters.Add("@Rowid", SqlDbType.NVarChar, 26);
//sqlCommand.Parameters["@Rowid"].Direction = ParameterDirection.Output;
sqlCommand.ExecuteNonQuery();
// Rowid = (string)sqlCommand.Parameters["@Rowid"].Value;
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;
}
}
}
public bool Post(OpeningBalanceEntity openingBalanceEntity)
{
OpeningBalanceMaster openingBalance = new OpeningBalanceMaster();
return(openingBalance.InsertOpeningBalanceMaster(openingBalanceEntity));
}
