public async Task <IHttpActionResult> PutAFI_IDocBi(string ace, string sal, string group, long BandNo, AFI_IDocBi aFI_IDocBi)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (UnitDatabase.CreateConection(ace, sal, group))
{
try
{
string sql = string.Format(CultureInfo.InvariantCulture,
@"DECLARE @return_value int
EXEC @return_value = [dbo].[Web_SaveIDoc_BU]
@SerialNumber = {0},
@BandNo = {1},
@KalaCode = N'{2}',
@Amount1 = {3},
@Amount2 = {4},
@Amount3 = {5},
@UnitPrice = {6},
@TotalPrice = {7},
@Discount = {8},
@MainUnit = {9},
@Comm = N'{10}',
@Up_Flag = {11}
SELECT 'Return Value' = @return_value
",
aFI_IDocBi.SerialNumber,
aFI_IDocBi.BandNo,
aFI_IDocBi.KalaCode,
aFI_IDocBi.Amount1 ?? 0,
aFI_IDocBi.Amount2 ?? 0,
aFI_IDocBi.Amount3 ?? 0,
aFI_IDocBi.UnitPrice ?? 0,
aFI_IDocBi.TotalPrice ?? 0,
aFI_IDocBi.Discount ?? 0,
aFI_IDocBi.MainUnit,
aFI_IDocBi.Comm,
aFI_IDocBi.Up_Flag);
int value = UnitDatabase.db.Database.SqlQuery <int>(sql).Single();
if (value == 0)
{
await UnitDatabase.db.SaveChangesAsync();
}
}
catch (Exception)
{
throw;
}
}
string sql1 = string.Format(@"SELECT SerialNumber,BandNo,KalaCode,KalaName,MainUnit,MainUnitName,Amount1,Amount2,Amount3,UnitPrice,TotalPrice,Comm,Up_Flag,DeghatR1,DeghatR2,DeghatR3,DeghatM1,DeghatM2,DeghatM3,DeghatR
FROM Web_IDocB WHERE SerialNumber = {0}", aFI_IDocBi.SerialNumber);
var listFactor = UnitDatabase.db.Database.SqlQuery <Web_IDocB>(sql1);
return(Ok(listFactor));
}
public async Task <IHttpActionResult> PostAFI_IDocBi(string ace, string sal, string group, long bandNo, AFI_IDocBi aFI_IDocBi)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (UnitDatabase.CreateConection(ace, sal, group))
{
try
{
string fieldBandNo;
string tableName;
if (ace == "AFI1")
{
tableName = "Afi1IDocB";
fieldBandNo = "BandNo";
}
else
{
tableName = "inv5docb";
fieldBandNo = "radif";
}
if (bandNo > 0)
{
string sqlUpdateBand = string.Format(@"DECLARE @return_value int
EXEC @return_value = [dbo].[Web_Doc_BShift]
@TableName = '{0}',
@SerialNumber = {1},
@BandNo = {2},
@BandNoFld = '{3}'
SELECT 'Return Value' = @return_value" ,
tableName,
aFI_IDocBi.SerialNumber,
bandNo,
fieldBandNo);
int valueUpdateBand = UnitDatabase.db.Database.SqlQuery <int>(sqlUpdateBand).Single();
}
string sql = string.Format(CultureInfo.InvariantCulture,
@"DECLARE @return_value int
EXEC @return_value = [dbo].[Web_SaveIDoc_BI]
@SerialNumber = {0},
@BandNo = {1},
@KalaCode = N'{2}',
@Amount1 = {3},
@Amount2 = {4},
@Amount3 = {5},
@UnitPrice = {6},
@TotalPrice = {7},
@MainUnit = {8},
@Comm = N'{9}',
@Up_Flag = {10}
SELECT 'Return Value' = @return_value
",
aFI_IDocBi.SerialNumber,
bandNo == 0 ? aFI_IDocBi.BandNo.ToString() : bandNo.ToString(),
aFI_IDocBi.KalaCode,
aFI_IDocBi.Amount1 ?? 0,
aFI_IDocBi.Amount2 ?? 0,
aFI_IDocBi.Amount3 ?? 0,
aFI_IDocBi.UnitPrice ?? 0,
aFI_IDocBi.TotalPrice ?? 0,
aFI_IDocBi.MainUnit,
aFI_IDocBi.Comm,
aFI_IDocBi.Up_Flag);
int value = UnitDatabase.db.Database.SqlQuery <int>(sql).Single();
if (value == 0)
{
await UnitDatabase.db.SaveChangesAsync();
}
}
catch (Exception)
{
throw;
}
}
string sql1 = string.Format(@"SELECT SerialNumber,BandNo,KalaCode,KalaName,MainUnit,MainUnitName,Amount1,Amount2,Amount3,UnitPrice,TotalPrice,Comm,Up_Flag,DeghatR1,DeghatR2,DeghatR3,DeghatM1,DeghatM2,DeghatM3,DeghatR
FROM Web_IDocB WHERE SerialNumber = {0}", aFI_IDocBi.SerialNumber);
var listFactor = UnitDatabase.db.Database.SqlQuery <Web_IDocB>(sql1);
return(Ok(listFactor));
}
public async Task <IHttpActionResult> PutAFI_IDocBi(string ace, string sal, string group, long BandNo, AFI_IDocBi aFI_IDocBi)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, aFI_IDocBi.SerialNumber, aFI_IDocBi.InOut == 1 ? "IIDoc" : "IODoc", 4, aFI_IDocBi.BandNo ?? 0);
if (con == "ok")
{
try
{
string sql = string.Format(CultureInfo.InvariantCulture,
@"DECLARE @return_value int
EXEC @return_value = [dbo].[Web_SaveIDoc_BU]
@SerialNumber = {0},
@BandNo = {1},
@KalaCode = N'{2}',
@Amount1 = {3},
@Amount2 = {4},
@Amount3 = {5},
@UnitPrice = {6},
@TotalPrice = {7},
@Discount = {8},
@MainUnit = {9},
@Comm = N'{10}',
@Up_Flag = {11},
@OprCode = '{12}',
@MkzCode = '{13}'
SELECT 'Return Value' = @return_value
",
aFI_IDocBi.SerialNumber,
aFI_IDocBi.BandNo,
aFI_IDocBi.KalaCode,
aFI_IDocBi.Amount1 ?? 0,
aFI_IDocBi.Amount2 ?? 0,
aFI_IDocBi.Amount3 ?? 0,
aFI_IDocBi.UnitPrice ?? 0,
aFI_IDocBi.TotalPrice ?? 0,
aFI_IDocBi.Discount ?? 0,
aFI_IDocBi.MainUnit,
aFI_IDocBi.Comm,
aFI_IDocBi.Up_Flag,
aFI_IDocBi.OprCode,
aFI_IDocBi.MkzCode
);
int value = UnitDatabase.db.Database.SqlQuery <int>(sql).Single();
if (value == 0)
{
await UnitDatabase.db.SaveChangesAsync();
}
}
catch (Exception)
{
throw;
}
string sql1 = string.Format(@"SELECT SerialNumber,BandNo,KalaCode,KalaName,MainUnit,MainUnitName,Amount1,Amount2,Amount3,UnitPrice,TotalPrice,Comm,Up_Flag,KalaDeghatR1,KalaDeghatR2,KalaDeghatR3,KalaDeghatM1,KalaDeghatM2,KalaDeghatM3,DeghatR
FROM Web_IDocB WHERE SerialNumber = {0}", aFI_IDocBi.SerialNumber);
var listFactor = UnitDatabase.db.Database.SqlQuery <Web_IDocB>(sql1);
UnitDatabase.SaveLog(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, aFI_IDocBi.SerialNumber, aFI_IDocBi.InOut == 1 ? "IIDoc" : "IODoc", 2, aFI_IDocBi.flagLog, 0);
return(Ok(listFactor));
}
return(Ok(con));
}
