public string Post(TransactionEntity entity)
{
DataSet ds = new DataSet();
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
List <KeyValuePair <string, string> > listParameters = new List <KeyValuePair <string, string> >();
if (entity.Type == 1)
{
listParameters.Add(new KeyValuePair <string, string>("@Docdate", entity.Docdate));
listParameters.Add(new KeyValuePair <string, string>("@Gcode", entity.Gcode));
listParameters.Add(new KeyValuePair <string, string>("@RoleId", entity.RoleId));
ds = manageSQLConnection.GetDataSetValues("GetTransactionstatus", listParameters);
return(JsonConvert.SerializeObject(ds.Tables[0]));
}
else
{
ManageStackCard manageStack = new ManageStackCard();
listParameters.Add(new KeyValuePair <string, string>("@Docdate", entity.Docdate));
listParameters.Add(new KeyValuePair <string, string>("@RCode", entity.RCode));
listParameters.Add(new KeyValuePair <string, string>("@RoleId", entity.RoleId));
ds = manageSQLConnection.GetDataSetValues("GetTransactionStatusByDate", listParameters);
//Manage Transactionstatus
var result = manageStack.ManageApprovalStatus(ds, entity.Docdate);
return(JsonConvert.SerializeObject(result));
}
}
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 string Post(StackEntity stackEntity)
{
DataSet ds = new DataSet();
ManageSQLConnection manageSQLConnection = new ManageSQLConnection();
if (stackEntity.Type == 1)
{
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@GodownCode", stackEntity.GCode));
sqlParameters.Add(new KeyValuePair <string, string>("@ItemCode", stackEntity.ICode));
sqlParameters.Add(new KeyValuePair <string, string>("@FromDate", stackEntity.StackDate));
sqlParameters.Add(new KeyValuePair <string, string>("@StacKNo", stackEntity.TStockNo));
sqlParameters.Add(new KeyValuePair <string, string>("@DocNo", stackEntity.DocNo));
sqlParameters.Add(new KeyValuePair <string, string>("@StackYear", stackEntity.StackYear));
ds = manageSQLConnection.GetDataSetValues("GetStackBalance", sqlParameters);
return(JsonConvert.SerializeObject(ds.Tables[0]));
}
else if (stackEntity.Type == 2)
{
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@GodownCode", stackEntity.GCode));
sqlParameters.Add(new KeyValuePair <string, string>("@ICode", stackEntity.ICode));
sqlParameters.Add(new KeyValuePair <string, string>("@Fyear", stackEntity.StackDate));
ds = manageSQLConnection.GetDataSetValues("GetStackcardOpenentry", sqlParameters);
return(JsonConvert.SerializeObject(ds.Tables[0]));
}
else if (stackEntity.Type == 3)
{
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@GodownCode", stackEntity.GCode));
sqlParameters.Add(new KeyValuePair <string, string>("@ICode", stackEntity.ICode));
sqlParameters.Add(new KeyValuePair <string, string>("@Fyear", stackEntity.StackDate));
ds = manageSQLConnection.GetDataSetValues("GetStackcard", sqlParameters);
return(JsonConvert.SerializeObject(ds.Tables[0]));
}
else if (stackEntity.Type == 4)
{
ManageStackCard manageStackCard = new ManageStackCard();
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@GodownCode", stackEntity.GCode));
sqlParameters.Add(new KeyValuePair <string, string>("@ItemCode", stackEntity.ICode));
sqlParameters.Add(new KeyValuePair <string, string>("@FromDate", stackEntity.StackDate));
sqlParameters.Add(new KeyValuePair <string, string>("@StacKNo", stackEntity.TStockNo.Trim()));
sqlParameters.Add(new KeyValuePair <string, string>("@StackYear", stackEntity.StackYear));
ds = manageSQLConnection.GetDataSetValues("GetStackCardDetailsbyId", sqlParameters);
//Calculate the
var result = manageStackCard.ManageStackBalance(ds, stackEntity);
return(JsonConvert.SerializeObject(result));
}
else if (stackEntity.Type == 5)
{
ManageStackCard manageStackCard = new ManageStackCard();
List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();
sqlParameters.Add(new KeyValuePair <string, string>("@GodownCode", stackEntity.GCode));
sqlParameters.Add(new KeyValuePair <string, string>("@ItemCode", stackEntity.ICode));
sqlParameters.Add(new KeyValuePair <string, string>("@ShortYear", stackEntity.StackDate));
sqlParameters.Add(new KeyValuePair <string, string>("@Status", stackEntity.StackStatus));
sqlParameters.Add(new KeyValuePair <string, string>("@FromDate", stackEntity.FromDate));
sqlParameters.Add(new KeyValuePair <string, string>("@ToDate", stackEntity.ToDate));
ds = manageSQLConnection.GetDataSetValues("GetStackCardDetailsbyCommodity", sqlParameters);
//Calculate the
var result = manageStackCard.ManageStackCardRegister(ds, stackEntity);
return(JsonConvert.SerializeObject(result));
}
return(string.Empty);
}
