public APIResponse GetAllItemCode()
{
try
{
Dictionary <string, Tuple <string, DbType, ParameterDirection> > parameters = new Dictionary <string, Tuple <string, DbType, ParameterDirection> >
{
};
var data = unitOfWork.Repository <ItemModel>().GetEntitiesBySP("[dbo].[GetAllItemCode]", parameters);
return(APIResponseGenerator.GenerateResponseMessage("1", "Success", data));
}
catch (Exception ex)
{
return(APIResponseGenerator.GenerateResponseMessage("Error", ex.ToString(), null));
}
}
public APIResponse GetItemsDetailsByID(int Itemid)
{
try
{
Dictionary <string, Tuple <string, DbType, ParameterDirection> > parameters = new Dictionary <string, Tuple <string, DbType, ParameterDirection> >
{
{ "@Id", Tuple.Create(Itemid.ToString(), DbType.Int32, ParameterDirection.Input) },
};
var data = unitOfWork.Repository <ItemModel>().GetEntitiesBySP("[dbo].[GetItemsDetailsByID]", parameters);
return(APIResponseGenerator.GenerateResponseMessage("1", "Success", data));
}
catch (Exception ex)
{
return(APIResponseGenerator.GenerateResponseMessage("Error", ex.ToString(), null));
}
}
public APIResponse SaveOrder(OrderModel orderModel)
{
try
{
var statusCode = "-1";
var message = "";
Dictionary <string, Tuple <string, DbType, ParameterDirection> > parameters = new Dictionary <string, Tuple <string, DbType, ParameterDirection> >
{
{ "@Note", Tuple.Create(orderModel.Note.ToString(), DbType.String, ParameterDirection.Input) },
{ "@InvoiceNo", Tuple.Create(orderModel.InvoiceNo.ToString(), DbType.String, ParameterDirection.Input) },
{ "@InvoiceDate", Tuple.Create(orderModel.InvoiceDate.ToString(), DbType.DateTime, ParameterDirection.Input) },
{ "@ReferenceNo", Tuple.Create(orderModel.ReferenceNo.ToString(), DbType.String, ParameterDirection.Input) },
{ "@Status", Tuple.Create(0.ToString(), DbType.Int32, ParameterDirection.Output) },
};
var orderId = unitOfWork.Repository <string>().ExecuteSPWithInputOutput("[dbo].[SaveOrder]", parameters);
if (orderId > 0)
{
int result = InsertItemsByOrder(orderModel, orderId);
if (result > 0)
{
statusCode = "1";
message = "Successfully Saved";
}
}
else
{
statusCode = "-1";
message = "Error, Not Saved";
}
return(APIResponseGenerator.GenerateResponseMessage(statusCode, message, ""));
}
catch (Exception ex)
{
return(APIResponseGenerator.GenerateResponseMessage("Error", ex.ToString(), null));
}
}
