public async Task <IHttpActionResult> PutAFI_IDocHi(string ace, string sal, string group, AFI_IDocHi aFI_IDocHi)
{
string value = "";
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_IDocHi.SerialNumber, aFI_IDocHi.InOut == 1 ? "IIDoc" : "IODoc", 1, 0);
if (con == "ok")
{
try
{
string sql = string.Format(
@"DECLARE @return_value nvarchar(50),
@DocNo_Out int
EXEC @return_value = [dbo].[Web_SaveIDoc_HU]
@DOCNOMODE = {0},
@INSERTMODE = {1},
@MODECODE = '{2}' ,
@DOCNO = {3},
@STARTNO = {4},
@ENDNO = {5},
@BRANCHCODE = {6},
@USERCODE = '{7}',
@SERIALNUMBER = {8},
@DOCDATE = '{9}',
@SPEC = '{10}',
@TANZIM = '{11}',
@TAHIESHODE = '{12}',
@CUSTCODE = '{13}',
@KALAPRICECODE = {14},
@InvCode = '{15}',
@Status = N'{16}',
@Footer = '{17}',
@Taeed='{18}',
@F01 = '{19}',
@F02 = '{20}',
@F03 = '{21}',
@F04 = '{22}',
@F05 = '{23}',
@F06 = '{24}',
@F07 = '{25}',
@F08 = '{26}',
@F09 = '{27}',
@F10 = '{28}',
@F11 = '{29}',
@F12 = '{30}',
@F13 = '{31}',
@F14 = '{32}',
@F15 = '{33}',
@F16 = '{34}',
@F17 = '{35}',
@F18 = '{36}',
@F19 = '{37}',
@F20 = '{38}',
@Tasvib = '{39}',
@OprCode = '{40}',
@MkzCode = '{41}',
@DOCNO_OUT = @DOCNO_OUT OUTPUT
SELECT 'return_value' = @return_value +'-'+ CONVERT(nvarchar, @DOCNO_OUT)" ,
aFI_IDocHi.DocNoMode,
aFI_IDocHi.InsertMode,
aFI_IDocHi.ModeCode,
aFI_IDocHi.DocNo,
aFI_IDocHi.StartNo,
aFI_IDocHi.EndNo,
aFI_IDocHi.BranchCode,
aFI_IDocHi.UserCode,
aFI_IDocHi.SerialNumber,
aFI_IDocHi.DocDate ?? string.Format("{0:yyyy/MM/dd}", DateTime.Now.AddDays(-1)),
aFI_IDocHi.Spec,
aFI_IDocHi.Tanzim,
aFI_IDocHi.TahieShode,
aFI_IDocHi.CustCode,
aFI_IDocHi.KalaPriceCode ?? 0,
aFI_IDocHi.InvCode,
aFI_IDocHi.Status,
//UnitPublic.ConvertTextWebToWin(aFI_IDocHi.Footer),
UnitPublic.ConvertTextWebToWin(aFI_IDocHi.Footer),
aFI_IDocHi.Taeed == "null" ? "" : aFI_IDocHi.Taeed,
aFI_IDocHi.F01,
aFI_IDocHi.F02,
aFI_IDocHi.F03,
aFI_IDocHi.F04,
aFI_IDocHi.F05,
aFI_IDocHi.F06,
aFI_IDocHi.F07,
aFI_IDocHi.F08,
aFI_IDocHi.F09,
aFI_IDocHi.F10,
aFI_IDocHi.F11,
aFI_IDocHi.F12,
aFI_IDocHi.F13,
aFI_IDocHi.F14,
aFI_IDocHi.F15,
aFI_IDocHi.F16,
aFI_IDocHi.F17,
aFI_IDocHi.F18,
aFI_IDocHi.F19,
aFI_IDocHi.F20,
aFI_IDocHi.Tasvib,
aFI_IDocHi.OprCode,
aFI_IDocHi.MkzCode
);
value = UnitDatabase.db.Database.SqlQuery <string>(sql).Single();
await UnitDatabase.db.SaveChangesAsync();
}
catch (Exception e)
{
throw;
}
UnitDatabase.SaveLog(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, aFI_IDocHi.SerialNumber, aFI_IDocHi.InOut == 1 ? "IIDoc" : "IODoc", 1, aFI_IDocHi.flagLog, 0);
return(Ok(value));
}
return(Ok(con));
}
public async Task <IHttpActionResult> PutAFI_IDocHi(string ace, string sal, string group, AFI_IDocHi aFI_IDocHi)
{
string value = "";
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (UnitDatabase.CreateConection(ace, sal, group))
{
try
{
string sql = string.Format(
@"DECLARE @return_value nvarchar(50),
@DocNo_Out int
EXEC @return_value = [dbo].[Web_SaveIDoc_HU]
@DOCNOMODE = {0},
@INSERTMODE = {1},
@MODECODE = {2} ,
@DOCNO = {3},
@STARTNO = {4},
@ENDNO = {5},
@BRANCHCODE = {6},
@USERCODE = '''{7}''',
@SERIALNUMBER = {8},
@DOCDATE = '{9}',
@DOCTIME = {10},
@SPEC = '{11}',
@MDOCDATE = {12},
@TANZIM = {13},
@TAHIESHODE = {14},
@CUSTCODE = '{15}',
@KALAPRICECODE = {16},
@InvCode = '{17}',
@Status = '{18}',
@Footer = '{19}',
@Taeed={20},
@DOCNO_OUT = @DOCNO_OUT OUTPUT
SELECT 'return_value' = @return_value +'-'+ CONVERT(nvarchar, @DOCNO_OUT)" ,
aFI_IDocHi.DocNoMode,
aFI_IDocHi.InsertMode,
aFI_IDocHi.ModeCode,
aFI_IDocHi.DocNo,
aFI_IDocHi.StartNo,
aFI_IDocHi.EndNo,
aFI_IDocHi.BranchCode,
aFI_IDocHi.UserCode,
aFI_IDocHi.SerialNumber,
aFI_IDocHi.DocDate ?? string.Format("{ 0:yyyy/MM/dd}", DateTime.Now.AddDays(-1)),
aFI_IDocHi.DocTime,
aFI_IDocHi.Spec,
aFI_IDocHi.mDocDate, // DateTime.Now.Date.ToString("yyyy-MM-dd HH:mm:ss"), //2018-04-03 00:00:00.000
aFI_IDocHi.Tanzim,
aFI_IDocHi.TahieShode,
aFI_IDocHi.CustCode,
aFI_IDocHi.KalaPriceCode ?? 0,
aFI_IDocHi.InvCode,
aFI_IDocHi.Status,
//UnitPublic.ConvertTextWebToWin(aFI_IDocHi.Footer),
aFI_IDocHi.Footer,
aFI_IDocHi.Taeed
);
value = UnitDatabase.db.Database.SqlQuery <string>(sql).Single();
await UnitDatabase.db.SaveChangesAsync();
}
catch (Exception e)
{
throw;
}
}
return(Ok(value));
}
public async Task <IHttpActionResult> PostAFI_IDocHi(string ace, string sal, string group, AFI_IDocHi aFI_IDocHi)
{
string value = "";
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_IDocHi.SerialNumber, aFI_IDocHi.InOut == 1 ? "IIDoc" : "IODoc", 2, 0);
if (con == "ok")
{
try
{
// به دلیل اشکال در تبدیل sql کتیشن های یوز کد اینجوریه
string sql = string.Format(
@"DECLARE @return_value nvarchar(50),
@DocNo_Out int
EXEC @return_value = [dbo].[Web_SaveIDoc_HI]
@DOCNOMODE = {0},
@INSERTMODE = {1},
@MODECODE = '{2}' ,
@DOCNO = {3},
@STARTNO = {4},
@ENDNO = {5},
@BRANCHCODE = {6},
@USERCODE = '''{7}''',
@SERIALNUMBER = {8},
@DOCDATE = '{9}',
@SPEC = '{10}',
@TANZIM = '{11}',
@TAHIESHODE = '{12}',
@CUSTCODE = '{13}',
@KALAPRICECODE = {14},
@InvCode = '{15}',
@Eghdam = N'''{16}''',
@F01 = '{17}',
@F02 = '{18}',
@F03 = '{19}',
@F04 = '{20}',
@F05 = '{21}',
@F06 = '{22}',
@F07 = '{23}',
@F08 = '{24}',
@F09 = '{25}',
@F10 = '{26}',
@F11 = '{27}',
@F12 = '{28}',
@F13 = '{29}',
@F14 = '{30}',
@F15 = '{31}',
@F16 = '{32}',
@F17 = '{33}',
@F18 = '{34}',
@F19 = '{35}',
@F20 = '{36}',
@DOCNO_OUT = @DOCNO_OUT OUTPUT
SELECT 'return_value' = @return_value +'-'+ CONVERT(nvarchar, @DOCNO_OUT)" ,
aFI_IDocHi.DocNoMode,
aFI_IDocHi.InsertMode,
aFI_IDocHi.ModeCode,
aFI_IDocHi.DocNo,
aFI_IDocHi.StartNo,
aFI_IDocHi.EndNo,
aFI_IDocHi.BranchCode,
aFI_IDocHi.UserCode,
aFI_IDocHi.SerialNumber,
aFI_IDocHi.DocDate ?? string.Format("{0:yyyy/MM/dd}", DateTime.Now.AddDays(-1)),
aFI_IDocHi.Spec,
aFI_IDocHi.Tanzim,
aFI_IDocHi.TahieShode,
aFI_IDocHi.CustCode ?? "",
aFI_IDocHi.KalaPriceCode ?? 0,
aFI_IDocHi.InvCode,
aFI_IDocHi.Eghdam,
aFI_IDocHi.F01,
aFI_IDocHi.F02,
aFI_IDocHi.F03,
aFI_IDocHi.F04,
aFI_IDocHi.F05,
aFI_IDocHi.F06,
aFI_IDocHi.F07,
aFI_IDocHi.F08,
aFI_IDocHi.F09,
aFI_IDocHi.F10,
aFI_IDocHi.F11,
aFI_IDocHi.F12,
aFI_IDocHi.F13,
aFI_IDocHi.F14,
aFI_IDocHi.F15,
aFI_IDocHi.F16,
aFI_IDocHi.F17,
aFI_IDocHi.F18,
aFI_IDocHi.F19,
aFI_IDocHi.F20);
value = UnitDatabase.db.Database.SqlQuery <string>(sql).Single();
if (!string.IsNullOrEmpty(value))
{
await UnitDatabase.db.SaveChangesAsync();
}
}
catch (Exception e)
{
throw;
}
string[] serials = value.Split('-');
UnitDatabase.SaveLog(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, Convert.ToInt64(serials[0]), aFI_IDocHi.InOut == 1 ? "IIDoc" : "IODoc", 2, aFI_IDocHi.flagLog, 0);
return(Ok(value));
}
return(Ok(con));
}
