public async Task <IHttpActionResult> PostWeb_FDocR(string ace, string sal, string group, FDocRObject FDocRObject)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, 0, "18", 9, 0);
if (con == "ok")
{
string sql = string.Format(CultureInfo.InvariantCulture,
@"select top(10000) * FROM dbo.Web_FDocR('{0}', '{1}','{2}') AS FDocR where 1 = 1 ",
FDocRObject.ModeCode1, FDocRObject.ModeCode2, dataAccount[2]);
sql += UnitPublic.SpiltCodeAnd("InvCode", FDocRObject.InvCode);
sql += UnitPublic.SpiltCodeAnd("KGruCode", FDocRObject.KGruCode);
sql += UnitPublic.SpiltCodeAnd("KalaCode", FDocRObject.KalaCode);
sql += UnitPublic.SpiltCodeAnd("CustCode", FDocRObject.CustCode);
sql += UnitPublic.SpiltCodeAnd("OprCode", FDocRObject.OprCode);
sql += UnitPublic.SpiltCodeAnd("MkzCode", FDocRObject.MkzCode);
if (FDocRObject.azTarikh != "")
{
sql += string.Format(" and DocDate >= '{0}' ", FDocRObject.azTarikh);
}
if (FDocRObject.taTarikh != "")
{
sql += string.Format(" and DocDate <= '{0}' ", FDocRObject.taTarikh);
}
var listFDocR = UnitDatabase.db.Database.SqlQuery <Web_FDocR>(sql);
return(Ok(listFDocR));
}
return(Ok(con));
}
public async Task <IHttpActionResult> PostWeb_TestMoveFactor(string ace, string sal, string group, long serialNumber, string ModeCode)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, serialNumber, "", 0, 0);
if (con == "ok")
{
string sql = string.Format(CultureInfo.InvariantCulture,
@"DECLARE @retval nvarchar(250)
EXEC [dbo].[Web_TestFDoc_Move]
@serialNumber = {0},
@MoveToModeCode = '{1}',
@retval = @retval OUTPUT
SELECT @retval as N'@retval'" ,
serialNumber,
ModeCode);
try
{
var result = UnitDatabase.db.Database.SqlQuery <string>(sql).ToList();
return(Ok(result));
// return Ok("");
}
catch (Exception e)
{
throw;
}
}
return(Ok(con));
}
public async Task <IHttpActionResult> DeleteAFI_FDocBi(string ace, string sal, string group, long SerialNumber, int BandNo, string ModeCode, string FlagLog)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, SerialNumber, ModeCode, 6, BandNo);
if (con == "ok")
{
try
{
// Fct5: 'Fct5DocB' 'Radif'
// Inv5: 'Inv5DocB' 'Radif'
// Afi1: 'Afi1FDocB' 'BandNo'
//var list = UnitDatabase.db.AFI_FDocBi.First(c=>c.SerialNumber == SerialNumber && c.BandNo==BandNo);
//if (list == null)
//{
// return NotFound();
//}
string sql = string.Format(@"DECLARE @return_value int
EXEC @return_value = [dbo].[Web_SaveFDoc_BD]
@SerialNumber = {0},
@BandNo = {1}
SELECT 'Return Value' = @return_value",
SerialNumber,
BandNo);
int value = UnitDatabase.db.Database.SqlQuery <int>(sql).Single();
if (value == 0)
{
await UnitDatabase.db.SaveChangesAsync();
}
string sqlUpdateBand = string.Format(@"DECLARE @return_value int
EXEC @return_value = [dbo].[Web_Doc_BOrder]
@TableName = '{0}',
@SerialNumber = {1},
@BandNoFld = '{2}'
SELECT 'Return Value' = @return_value" ,
ace == "Web1" ? "Afi1FDocB" : "Fct5DocB",
SerialNumber,
ace == "Web1" ? "BandNo" : "Radif");
int valueUpdateBand = UnitDatabase.db.Database.SqlQuery <int>(sqlUpdateBand).Single();
//await UnitDatabase.db.SaveChangesAsync();
}
catch (Exception e)
{
throw;
}
string sql1 = string.Format(@"SELECT SerialNumber,BandNo,KalaCode,KalaName,MainUnit,MainUnitName,Amount1,Amount2,Amount3,UnitPrice,TotalPrice,Discount,Comm,Up_Flag,KalaDeghatR1,KalaDeghatR2,KalaDeghatR3,KalaDeghatM1,KalaDeghatM2,KalaDeghatM3,DeghatR
FROM Web_FDocB WHERE SerialNumber = {0}", SerialNumber.ToString());
var listFactor = UnitDatabase.db.Database.SqlQuery <Web_FDocB>(sql1);
UnitDatabase.SaveLog(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, SerialNumber, ModeCode, 1, FlagLog, 0);
return(Ok(listFactor));
}
return(Ok(con));
}
public async Task <IHttpActionResult> PostWeb_ADocR(string ace, string sal, string group, ADocRObject ADocRObject)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, 0, "16", 9, 0);
if (con == "ok")
{
string status = UnitPublic.SpiltCodeCama(ADocRObject.StatusCode);
string oprCode = UnitPublic.SpiltCodeCama(ADocRObject.OprCode);
string mkzCode = UnitPublic.SpiltCodeCama(ADocRObject.MkzCode);
string aModeCode = UnitPublic.SpiltCodeCama(ADocRObject.AModeCode);
string AccCode = UnitPublic.SpiltCodeCama(ADocRObject.AccCode);
string sql = string.Format(CultureInfo.InvariantCulture,
@"select top(10000) * FROM Web_ADocR({0},{1},'{2}') AS ADocR where 1 = 1 ",
ADocRObject.DispBands,
ADocRObject.JamRooz,
dataAccount[2]);
if (ADocRObject.azTarikh != "")
{
sql += string.Format(" and DocDate >= '{0}' ", ADocRObject.azTarikh);
}
if (ADocRObject.taTarikh != "")
{
sql += string.Format(" and DocDate <= '{0}' ", ADocRObject.taTarikh);
}
if (ADocRObject.azShomarh != "")
{
sql += string.Format(" and DocNo >= '{0}' ", ADocRObject.azShomarh);
}
if (ADocRObject.taShomarh != "")
{
sql += string.Format(" and DocNo <= '{0}' ", ADocRObject.taShomarh);
}
sql += UnitPublic.SpiltCodeAnd("Status", ADocRObject.StatusCode);
sql += UnitPublic.SpiltCodeAnd("ModeCode", ADocRObject.AModeCode);
sql += UnitPublic.SpiltCodeAnd("OprCode", ADocRObject.OprCode);
sql += UnitPublic.SpiltCodeAnd("MkzCode", ADocRObject.MkzCode);
sql += UnitPublic.SpiltCodeLike("AccCode", ADocRObject.AccCode);
sql += " order by DocNo,BandNo";
var listADocR = UnitDatabase.db.Database.SqlQuery <Web_ADocR>(sql);
return(Ok(listADocR));
}
return(Ok(con));
}
public IQueryable <Web_CheckStatus> GetWeb_CheckStatus(string ace, string sal, string group, int PDMode, int Report)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, 0, "", 0, 0);
if (con == "ok")
{
return(UnitDatabase.db.Web_CheckStatus.Where(c => c.PDMode == PDMode && c.Report == Report));
}
return(null);
}
public async Task <IQueryable <Web_FDocH> > GetWeb_FDocH(string ace, string sal, string group, long serialNumber, string ModeCode)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, serialNumber, "", 0, 0);
if (con == "ok")
{
var a = UnitDatabase.db.Web_FDocH.Where(c => c.SerialNumber == serialNumber && c.ModeCode == ModeCode);
return(a);
}
return(null);
}
public async Task <IHttpActionResult> GetAllWeb_FDocP(string ace, string sal, string group, long SerialNumber)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, SerialNumber, "", 0, 0);
if (con == "ok")
{
string sql = string.Format(@"select * from Web_FDocP where SerialNumber = {0} order by BandNo", SerialNumber);
var listFDocP = UnitDatabase.db.Database.SqlQuery <Web_FDocP>(sql);
return(Ok(listFDocP));
}
return(Ok(con));
}
public async Task <IHttpActionResult> GetWeb_FDocHCount(string ace, string sal, string group, string ModeCode)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, 0, "", 0, 0);
if (con == "ok")
{
string sql = string.Format(@"SELECT count(SerialNumber) FROM Web_FDocH WHERE ModeCode = '{0}'", ModeCode);
int count = UnitDatabase.db.Database.SqlQuery <int>(sql).Single();
return(Ok(count));
}
return(Ok(con));
}
public async Task <IHttpActionResult> GetWeb_AMode(string ace, string sal, string group)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, 0, "", 0, 0);
if (con == "ok")
{
string sql = "SELECT * FROM Web_AMode";
var listAMode = UnitDatabase.db.Database.SqlQuery <Web_AMode>(sql);
return(Ok(listAMode));
}
return(Ok(con));
}
public async Task <IHttpActionResult> GetWeb_ADocB(string ace, string sal, string group, long serialNumber)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, serialNumber, "", 0, 0);
if (con == "ok")
{
string sql = string.Format(@"SELECT * FROM Web_ADocB WHERE SerialNumber = {0}", serialNumber);
var listSanad = UnitDatabase.db.Database.SqlQuery <Web_ADocB>(sql);
return(Ok(listSanad));
}
return(Ok(con));
}
public async Task <IHttpActionResult> GetWeb_Jari(string ace, string sal, string group)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, 0, "", 0, 0);
if (con == "ok")
{
string sql = string.Format(@"SELECT distinct Jari as name FROM Web_CheckList where Jari <> ''");
var listJari = UnitDatabase.db.Database.SqlQuery <Web_ValueBank>(sql);
return(Ok(listJari));
}
return(Ok(con));
}
public async Task <IHttpActionResult> GetWeb_FDocB(string ace, string sal, string group, long serialNumber)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, serialNumber, "", 0, 0);
if (con == "ok")
{
string sql = string.Format(@"SELECT SerialNumber,BandNo,KalaCode,KalaName,MainUnit,MainUnitName,Amount1,Amount2,Amount3,UnitPrice,TotalPrice,Discount,Comm,Up_Flag,KalaDeghatR1,KalaDeghatR2,KalaDeghatR3,KalaDeghatM1,KalaDeghatM2,KalaDeghatM3,DeghatR
FROM Web_FDocB WHERE SerialNumber = {0}", serialNumber);
var listFactor = UnitDatabase.db.Database.SqlQuery <Web_FDocB>(sql);
return(Ok(listFactor));
}
return(Ok(con));
}
public async Task <IHttpActionResult> GetWeb_FDocHLastDate(string ace, string sal, string group, string ModeCode)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, 0, "", 0, 0);
if (con == "ok")
{
string sql = string.Format(@"EXEC[dbo].[Web_Doc_Dates]
@TableName = '{0}',
@Mode = '''{1}'''" , "fct5doch", ModeCode);
string lastdate = UnitDatabase.db.Database.SqlQuery <string>(sql).Single();
return(Ok(lastdate));
}
return(Ok(con));
}
public async Task <IHttpActionResult> PostWeb_ChangeStatus(string ace, string sal, string group, AFI_StatusChange AFI_StatusChange)
{
int value = 0;
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_StatusChange.SerialNumber, "Adoc", 0, 0);
if (con == "ok")
{
try
{
string sql = string.Format(CultureInfo.InvariantCulture,
@"DECLARE @return_value int
EXEC @return_value = [dbo].[Web_SaveADoc_Status]
@DMode = {0},
@UserCode = N'{1}',
@SerialNumber = {2},
@Status = N'{3}'
SELECT 'Return Value' = @return_value" ,
AFI_StatusChange.DMode,
AFI_StatusChange.UserCode,
AFI_StatusChange.SerialNumber,
AFI_StatusChange.Status);
value = UnitDatabase.db.Database.SqlQuery <int>(sql).Single();
if (value == 0)
{
await UnitDatabase.db.SaveChangesAsync();
}
}
catch (Exception)
{
throw;
}
UnitDatabase.SaveLog(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, AFI_StatusChange.SerialNumber, "ADoc", 7, "Y", 0);
return(Ok(200));
}
else
{
return(Ok(con));
}
}
public async Task <IHttpActionResult> PostWeb_Dftr(string ace, string sal, string group, DftrObject DftrObject)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, 0, "15", 9, 0);
if (con == "ok")
{
// string status = UnitPublic.SpiltCodeCama(DftrObject.StatusCode);
//string oprCode = UnitPublic.SpiltCodeCama(DftrObject.OprCode);
// string mkzCode = UnitPublic.SpiltCodeCama(DftrObject.MkzCode);
//string aModeCode = UnitPublic.SpiltCodeCama(DftrObject.AModeCode);
string sql = string.Format(CultureInfo.InvariantCulture,
@"select top(10000) * FROM Web_Dftr('{0}','{1}',{2},'{3}',{4},{5},'{6}') AS Dftr where 1 = 1 and best >= 0 ",
DftrObject.azTarikh,
DftrObject.taTarikh,
DftrObject.Naghl,
DftrObject.AccCode,
DftrObject.DispBands,
DftrObject.JamRooz,
dataAccount[2]);
if (DftrObject.azShomarh != "")
{
sql += string.Format(" and DocNo >= '{0}' ", DftrObject.azShomarh);
}
if (DftrObject.taShomarh != "")
{
sql += string.Format(" and DocNo <= '{0}' ", DftrObject.taShomarh);
}
sql += UnitPublic.SpiltCodeAnd("Status", DftrObject.StatusCode);
sql += UnitPublic.SpiltCodeAnd("ModeCode", DftrObject.AModeCode);
sql += UnitPublic.SpiltCodeAnd("OprCode", DftrObject.OprCode);
sql += UnitPublic.SpiltCodeAnd("MkzCode", DftrObject.MkzCode);
sql += " order by bodytag";
var listDftr = UnitDatabase.db.Database.SqlQuery <Web_Dftr>(sql);
return(Ok(listDftr));
}
return(Ok(con));
}
public async Task <IHttpActionResult> PostWeb_SaveFDoc_HZ(string ace, string sal, string group, AFI_SaveFDoc_HZ AFI_SaveFDoc_HZ)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, 0, "", 0, 0);
if (con == "ok")
{
string sql = string.Format(CultureInfo.InvariantCulture,
@"DECLARE @return_value int
EXEC @return_value = [dbo].[Web_SaveFDoc_HZ]
@SerialNumber = {0},
@Tanzim = '{1}'
SELECT 'Return Value' = @return_value " ,
AFI_SaveFDoc_HZ.SerialNumber, AFI_SaveFDoc_HZ.Tanzim);
var result = UnitDatabase.db.Database.SqlQuery <int>(sql).ToList();
return(Ok("ok"));
}
return(Ok(con));
}
public async Task <IHttpActionResult> PostWeb_TrzFKala(string ace, string sal, string group, TrzFKalaObject TrzFKalaObject)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, 0, "19", 9, 0);
if (con == "ok")
{
string oprCode = UnitPublic.SpiltCodeCama(TrzFKalaObject.OprCode);
string mkzCode = UnitPublic.SpiltCodeCama(TrzFKalaObject.MkzCode);
string custCode = UnitPublic.SpiltCodeCama(TrzFKalaObject.CustCode);
string cGruCode = UnitPublic.SpiltCodeCama(TrzFKalaObject.CGruCode);
string invCode = UnitPublic.SpiltCodeCama(TrzFKalaObject.InvCode);
string statusCode = UnitPublic.SpiltCodeCama(TrzFKalaObject.StatusCode);
string sql = string.Format(CultureInfo.InvariantCulture,
@"select top (10000) * FROM dbo.Web_TrzFKala('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}',{12},'{13}') AS TrzFKala where 1 = 1 ",
TrzFKalaObject.ModeCode1,
TrzFKalaObject.ModeCode2,
TrzFKalaObject.azTarikh,
TrzFKalaObject.taTarikh,
TrzFKalaObject.azShomarh,
TrzFKalaObject.taShomarh,
custCode,
cGruCode,
mkzCode,
oprCode,
invCode,
statusCode,
TrzFKalaObject.ZeroValue,
dataAccount[2]
);
sql += UnitPublic.SpiltCodeAnd("KalaCode", TrzFKalaObject.KalaCode);
sql += UnitPublic.SpiltCodeAnd("KGruCode", TrzFKalaObject.KGruCode);
var listTrzFKala = UnitDatabase.db.Database.SqlQuery <Web_TrzFKala>(sql);
return(Ok(listTrzFKala));
}
return(Ok(con));
}
public async Task <IHttpActionResult> PostWeb_TestFDoc_Delete(string ace, string sal, string group, TestFDoc_DeleteObject TestFDoc_DeleteObject)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, 0, "", 0, 0);
if (con == "ok")
{
string sql = string.Format(CultureInfo.InvariantCulture,
@"EXEC [dbo].[Web_TestFDoc_Delete] @serialNumber = {0}, @UserCode = '{1}' ", TestFDoc_DeleteObject.SerialNumber, dataAccount[2]);
try
{
var result = UnitDatabase.db.Database.SqlQuery <TestFDoc_Delete>(sql).ToList();
var jsonResult = JsonConvert.SerializeObject(result);
return(Ok(jsonResult));
}
catch (Exception e)
{
throw;
}
}
return(Ok(con));
}
public async Task <IHttpActionResult> PostWeb_IMode(string ace, string sal, string group, IModeObject iModeObject)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, 0, "", 0, 0);
if (con == "ok")
{
string sql;
if (iModeObject.InOut == 0)
{
sql = string.Format(@"SELECT * FROM Web_IMode_F({0},'{1}') order by OrderFld ", iModeObject.Mode, iModeObject.UserCode);
}
else
{
sql = string.Format(@"SELECT * FROM Web_IMode_F({0},'{1}') WHERE InOut = {2} order by OrderFld ", iModeObject.Mode, iModeObject.UserCode, iModeObject.InOut);
}
var listIMode = UnitDatabase.db.Database.SqlQuery <Web_IMode>(sql);
return(Ok(listIMode));
}
return(Ok(con));
}
public async Task <IHttpActionResult> GetWeb_FMode(string ace, string sal, string group, int InOut)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, 0, "", 0, 0);
if (con == "ok")
{
string sql;
if (InOut == 0)
{
sql = string.Format(@"SELECT * FROM Web_FMode order by OrderFld ");
}
else
{
sql = string.Format(@"SELECT * FROM Web_FMode WHERE InOut = {0} order by OrderFld ", InOut);
}
var listFMode = UnitDatabase.db.Database.SqlQuery <Web_FMode>(sql);
return(Ok(listFMode));
}
return(Ok(con));
}
public async Task <IHttpActionResult> PostWeb_UpdatePriceAnbar(string ace, string sal, string group, long serialnumber)
{
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, serialnumber, "", 0, 0);
if (con == "ok")
{
try
{
string sql = string.Format(CultureInfo.InvariantCulture,
@"DECLARE @return_value int
EXEC @return_value = [dbo].[Web_IDocB_SetKalaPrice]
@SerialNumber = {0}
SELECT 'Return Value' = @return_value",
serialnumber);
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}", serialnumber);
var listIDocB = UnitDatabase.db.Database.SqlQuery <Web_IDocB>(sql1);
return(Ok(listIDocB));
}
return(Ok(con));
}