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_Krdx(string ace, string sal, string group, KrdxObject KrdxObject)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, 0, "21", 9, 0);
if (con == "ok")
{
string invCode = UnitPublic.SpiltCodeCama(KrdxObject.InvCode);
string sql = string.Format(CultureInfo.InvariantCulture,
@"select * from (select top (10000) * FROM dbo.Web_Krdx('{0}', '{1}',{2},'{3}','{4}','{5}') AS Krdx where 1 = 1 ",
KrdxObject.azTarikh,
KrdxObject.taTarikh,
KrdxObject.Naghl,
KrdxObject.KalaCode,
invCode,
dataAccount[2]);
sql += UnitPublic.SpiltCodeAnd("KGruCode", KrdxObject.KGruCode);
sql += UnitPublic.SpiltCodeAnd("ThvlCode", KrdxObject.ThvlCode);
sql += UnitPublic.SpiltCodeAnd("OprCode", KrdxObject.OprCode);
sql += UnitPublic.SpiltCodeAnd("MkzCode", KrdxObject.MkzCode);
sql += UnitPublic.SpiltCodeAnd("Status", KrdxObject.StatusCode);
sql += UnitPublic.SpiltCodeAnd("ModeCode", KrdxObject.ModeCode);
sql += "or BodyTag = 0 order by BodyTag,DocNo ";
sql += " ) as a where VAmount1 is not null";
var listKrdx = UnitDatabase.db.Database.SqlQuery <Web_Krdx>(sql);
return(Ok(listKrdx));
}
return(Ok(con));
}
public async Task <IHttpActionResult> PostWeb_IDocR(string ace, string sal, string group, IDocRObject IDocRObject)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, 0, "24", 9, 0);
if (con == "ok")
{
string sql = string.Format(CultureInfo.InvariantCulture,
@"select top (10000) * FROM dbo.Web_IDocR('{0}', '{1}','{2}') AS IDocR where 1 = 1 ",
IDocRObject.azTarikh, IDocRObject.taTarikh, dataAccount[2]);
sql += UnitPublic.SpiltCodeAnd("InvCode", IDocRObject.InvCode);
sql += UnitPublic.SpiltCodeAnd("KGruCode", IDocRObject.KGruCode);
sql += UnitPublic.SpiltCodeAnd("KalaCode", IDocRObject.KalaCode);
sql += UnitPublic.SpiltCodeAnd("ThvlCode", IDocRObject.ThvlCode);
sql += UnitPublic.SpiltCodeAnd("OprCode", IDocRObject.OprCode);
sql += UnitPublic.SpiltCodeAnd("MkzCode", IDocRObject.MkzCode);
sql += UnitPublic.SpiltCodeAnd("Status", IDocRObject.StatusCode);
sql += UnitPublic.SpiltCodeAnd("ModeCode", IDocRObject.ModeCode);
if (IDocRObject.DocNo > 0)
{
sql += " and DocNo = " + IDocRObject.DocNo;
}
sql += " order by DocNo ";
var listIDocR = UnitDatabase.db.Database.SqlQuery <Web_IDocR>(sql);
return(Ok(listIDocR));
}
return(Ok(con));
}
public async Task <IHttpActionResult> PostWeb_TrzIKalaExf(string userName, string password, string ace, string sal, string group, TrzIExfObject TrzIExfObject)
{
if (UnitDatabase.CreateConection(userName, password, ace, sal, group))
{
string invCode = UnitPublic.SpiltCodeCama(TrzIExfObject.InvCode);
string sql = string.Format(CultureInfo.InvariantCulture,
@"select * FROM dbo.Web_TrzIKalaExf('{0}', '{1}','{2}') AS TrzIExf where 1 = 1 ",
TrzIExfObject.azTarikh, TrzIExfObject.taTarikh, invCode);
if (TrzIExfObject.KGruCode != "0")
{
sql += string.Format(" and KGruCode = '{0}' ", TrzIExfObject.KGruCode);
}
// sql += UnitPublic.SpiltCodeAnd("InvCode", TrzIExfObject.InvCode);
sql += UnitPublic.SpiltCodeAnd("KalaCode", TrzIExfObject.KalaCode);
sql += " order by KalaCode,KalaFileNo,KalaState,KalaExf1,KalaExf2,KalaExf3,KalaExf4,KalaExf5,KalaExf6,KalaExf7,KalaExf8,KalaExf9,KalaExf10,KalaExf11,KalaExf12,KalaExf13,KalaExf14,KalaExf15,InvCode,Tag ";
var listTrzIExf = UnitDatabase.db.Database.SqlQuery <Web_TrzIKalaExf>(sql);
return(Ok(listTrzIExf));
}
return(null);
}
public async Task <IHttpActionResult> PostWeb_ErjDocB_Last(string userName, string password, string ace, string sal, string group, ErjDocB_Last ErjDocB_Last)
{
if (UnitDatabase.CreateConection(userName, password, ace, sal, group))
{
string sql = string.Format(CultureInfo.InvariantCulture,
@"select * FROM Web_ErjDocB_Last({0}, {1},'{2}','{3}','{4}') AS ErjDocK where 1 = 1 "
, ErjDocB_Last.erjaMode
, ErjDocB_Last.docBMode
, ErjDocB_Last.fromUserCode
, ErjDocB_Last.toUserCode
, ErjDocB_Last.srchSt);
if (ErjDocB_Last.azDocDate != "")
{
sql += string.Format(" and DocDate >= '{0}' ", ErjDocB_Last.azDocDate);
}
if (ErjDocB_Last.taDocDate != "")
{
sql += string.Format(" and DocDate <= '{0}' ", ErjDocB_Last.taDocDate);
}
if (ErjDocB_Last.azRjDate != "")
{
sql += string.Format(" and RjDate >= '{0}' ", ErjDocB_Last.azRjDate);
}
if (ErjDocB_Last.taRjDate != "")
{
sql += string.Format(" and RjDate <= '{0}' ", ErjDocB_Last.taRjDate);
}
if (ErjDocB_Last.azMhltDate != "")
{
sql += string.Format(" and MhltDate >= '{0}' ", ErjDocB_Last.azMhltDate);
}
if (ErjDocB_Last.taMhltDate != "")
{
sql += string.Format(" and MhltDate <= '{0}' ", ErjDocB_Last.taMhltDate);
}
if (ErjDocB_Last.status != "")
{
sql += string.Format(" and Status = '{0}' ", ErjDocB_Last.status);
}
sql += UnitPublic.SpiltCodeAnd("KhdtCode", ErjDocB_Last.khdtCode);
sql += UnitPublic.SpiltCodeAnd("CustCode", ErjDocB_Last.custCode);
var listErjDocB_Last = UnitDatabase.db.Database.SqlQuery <Web_ErjDocB_Last>(sql);
return(Ok(listErjDocB_Last));
}
return(null);
}
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 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_TChk(string ace, string sal, string group, TChkObject TChkObject)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, 0, "17", 9, 0);
if (con == "ok")
{
string sql = string.Format(CultureInfo.InvariantCulture,
@"select top(10000) * FROM Web_TChk('{0}') AS TChk where 1 = 1", dataAccount[2]);
sql += string.Format(" and PDMode = {0} ", TChkObject.PDMode);
if (TChkObject.azTarikh != "")
{
sql += string.Format(" and CheckDate >= '{0}' ", TChkObject.azTarikh);
}
if (TChkObject.taTarikh != "")
{
sql += string.Format(" and CheckDate <= '{0}' ", TChkObject.taTarikh);
}
if (TChkObject.azShomarh != "")
{
sql += string.Format(" and CheckNo >= {0} ", TChkObject.azShomarh);
}
if (TChkObject.taShomarh != "")
{
sql += string.Format(" and CheckNo <= {0} ", TChkObject.taShomarh);
}
sql += UnitPublic.SpiltCodeAnd("CheckStatus", TChkObject.CheckStatus);
sql += UnitPublic.SpiltCodeLike("AccCode", TChkObject.AccCode);
sql += " order by CheckNo,Bank,Shobe";
var listTChk = UnitDatabase.db.Database.SqlQuery <Web_TChk>(sql);
return(Ok(listTChk));
}
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_TrzIKalaExf(string ace, string sal, string group, TrzIExfObject TrzIExfObject)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, 0, "23", 9, 0);
if (con == "ok")
{
string modeCode = UnitPublic.SpiltCodeCama(TrzIExfObject.ModeCode);
string kGruCode = UnitPublic.SpiltCodeCama(TrzIExfObject.KGruCode);
string thvlCode = UnitPublic.SpiltCodeCama(TrzIExfObject.ThvlCode);
string tGruCode = UnitPublic.SpiltCodeCama(TrzIExfObject.TGruCode);
string oprCode = UnitPublic.SpiltCodeCama(TrzIExfObject.OprCode);
string mkzCode = UnitPublic.SpiltCodeCama(TrzIExfObject.MkzCode);
string invCode = UnitPublic.SpiltCodeCama(TrzIExfObject.InvCode);
string statusCode = UnitPublic.SpiltCodeCama(TrzIExfObject.StatusCode);
string sql = string.Format(CultureInfo.InvariantCulture,
@"select top (10000) * FROM dbo.Web_TrzIKalaExf('{0}', '{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}') AS TrzIExf where 1 = 1 ",
TrzIExfObject.azTarikh,
TrzIExfObject.taTarikh,
modeCode,
kGruCode,
thvlCode,
tGruCode,
mkzCode,
oprCode,
invCode,
statusCode,
dataAccount[2]
);
sql += UnitPublic.SpiltCodeAnd("KalaCode", TrzIExfObject.KalaCode);
sql += " order by KalaCode,KalaFileNo,KalaState,KalaExf1,KalaExf2,KalaExf3,KalaExf4,KalaExf5,KalaExf6,KalaExf7,KalaExf8,KalaExf9,KalaExf10,KalaExf11,KalaExf12,KalaExf13,KalaExf14,KalaExf15,InvCode,Tag ";
var listTrzIExf = UnitDatabase.db.Database.SqlQuery <Web_TrzIKalaExf>(sql);
return(Ok(listTrzIExf));
}
return(Ok(con));
}
public async Task <IHttpActionResult> PostWeb_TrzAcc(string ace, string sal, string group, TrzAccObject TrzAccObject)
{
var dataAccount = UnitDatabase.ReadUserPassHeader(this.Request.Headers);
string con = UnitDatabase.CreateConection(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, 0, "14", 9, 0);
if (con == "ok")
{
string oprCode = UnitPublic.SpiltCodeCama(TrzAccObject.OprCode);
string mkzCode = UnitPublic.SpiltCodeCama(TrzAccObject.MkzCode);
string aModeCode = UnitPublic.SpiltCodeCama(TrzAccObject.AModeCode);
string sql = string.Format(CultureInfo.InvariantCulture,
@"select * FROM dbo.Web_TrzAcc({0}, '{1}','{2}','{3}','{4}', '{5}','{6}') AS TrzAcc where 1 = 1 ",
TrzAccObject.Level,
TrzAccObject.azTarikh,
TrzAccObject.taTarikh,
oprCode,
mkzCode,
aModeCode,
dataAccount[2]);
if (TrzAccObject.Sath == 1)
{
sql += string.Format(" and (Level = {0})", TrzAccObject.Level);
}
else
{
sql += string.Format(" and (Level <= {0})", TrzAccObject.Level);
}
sql += UnitPublic.SpiltCodeLike("AccCode", TrzAccObject.AccCode);
sql += " order by SortAccCode";
var listTrzAcc = UnitDatabase.db.Database.SqlQuery <Web_TrzAcc>(sql);
return(Ok(listTrzAcc));
}
return(Ok(con));
}
public async Task <IHttpActionResult> PostWeb_ErjDocK(string userName, string password, string ace, string sal, string group, ErjDocKObject ErjDocKObject)
{
if (UnitDatabase.CreateConection(userName, password, ace, sal, group))
{
string sql = string.Format(CultureInfo.InvariantCulture,
@"select * FROM Web_ErjDocK('{0}') AS ErjDocK where 1 = 1",
ErjDocKObject.SrchSt);
if (ErjDocKObject.userMode == "USER")
{
sql += string.Format(" and Eghdam = '{0}' ", ErjDocKObject.userName);
}
if (ErjDocKObject.azTarikh != "")
{
sql += string.Format(" and DocDate >= '{0}' ", ErjDocKObject.azTarikh);
}
if (ErjDocKObject.taTarikh != "")
{
sql += string.Format(" and DocDate <= '{0}' ", ErjDocKObject.taTarikh);
}
if (ErjDocKObject.Status != "")
{
sql += string.Format(" and Status = '{0}' ", ErjDocKObject.Status);
}
sql += UnitPublic.SpiltCodeAnd("CustCode", ErjDocKObject.CustCode);
sql += UnitPublic.SpiltCodeAnd("KhdtCode", ErjDocKObject.KhdtCode);
var listTrzI = UnitDatabase.db.Database.SqlQuery <Web_ErjDocK>(sql);
return(Ok(listTrzI));
}
return(null);
}
public async Task <IHttpActionResult> PostWeb_TrzIKala(string userName, string password, string ace, string sal, string group, TrzIObject TrzIObject)
{
if (UnitDatabase.CreateConection(userName, password, ace, sal, group))
{
string sql = string.Format(CultureInfo.InvariantCulture,
@"select * FROM dbo.Web_TrzIKala('{0}', '{1}') AS TrzI where 1 = 1 ",
TrzIObject.azTarikh, TrzIObject.taTarikh);
//if (TrzIObject.InvCode != "0")
// sql += string.Format(" and InvCode = '{0}' ", TrzIObject.InvCode);
if (TrzIObject.KGruCode != "0")
{
sql += string.Format(" and KGruCode = '{0}' ", TrzIObject.KGruCode);
}
sql += UnitPublic.SpiltCodeAnd("InvCode", TrzIObject.InvCode);
sql += UnitPublic.SpiltCodeAnd("KalaCode", TrzIObject.KalaCode);
var listTrzI = UnitDatabase.db.Database.SqlQuery <Web_TrzIKala>(sql);
return(Ok(listTrzI));
}
return(null);
}
public ActionResult LoginGuouhfgr(string userName, string password)
{
if (string.IsNullOrEmpty(userName))
{
return(JavaScript(UnitSweet2.ShowMessage(3, "خطا در ورود اطلاعات", "نام کاربری را وارد کنید")));
}
if (string.IsNullOrEmpty(password))
{
return(JavaScript(UnitSweet2.ShowMessage(3, "خطا در ورود اطلاعات", "کلمه عبور را وارد کنید")));
}
if (UnitDatabase.CreateConection("", "", ""))
{
try
{
//var list = from p in UnitDatabase.db.AccessSet where p.Email == userName && p.Pass == password select p;
var list = UnitDatabase.db.Access.First(c => c.UserName == userName && c.Password == password);
if (list.Id > 0)
{
if (UnitPublic.UserInformation(list.ACC_Group, list.INV_Group, list.FCT_Group, list.AFI_Group))
{
//string a = UnitPublic.Encrypt(password);
//string b = UnitPublic.Decrypt(a);
UnitPublic.apiAddress = list.AddressApi;
UnitPublic.afiAccess = list.AFI_Access.ToCharArray();
//return JavaScript("document.location.replace('" + Url.Action("index", "Home") + "');");
return(JavaScript(
" localStorage.setItem('ApiAddress'," + "'" + list.AddressApi + "'" + ");" +
" localStorage.setItem('User'," + userName + ");" +
" localStorage.setItem('Pass'," + password + ");" +
" localStorage.setItem('AFI_Access'," + "'" + list.AFI_Access + "'" + ");" +
" localStorage.setItem('AceList'," + "'" + Json(UnitPublic.aceList) + "'" + ");" +
" localStorage.setItem('afiGroup'," + "'" + Json(UnitPublic.afiList) + "'" + ");" +
" localStorage.setItem('fctGroup'," + "'" + Json(UnitPublic.fctList) + "'" + ");" +
" localStorage.setItem('invGroup'," + "'" + Json(UnitPublic.invList) + "'" + ");" +
" localStorage.setItem('accGroup'," + "'" + Json(UnitPublic.accList) + "'" + ");" +
UnitSweet2.ShowMessage(0, "عملیات موفق", "اتصال برقرار شد")));
}
else
{
return(JavaScript(
" localStorage.setItem('ApiAddress'," + "''" + ");" +
UnitSweet2.ShowMessage(1, "خطا", "اطلاعات کاربر یافت نشد")));
}
}
else
{
return(JavaScript(
" localStorage.setItem('ApiAddress'," + "''" + ");" +
UnitSweet2.ShowMessage(3, "خطا", "نام کاربری یا کلمه عبور اشتباه است")));
}
}
catch (Exception e)
{
return(JavaScript(
" localStorage.setItem('ApiAddress'," + "''" + ");" +
UnitSweet2.ShowMessage(1, "خطا", "نام کاربری یا کلمه عبور اشتباه است")));
}
}
else
{
return(JavaScript(UnitSweet2.ShowMessage(1, "خطا", "ارتباط برقرار نشد")));
}
}
public async Task <IHttpActionResult> PostErjDocH(string ace, string sal, string group, ErjDocH erjDocH)
{
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, erjDocH.SerialNumber, "", 2, 0);
if (con == "ok")
{
try
{
string sql = string.Format(
@"DECLARE @return_value int,
@DocNo_Out int
EXEC @return_value = [dbo].[Web_ErjSaveDoc_HI]
@ModeCode = '{0}',
@DocNo = {1},
@SerialNumber = {2},
@DocDate = '{3}',
@MhltDate = '{4}',
@AmalDate = '{5}',
@EndDate = '{6}',
@BranchCode = {7},
@UserCode = '{8}',
@Eghdam = N'{9}',
@Tanzim = '{10}',
@TahieShode = '{11}',
@Status = '{12}',
@Spec = '{13}',
@CustCode = '{14}',
@KhdtCode = '{15}',
@EghdamComm = '{16}',
@DocDesc = '{17}',
@FinalComm = '{18}',
@SpecialComm = '{19}',
@RelatedDocs = '{20}',
@Mahramaneh = {21},
@F01 = '{22}',
@F02 = '{23}',
@F03 = '{24}',
@F04 = '{25}',
@F05 = '{26}',
@F06 = '{27}',
@F07 = '{28}',
@F08 = '{29}',
@F09 = '{30}',
@F10 = '{31}',
@F11 = '{32}',
@F12 = '{33}',
@F13 = '{34}',
@F14 = '{35}',
@F15 = '{36}',
@F16 = '{37}',
@F17 = '{38}',
@F18 = '{39}',
@F19 = '{40}',
@F20 = '{41}',
@DocNo_Out = @DocNo_Out OUTPUT
SELECT @DocNo_Out as '@DocNo_Out' " ,
erjDocH.ModeCode,
erjDocH.DocNo,
erjDocH.SerialNumber,
erjDocH.DocDate ?? string.Format("{0:yyyy/MM/dd}", DateTime.Now.AddDays(-1)),
erjDocH.MhltDate,
erjDocH.AmalDate,
erjDocH.EndDate,
erjDocH.BranchCode,
erjDocH.UserCode,
erjDocH.Eghdam,
erjDocH.Tanzim,
erjDocH.TahieShode,
erjDocH.Status,
erjDocH.Spec,
erjDocH.CustCode ?? "",
erjDocH.KhdtCode ?? "",
UnitPublic.ConvertTextWebToWin(erjDocH.EghdamComm),
UnitPublic.ConvertTextWebToWin(erjDocH.DocDesc),
UnitPublic.ConvertTextWebToWin(erjDocH.FinalComm),
UnitPublic.ConvertTextWebToWin(erjDocH.SpecialComm),
erjDocH.RelatedDocs ?? "",
erjDocH.Mahramaneh,
erjDocH.F01,
erjDocH.F02,
erjDocH.F03,
erjDocH.F04,
erjDocH.F05,
erjDocH.F06,
erjDocH.F07,
erjDocH.F08,
erjDocH.F09,
erjDocH.F10,
erjDocH.F11,
erjDocH.F12,
erjDocH.F13,
erjDocH.F14,
erjDocH.F15,
erjDocH.F16,
erjDocH.F17,
erjDocH.F18,
erjDocH.F19,
erjDocH.F20);
value = UnitDatabase.db.Database.SqlQuery <int>(sql).Single();
if (value > 0)
{
await UnitDatabase.db.SaveChangesAsync();
}
}
catch (Exception e)
{
throw;
}
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));
}
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_FDocHi(string ace, string sal, string group, AFI_FDocHi aFI_FDocHi)
{
byte forSale;
if (aFI_FDocHi.ModeCode == "51" || aFI_FDocHi.ModeCode == "52" || aFI_FDocHi.ModeCode == "53" ||
aFI_FDocHi.ModeCode == "SPFCT" || aFI_FDocHi.ModeCode == "SFCT" || aFI_FDocHi.ModeCode == "SRFCT" || aFI_FDocHi.ModeCode == "SORD")
{
forSale = 1;
}
else
{
forSale = 0;
}
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_FDocHi.SerialNumber, aFI_FDocHi.ModeCode, 1, 0);
if (con == "ok")
{
try
{
string sql = string.Format(CultureInfo.InvariantCulture, @"EXEC [dbo].[Web_Calc_AddMin_EffPrice]
@serialNumber = {0},
@forSale = {1},
@custCode = '{2}',
@TypeJob = {3},
@Spec1 = '{4}',
@Spec2 = '{5}',
@Spec3 = '{6}',
@Spec4 = '{7}',
@Spec5 = '{8}',
@Spec6 = '{9}',
@Spec7 = '{10}',
@Spec8 = '{11}',
@Spec9 = '{12}',
@Spec10 = '{13}',
@MP1 = {14},
@MP2 = {15},
@MP3 = {16},
@MP4 = {17},
@MP5 = {18},
@MP6 = {19},
@MP7 = {20},
@MP8 = {21},
@MP9 = {22},
@MP10 = {23} " ,
aFI_FDocHi.SerialNumber,
forSale,
aFI_FDocHi.CustCode,
0,
aFI_FDocHi.AddMinSpec1,
aFI_FDocHi.AddMinSpec2,
aFI_FDocHi.AddMinSpec3,
aFI_FDocHi.AddMinSpec4,
aFI_FDocHi.AddMinSpec5,
aFI_FDocHi.AddMinSpec6,
aFI_FDocHi.AddMinSpec7,
aFI_FDocHi.AddMinSpec8,
aFI_FDocHi.AddMinSpec9,
aFI_FDocHi.AddMinSpec10,
Math.Abs(aFI_FDocHi.AddMinPrice1 ?? 0),
Math.Abs(aFI_FDocHi.AddMinPrice2 ?? 0),
Math.Abs(aFI_FDocHi.AddMinPrice3 ?? 0),
Math.Abs(aFI_FDocHi.AddMinPrice4 ?? 0),
Math.Abs(aFI_FDocHi.AddMinPrice5 ?? 0),
Math.Abs(aFI_FDocHi.AddMinPrice6 ?? 0),
Math.Abs(aFI_FDocHi.AddMinPrice7 ?? 0),
Math.Abs(aFI_FDocHi.AddMinPrice8 ?? 0),
Math.Abs(aFI_FDocHi.AddMinPrice9 ?? 0),
Math.Abs(aFI_FDocHi.AddMinPrice10 ?? 0));
var result = UnitDatabase.db.Database.SqlQuery <AddMin>(sql).Where(c => c.Name != "").ToList();
foreach (var item in result)
{
if (item.Code == 1)
{
aFI_FDocHi.AddMinPrice1 = Math.Round(item.AddMinPrice ?? 0, aFI_FDocHi.deghat);
}
if (item.Code == 2)
{
aFI_FDocHi.AddMinPrice2 = Math.Round(item.AddMinPrice ?? 0, aFI_FDocHi.deghat);
}
if (item.Code == 3)
{
aFI_FDocHi.AddMinPrice3 = Math.Round(item.AddMinPrice ?? 0, aFI_FDocHi.deghat);
}
if (item.Code == 4)
{
aFI_FDocHi.AddMinPrice4 = Math.Round(item.AddMinPrice ?? 0, aFI_FDocHi.deghat);
}
if (item.Code == 5)
{
aFI_FDocHi.AddMinPrice5 = Math.Round(item.AddMinPrice ?? 0, aFI_FDocHi.deghat);
}
if (item.Code == 6)
{
aFI_FDocHi.AddMinPrice6 = Math.Round(item.AddMinPrice ?? 0, aFI_FDocHi.deghat);
}
if (item.Code == 7)
{
aFI_FDocHi.AddMinPrice7 = Math.Round(item.AddMinPrice ?? 0, aFI_FDocHi.deghat);
}
if (item.Code == 8)
{
aFI_FDocHi.AddMinPrice8 = Math.Round(item.AddMinPrice ?? 0, aFI_FDocHi.deghat);
}
if (item.Code == 9)
{
aFI_FDocHi.AddMinPrice9 = Math.Round(item.AddMinPrice ?? 0, aFI_FDocHi.deghat);
}
if (item.Code == 10)
{
aFI_FDocHi.AddMinPrice10 = Math.Round(item.AddMinPrice ?? 0, aFI_FDocHi.deghat);
}
}
var sql1 = string.Format(CultureInfo.InvariantCulture, @"DECLARE @return_value int
EXEC @return_value = [dbo].[Web_FDocB_CalcAddMin]
@serialNumber = {0},
@deghat = {1},
@forSale = {2},
@MP1 = {3},
@MP2 = {4},
@MP3 = {5},
@MP4 = {6},
@MP5 = {7},
@MP6 = {8},
@MP7 = {9},
@MP8 = {10},
@MP9 = {11},
@MP10 = {12}
SELECT 'Return Value' = @return_value" ,
aFI_FDocHi.SerialNumber,
aFI_FDocHi.deghat,
forSale,
aFI_FDocHi.AddMinPrice1,
aFI_FDocHi.AddMinPrice2,
aFI_FDocHi.AddMinPrice3,
aFI_FDocHi.AddMinPrice4,
aFI_FDocHi.AddMinPrice5,
aFI_FDocHi.AddMinPrice6,
aFI_FDocHi.AddMinPrice7,
aFI_FDocHi.AddMinPrice8,
aFI_FDocHi.AddMinPrice9,
aFI_FDocHi.AddMinPrice10);
int test = UnitDatabase.db.Database.SqlQuery <int>(sql1).Single();
string sql2 = string.Format(CultureInfo.InvariantCulture,
@"DECLARE @return_value nvarchar(50),
@DocNo_Out nvarchar(50)
EXEC @return_value = [dbo].[Web_SaveFDoc_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}',
@VSTRCODE = {14},
@VSTRPER = {15},
@PAKHSHCODE = '{16}',
@KALAPRICECODE = {17},
@ADDMINSPEC1 = '{18}',
@ADDMINSPEC2 = '{19}',
@ADDMINSPEC3 = '{20}',
@ADDMINSPEC4 = '{21}',
@ADDMINSPEC5 = '{22}',
@ADDMINSPEC6 = '{23}',
@ADDMINSPEC7 = '{24}',
@ADDMINSPEC8 = '{25}',
@ADDMINSPEC9 = '{26}',
@ADDMINSPEC10 = '{27}',
@ADDMINPRICE1 = {28},
@ADDMINPRICE2 = {29},
@ADDMINPRICE3 = {30},
@ADDMINPRICE4 = {31},
@ADDMINPRICE5 = {32},
@ADDMINPRICE6 = {33},
@ADDMINPRICE7 = {34},
@ADDMINPRICE8 = {35},
@ADDMINPRICE9 = {36},
@ADDMINPRICE10 = {37},
@InvCode = '{38}',
@Status = N'{39}',
@PaymentType = {40},
@Footer = '{41}',
@Taeed='{42}',
@F01 = '{43}',
@F02 = '{44}',
@F03 = '{45}',
@F04 = '{46}',
@F05 = '{47}',
@F06 = '{48}',
@F07 = '{49}',
@F08 = '{50}',
@F09 = '{51}',
@F10 = '{52}',
@F11 = '{53}',
@F12 = '{54}',
@F13 = '{55}',
@F14 = '{56}',
@F15 = '{57}',
@F16 = '{58}',
@F17 = '{59}',
@F18 = '{60}',
@F19 = '{61}',
@F20 = '{62}',
@Tasvib = '{63}',
@OprCode = '{64}',
@MkzCode = '{65}',
@DOCNO_OUT = @DOCNO_OUT OUTPUT
SELECT 'return_value' = ltrim(@DOCNO_OUT)
",
aFI_FDocHi.DocNoMode,
aFI_FDocHi.InsertMode,
aFI_FDocHi.ModeCode,
aFI_FDocHi.DocNo,
aFI_FDocHi.StartNo,
aFI_FDocHi.EndNo,
aFI_FDocHi.BranchCode,
aFI_FDocHi.UserCode,
aFI_FDocHi.SerialNumber,
aFI_FDocHi.DocDate ?? string.Format("{0:yyyy/MM/dd}", DateTime.Now.AddDays(-1)),
aFI_FDocHi.Spec,
aFI_FDocHi.Tanzim,
aFI_FDocHi.TahieShode,
aFI_FDocHi.CustCode,
aFI_FDocHi.VstrCode,
aFI_FDocHi.VstrPer,
aFI_FDocHi.PakhshCode,
aFI_FDocHi.KalaPriceCode ?? 0,
aFI_FDocHi.AddMinSpec1,
aFI_FDocHi.AddMinSpec2,
aFI_FDocHi.AddMinSpec3,
aFI_FDocHi.AddMinSpec4,
aFI_FDocHi.AddMinSpec5,
aFI_FDocHi.AddMinSpec6,
aFI_FDocHi.AddMinSpec7,
aFI_FDocHi.AddMinSpec8,
aFI_FDocHi.AddMinSpec9,
aFI_FDocHi.AddMinSpec10,
Math.Abs((decimal)aFI_FDocHi.AddMinPrice1),
Math.Abs((decimal)aFI_FDocHi.AddMinPrice2),
Math.Abs((decimal)aFI_FDocHi.AddMinPrice3),
Math.Abs((decimal)aFI_FDocHi.AddMinPrice4),
Math.Abs((decimal)aFI_FDocHi.AddMinPrice5),
Math.Abs((decimal)aFI_FDocHi.AddMinPrice6),
Math.Abs((decimal)aFI_FDocHi.AddMinPrice7),
Math.Abs((decimal)aFI_FDocHi.AddMinPrice8),
Math.Abs((decimal)aFI_FDocHi.AddMinPrice9),
Math.Abs((decimal)aFI_FDocHi.AddMinPrice10),
aFI_FDocHi.InvCode,
aFI_FDocHi.Status,
aFI_FDocHi.PaymentType,
UnitPublic.ConvertTextWebToWin(aFI_FDocHi.Footer),
aFI_FDocHi.Taeed == "null" ? "" : aFI_FDocHi.Taeed,
aFI_FDocHi.F01,
aFI_FDocHi.F02,
aFI_FDocHi.F03,
aFI_FDocHi.F04,
aFI_FDocHi.F05,
aFI_FDocHi.F06,
aFI_FDocHi.F07,
aFI_FDocHi.F08,
aFI_FDocHi.F09,
aFI_FDocHi.F10,
aFI_FDocHi.F11,
aFI_FDocHi.F12,
aFI_FDocHi.F13,
aFI_FDocHi.F14,
aFI_FDocHi.F15,
aFI_FDocHi.F16,
aFI_FDocHi.F17,
aFI_FDocHi.F18,
aFI_FDocHi.F19,
aFI_FDocHi.F20,
aFI_FDocHi.Tasvib,
aFI_FDocHi.OprCode,
aFI_FDocHi.MkzCode
);
value = UnitDatabase.db.Database.SqlQuery <string>(sql2).Single();
await UnitDatabase.db.SaveChangesAsync();
}
catch (Exception e)
{
throw;
}
UnitDatabase.SaveLog(dataAccount[0], dataAccount[1], dataAccount[2], ace, sal, group, aFI_FDocHi.SerialNumber, aFI_FDocHi.ModeCode, 1, aFI_FDocHi.flagLog, 0);
return(Ok(value));
}
return(Ok(con));
}
public async Task <IHttpActionResult> PutAFI_FDocHi(string ace, string sal, string group, AFI_FDocHi aFI_FDocHi)
{
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(@"EXEC [dbo].[Web_Calc_AddMin_EffPrice]
@serialNumber = {0},
@forSale = {1},
@custCode = {2},
@TypeJob = {3},
@Spec1 = '{4}',
@Spec2 = '{5}',
@Spec3 = '{6}',
@Spec4 = '{7}',
@Spec5 = '{8}',
@Spec6 = '{9}',
@Spec7 = '{10}',
@Spec8 = '{11}',
@Spec9 = '{12}',
@Spec10 = '{13}',
@MP1 = {14},
@MP2 = {15},
@MP3 = {16},
@MP4 = {17},
@MP5 = {18},
@MP6 = {19},
@MP7 = {20},
@MP8 = {21},
@MP9 = {22},
@MP10 = {23} " ,
aFI_FDocHi.SerialNumber,
aFI_FDocHi.ModeCode < 54 ? 1 : 0,
aFI_FDocHi.CustCode ?? "null",
0,
aFI_FDocHi.AddMinSpec1,
aFI_FDocHi.AddMinSpec2,
aFI_FDocHi.AddMinSpec3,
aFI_FDocHi.AddMinSpec4,
aFI_FDocHi.AddMinSpec5,
aFI_FDocHi.AddMinSpec6,
aFI_FDocHi.AddMinSpec7,
aFI_FDocHi.AddMinSpec8,
aFI_FDocHi.AddMinSpec9,
aFI_FDocHi.AddMinSpec10,
Math.Abs(aFI_FDocHi.AddMinPrice1 ?? 0).ToString(),
Math.Abs(aFI_FDocHi.AddMinPrice2 ?? 0).ToString(),
Math.Abs(aFI_FDocHi.AddMinPrice3 ?? 0).ToString(),
Math.Abs(aFI_FDocHi.AddMinPrice4 ?? 0).ToString(),
Math.Abs(aFI_FDocHi.AddMinPrice5 ?? 0).ToString(),
Math.Abs(aFI_FDocHi.AddMinPrice6 ?? 0).ToString(),
Math.Abs(aFI_FDocHi.AddMinPrice7 ?? 0).ToString(),
Math.Abs(aFI_FDocHi.AddMinPrice8 ?? 0).ToString(),
Math.Abs(aFI_FDocHi.AddMinPrice9 ?? 0).ToString(),
Math.Abs(aFI_FDocHi.AddMinPrice10 ?? 0).ToString());
var result = UnitDatabase.db.Database.SqlQuery <AddMin>(sql).Where(c => c.Name != "").ToList();
foreach (var item in result)
{
if (item.Code == 1)
{
aFI_FDocHi.AddMinPrice1 = Math.Round(item.AddMinPrice ?? 0, aFI_FDocHi.deghat);
}
if (item.Code == 2)
{
aFI_FDocHi.AddMinPrice2 = Math.Round(item.AddMinPrice ?? 0, aFI_FDocHi.deghat);
}
if (item.Code == 3)
{
aFI_FDocHi.AddMinPrice3 = Math.Round(item.AddMinPrice ?? 0, aFI_FDocHi.deghat);
}
if (item.Code == 4)
{
aFI_FDocHi.AddMinPrice4 = Math.Round(item.AddMinPrice ?? 0, aFI_FDocHi.deghat);
}
if (item.Code == 5)
{
aFI_FDocHi.AddMinPrice5 = Math.Round(item.AddMinPrice ?? 0, aFI_FDocHi.deghat);
}
if (item.Code == 6)
{
aFI_FDocHi.AddMinPrice6 = Math.Round(item.AddMinPrice ?? 0, aFI_FDocHi.deghat);
}
if (item.Code == 7)
{
aFI_FDocHi.AddMinPrice7 = Math.Round(item.AddMinPrice ?? 0, aFI_FDocHi.deghat);
}
if (item.Code == 8)
{
aFI_FDocHi.AddMinPrice8 = Math.Round(item.AddMinPrice ?? 0, aFI_FDocHi.deghat);
}
if (item.Code == 9)
{
aFI_FDocHi.AddMinPrice9 = Math.Round(item.AddMinPrice ?? 0, aFI_FDocHi.deghat);
}
if (item.Code == 10)
{
aFI_FDocHi.AddMinPrice10 = Math.Round(item.AddMinPrice ?? 0, aFI_FDocHi.deghat);
}
}
var sql1 = string.Format(@"DECLARE @return_value int
EXEC @return_value = [dbo].[Web_FDocB_CalcAddMin]
@serialNumber = {0},
@deghat = {1},
@forSale = {2},
@MP1 = '{3}',
@MP2 = '{4}',
@MP3 = '{5}',
@MP4 = '{6}',
@MP5 = '{7}',
@MP6 = '{8}',
@MP7 = '{9}',
@MP8 = '{10}',
@MP9 = '{11}',
@MP10 = '{12}'
SELECT 'Return Value' = @return_value" ,
aFI_FDocHi.SerialNumber,
aFI_FDocHi.deghat,
aFI_FDocHi.ModeCode < 54 ? 1 : 0,
aFI_FDocHi.AddMinPrice1,
aFI_FDocHi.AddMinPrice2,
aFI_FDocHi.AddMinPrice3,
aFI_FDocHi.AddMinPrice4,
aFI_FDocHi.AddMinPrice5,
aFI_FDocHi.AddMinPrice6,
aFI_FDocHi.AddMinPrice7,
aFI_FDocHi.AddMinPrice8,
aFI_FDocHi.AddMinPrice9,
aFI_FDocHi.AddMinPrice10);
int test = UnitDatabase.db.Database.SqlQuery <int>(sql1).Single();
string sql2 = string.Format(
@"DECLARE @return_value nvarchar(50),
@DocNo_Out int
EXEC @return_value = [dbo].[Web_SaveFDoc_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}',
@VSTRCODE = {16},
@VSTRPER = {17},
@PAKHSHCODE = '{18}',
@KALAPRICECODE = {19},
@ADDMINSPEC1 = '{20}',
@ADDMINSPEC2 = '{21}',
@ADDMINSPEC3 = '{22}',
@ADDMINSPEC4 = '{23}',
@ADDMINSPEC5 = '{24}',
@ADDMINSPEC6 = '{25}',
@ADDMINSPEC7 = '{26}',
@ADDMINSPEC8 = '{27}',
@ADDMINSPEC9 = '{28}',
@ADDMINSPEC10 = '{29}',
@ADDMINPRICE1 = '{30}',
@ADDMINPRICE2 = '{31}',
@ADDMINPRICE3 = '{32}',
@ADDMINPRICE4 = '{33}',
@ADDMINPRICE5 = '{34}',
@ADDMINPRICE6 = '{35}',
@ADDMINPRICE7 = '{36}',
@ADDMINPRICE8 = '{37}',
@ADDMINPRICE9 = '{38}',
@ADDMINPRICE10 = '{39}',
@InvCode = '{40}',
@Status = '{41}',
@PaymentType = {42},
@Footer = '{43}',
@Taeed={44},
@DOCNO_OUT = @DOCNO_OUT OUTPUT
SELECT 'return_value' = @return_value +'-'+ CONVERT(nvarchar, @DOCNO_OUT)" ,
aFI_FDocHi.DocNoMode,
aFI_FDocHi.InsertMode,
aFI_FDocHi.ModeCode,
aFI_FDocHi.DocNo,
aFI_FDocHi.StartNo,
aFI_FDocHi.EndNo,
aFI_FDocHi.BranchCode,
aFI_FDocHi.UserCode,
aFI_FDocHi.SerialNumber,
aFI_FDocHi.DocDate ?? string.Format("{ 0:yyyy/MM/dd}", DateTime.Now.AddDays(-1)),
aFI_FDocHi.DocTime,
aFI_FDocHi.Spec,
aFI_FDocHi.mDocDate, // DateTime.Now.Date.ToString("yyyy-MM-dd HH:mm:ss"), //2018-04-03 00:00:00.000
aFI_FDocHi.Tanzim,
aFI_FDocHi.TahieShode,
aFI_FDocHi.CustCode ?? "null",
aFI_FDocHi.VstrCode,
aFI_FDocHi.VstrPer,
aFI_FDocHi.PakhshCode,
aFI_FDocHi.KalaPriceCode ?? 0,
aFI_FDocHi.AddMinSpec1,
aFI_FDocHi.AddMinSpec2,
aFI_FDocHi.AddMinSpec3,
aFI_FDocHi.AddMinSpec4,
aFI_FDocHi.AddMinSpec5,
aFI_FDocHi.AddMinSpec6,
aFI_FDocHi.AddMinSpec7,
aFI_FDocHi.AddMinSpec8,
aFI_FDocHi.AddMinSpec9,
aFI_FDocHi.AddMinSpec10,
Math.Abs((decimal)aFI_FDocHi.AddMinPrice1),
Math.Abs((decimal)aFI_FDocHi.AddMinPrice2),
Math.Abs((decimal)aFI_FDocHi.AddMinPrice3),
Math.Abs((decimal)aFI_FDocHi.AddMinPrice4),
Math.Abs((decimal)aFI_FDocHi.AddMinPrice5),
Math.Abs((decimal)aFI_FDocHi.AddMinPrice6),
Math.Abs((decimal)aFI_FDocHi.AddMinPrice7),
Math.Abs((decimal)aFI_FDocHi.AddMinPrice8),
Math.Abs((decimal)aFI_FDocHi.AddMinPrice9),
Math.Abs((decimal)aFI_FDocHi.AddMinPrice10),
aFI_FDocHi.InvCode,
aFI_FDocHi.Status,
aFI_FDocHi.PaymentType,
UnitPublic.ConvertTextWebToWin(aFI_FDocHi.Footer),
aFI_FDocHi.Taeed
);
value = UnitDatabase.db.Database.SqlQuery <string>(sql2).Single();
await UnitDatabase.db.SaveChangesAsync();
}
catch (Exception e)
{
throw;
}
}
return(Ok(value));
}
public async Task <IHttpActionResult> PostAllWeb_IDocHMin(string ace, string sal, string group, IDocHMinObject IDocHMinObject)
{
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 = "declare @enddate nvarchar(20) ";
sql += "select ";
if (IDocHMinObject.select == 0)
{
sql += " top(100) ";
}
sql += string.Format(@"SerialNumber,
InOut,
DocNo,
SortDocNo,
DocDate,
ThvlCode,
ThvlName,
Spec,
KalaPriceCode,
InvCode,
ModeCode,
Status,
PaymentType,
Footer,
Tanzim,
Taeed,
Tasvib,
FinalPrice,
Eghdam,
ModeName,
InvName,
MkzCode,
MkzName,
OprCode,
OprName,
UpdateDate,
F01,
F02,
F03,
F04,
F05,
F06,
F07,
F08,
F09,
F10,
F11,
F12,
F13,
F14,
F15,
F16,
F17,
F18,
F19,
F20
from Web_IDocH_F(3,'{0}') where 1 = 1 ", IDocHMinObject.user);
//if (ModeCode == "in")
// sql += " (101,102,103,106,108,110) ";
//else if (ModeCode == "out")
// sql += " (104,105,107,109,111)";
if (IDocHMinObject.invSelect != "")
{
sql += UnitPublic.SpiltCodeAnd("InvCode", IDocHMinObject.invSelect);
//sql += " and InvCode = '" + IDocHMinObject.invSelect + "' ";
}
if (IDocHMinObject.select == 1)
{
sql += " and DocDate = @enddate ";
}
else if (IDocHMinObject.select == 2)
{
sql += " and DocDate like @enddate + '%' ";
}
if (IDocHMinObject.accessSanad == false)
{
sql += " and Eghdam = '" + IDocHMinObject.user + "' ";
}
if (IDocHMinObject.updatedate != null)
{
sql += " and updatedate >= CAST('" + IDocHMinObject.updatedate + "' AS DATETIME2)";
}
if (IDocHMinObject.ModeCode != null)
{
sql += UnitPublic.SpiltCodeAnd("ModeCode", IDocHMinObject.ModeCode);
}
else
{
if (IDocHMinObject.InOut > 0)
{
sql += " and InOut = " + IDocHMinObject.InOut;
}
}
sql += " order by docdate desc, SortDocNo desc";
var listIDocH = UnitDatabase.db.Database.SqlQuery <Web_IDocHMini>(sql);
return(Ok(listIDocH));
}
return(Ok(con));
}
