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