public IEnumerable <Detail> Ch_Pro(Detail data)
{
List <Detail> results = new List <Detail>();
try
{
Detail getvalue = new Detail();
using (HR_SALEDataContext db = new HR_SALEDataContext())
{
var sql = (from xx in db.MAS_USER_SYSTEMs
where xx.STCODE == data.STCODE
select xx).FirstOrDefault();
sql.ENDDATE = data.dateofbirth.AddYears(543);
db.SubmitChanges();
}
results.Add(getvalue);
}
catch (Exception ex)
{
Detail res = new Detail();
res.status = "F";
res.message = ex.Message;
results.Add(res);
}
return(results.ToArray());
}
public IEnumerable <Management_All> Setting_ALL()
{
List <Management_All> results = new List <Management_All>();
try
{
Management_All getvalue = new Management_All();
using (HR_SALEDataContext db = new HR_SALEDataContext())
{
var sql = db.HR_SALE_GetALLManagement();
foreach (var ux in sql)
{
Management_All.GetManagementAll mp = new Management_All.GetManagementAll();
mp.MPCODE = ux.MPCODE;
mp.MPNAME = ux.ABBNAME;
mp.QTY = ux.SUM.ToString();
getvalue.AnsManagementAll.Add(mp);
//lstMP.Add(mp);
}
}
results.Add(getvalue);
}
catch (Exception ex)
{
//Detail res = new Detail();
//res.status = "F";
//res.message = ex.Message;
//results.Add(res);
}
return(results.ToArray());
}
public IEnumerable <Detail> Ch_LVL_NOW(lvl data)
{
List <Detail> results = new List <Detail>();
try
{
Detail getvalue = new Detail();
using (HR_SALEDataContext db = new HR_SALEDataContext())
{
var sql = (from xx in db.HR_LVLs
where xx.LVL == data.CH_LVLNAME &&
xx.SECTION == data.CH_SECTION
select xx).FirstOrDefault();
int Set_Net = Convert.ToInt32(Convert.ToDouble(data.NEW_NET));
int Set_Net_CB = Convert.ToInt32(Convert.ToDouble(data.NEW_NET_CB));
sql.BAL = Set_Net;
sql.CBAL = Set_Net_CB;
db.SubmitChanges();
}
results.Add(getvalue);
}
catch (Exception ex)
{
Detail res = new Detail();
res.status = "F";
res.message = ex.Message;
results.Add(res);
}
return(results.ToArray());
}
public IEnumerable <Detail> Deteil(Management data)
{
List <Detail> results = new List <Detail>();
try
{
Detail getvalue = new Detail();
using (HR_SALEDataContext db = new HR_SALEDataContext())
{
var a = data.ShowManagement.FirstOrDefault();
var sql = (from xx in db.HR_SALE_PTs
where xx.STCODE == data.User &&
xx.ABBNO == data.ABB
select xx).FirstOrDefault();
sql.DETEIL = data.Detail;
db.SubmitChanges();
}
results.Add(getvalue);
}
catch (Exception ex)
{
Detail res = new Detail();
res.status = "F";
res.message = ex.Message;
results.Add(res);
}
return(results.ToArray());
}
public IEnumerable <Detail> IndexHrSale(user data)
{
List <Detail> results = new List <Detail>();
try
{
Detail value = new Detail();
using (HR_SALEDataContext db = new HR_SALEDataContext())
{
var q = (from xx in db.MAS_USER_SYSTEMs
where xx.STCODE == data.User &&
xx.PASS == data.Password &&
xx.FLAG != 99
select xx).FirstOrDefault();
if (q == null)
{
value.Error = "null";
//return RedirectToAction("Index", "Home");
}
else
{
value.User = data.User;
value.FULLNAME = q.FULLNAME + ':' + ' ' + q.STCODE;
if (q.POSITION == "")
{
value.Error = "POSITION";
value.STCODE = q.STCODE;
//return RedirectToAction("Index", "Home");
}
else
{
var check = (from xx in db.HR_SALE_USERs
where xx.STCODE == data.User
select xx).FirstOrDefault();
if (check == null)
{
db.HR_SALE_ADDUSER(data.User);
}
//return RedirectToAction("Main", "Employee");
}
}
}
results.Add(value);
}
catch (Exception ex)
{
Detail res = new Detail();
res.status = "F";
res.message = ex.Message;
results.Add(res);
}
return(results.ToArray());
}
public IEnumerable <Detail> SetPass(user data)
{
List <Detail> results = new List <Detail>();
try
{
Detail getvalue = new Detail();
using (HR_SALEDataContext db = new HR_SALEDataContext())
{
if (data.New_Password != null && data.Confirm_Password != null && data.Old_Password != null)
{
var pass = (from xx in db.MAS_USER_SYSTEMs
where xx.STCODE == data.USERONLINE
select xx).FirstOrDefault();
if (pass.PASS != data.Old_Password)
{
getvalue.Error = "Oldpass";
//TempData["Oldpass"] = "******";
//return RedirectToAction("ChPass", "Employee");
}
else
{
if (data.New_Password != data.Confirm_Password)
{
getvalue.Error = "pass";
//TempData["pass"] = "******";
//return RedirectToAction("ChPass", "Employee");
}
else
{
var sql = (from xx in db.MAS_USER_SYSTEMs
where xx.STCODE == data.USERONLINE
select xx).FirstOrDefault();
sql.PASS = data.New_Password;
db.SubmitChanges();
getvalue.Error = "chpass";
//Logout();
}
}
}
}
results.Add(getvalue);
}
catch (Exception ex)
{
Detail res = new Detail();
res.status = "F";
res.message = ex.Message;
results.Add(res);
}
return(results.ToArray());
}
public IEnumerable <SetPro> SetEndDate(Detail data)
{
List <SetPro> results = new List <SetPro>();
try
{
SetPro getvalue = new SetPro();
IQueryable <VW_USER_PRO> View_User;
using (HR_SALEDataContext db = new HR_SALEDataContext())
{
if (data.STCODE != null)
{
var sql = (from xx in db.VW_USER_PROs
where xx.STCODE == data.STCODE
select xx).FirstOrDefault();
getvalue.STCODE = sql.STCODE;
getvalue.FULLNAME = sql.FULLNAME;
getvalue.ENDDATE = sql.ENDDATE;
getvalue.ERROR = "ChPro";
}
View_User = db.VW_USER_PROs
.Where(tik => tik.STCODE.Contains(data.seach) || tik.DPCODE.Contains(data.seach) || tik.FULLNAME.Contains(data.seach) || tik.NICKNAME.Contains(data.seach));
foreach (var item in View_User)
{
SetPro.GetUser mp = new SetPro.GetUser();
mp.STCODE = item.STCODE;
mp.DEGREE = item.DEGREE;
mp.DPCODE = item.DPCODE;
mp.DPNAME = item.DPNAME;
mp.FULLNAME = item.FULLNAME;
mp.NICKNAME = item.NICKNAME;
mp.ENDDATE = item.ENDDATE;
getvalue.ShowUser.Add(mp);
}
}
results.Add(getvalue);
}
catch (Exception ex)
{
//Detail res = new Detail();
//res.status = "F";
//res.message = ex.Message;
//results.Add(res);
}
return(results.ToArray());
}
public IEnumerable <ShowProduct> Main(HR_DATA data)
{
List <ShowProduct> results = new List <ShowProduct>();
try
{
ShowProduct getvalue = new ShowProduct();
using (HR_SALEDataContext db = new HR_SALEDataContext())
{
var sql = db.VW_SHOW_PRODUCTs.Where(F => F.STCODE == data.USERONLINE).OrderBy(F => F.PTDATE);
var q = db.HR_SALE_GETUSER(data.USERONLINE).FirstOrDefault();
getvalue.Bal = q.CBal;
getvalue.Total = q.CTotal;
getvalue.NET = q.ABal;
foreach (var ux in sql)
{
ShowProduct.SProduct mp = new ShowProduct.SProduct();
mp.S_MPCODE = ux.MPCODE;
mp.S_ABBNO = ux.ABBNO;
mp.S_MPNAME = ux.MPNAME;
mp.S_PRICE = ux.CPRICE;
mp.PRICE = ux.SPRICE;
mp.S_DATE = ux.CDATE;
mp.QTY = ux.QTY.ToString();
getvalue.Ans_SProduct.Add(mp);
//lstMP.Add(mp);
}
}
results.Add(getvalue);
}
catch (Exception ex)
{
//Detail res = new Detail();
//res.status = "F";
//res.message = ex.Message;
//results.Add(res);
}
return(results.ToArray());
}
public IEnumerable <lvl> LVL(Inputlvl data)
{
List <lvl> results = new List <lvl>();
try
{
lvl getvalue = new lvl();
getvalue.CH_LVLNAME = data.LVLNAME;
getvalue.CH_SECTION = data.SECTION;
getvalue.C_NET = data.NET;
getvalue.NEW_NET = data.NET;
getvalue.NEW_NET_CB = data.CNET;
using (HR_SALEDataContext db = new HR_SALEDataContext())
{
var sql = (from xx in db.HR_LVLs
select xx);
foreach (var item in sql)
{
lvl.Getlvl mp = new lvl.Getlvl();
mp.LVLNAME = item.LVL;
mp.SECTION = item.SECTION;
mp.CNET = item.CBAL.ToString();
mp.NET = item.BAL.ToString();
getvalue.Showlvl.Add(mp);
}
}
results.Add(getvalue);
}
catch (Exception ex)
{
//Detail res = new Detail();
//res.status = "F";
//res.message = ex.Message;
//results.Add(res);
}
return(results.ToArray());
}
public IEnumerable <Detail> AddPosition(Detail data)
{
List <Detail> results = new List <Detail>();
try
{
//Detail valus = new Detail();
using (HR_SALEDataContext db = new HR_SALEDataContext())
{
var str = (from xx in db.MAS_USER_SYSTEMs
where xx.STCODE == data.STCODE
select xx).FirstOrDefault();
str.POSITION = data.DROPDOWN;
db.SubmitChanges();
var check = (from xx in db.HR_SALE_USERs
where xx.STCODE == data.STCODE
select xx).FirstOrDefault();
if (check == null)
{
db.HR_SALE_ADDUSER(data.STCODE);
}
}
//results.Add(value);
}
catch (Exception ex)
{
Detail res = new Detail();
res.status = "F";
res.message = ex.Message;
results.Add(res);
}
return(results.ToArray());
}
public IEnumerable <Detail> SetProduct(Product data)
{
List <Detail> results = new List <Detail>();
try
{
Detail value = new Detail();
if (data.QTY <= 0)
{
value.Error = "QTY";
//return RedirectToAction("BuyProduct", "Employee");
}
else
{
using (HR_SALEDataContext db = new HR_SALEDataContext())
{
var q = (from xx in db.HR_SALE_PIs
where xx.STCODE == data.Get_USER
select xx).OrderByDescending(xx => xx.ABBNO).FirstOrDefault();
value.q = q;
if (q == null)
{
int Set_QTY = data.QTY;
var Set_USER = data.Get_USER;
int Set_PRICE = Convert.ToInt32(Convert.ToDouble(data.Get_PRICE));
var Set_MPCODE = data.Get_MPCODE;
var ABB = "00001";
int NET = Set_QTY * Set_PRICE;
DateTime Get_date = DateTime.Now;
DateTime Get_today = DateTime.Today;
using (HR_SALEDataContext db2 = new HR_SALEDataContext())
{
//var ss = db2.HR_GetBal(Set_USER).FirstOrDefault();
var ss = (from sale in db2.HR_SALE_USERs
where sale.STCODE == data.Get_USER
select sale).FirstOrDefault();
if (NET > ss.TOTAL)
{
value.Error = "limit";
//return RedirectToAction("Main", "Employee");
}
else
{
//---------------------- HR_GetProduct ---------------//
var ux = new HR_SALE_PI();
ux.STCODE = Set_USER;
ux.ABBNO = ABB;
ux.MPCODE = Set_MPCODE;
ux.QTY = Set_QTY;
ux.PRICE = Set_PRICE;
ux.NET = NET;
ux.PTDATE = Get_date;
ux.WORKDATE = Get_today;
ux.FLAG = 0;
db2.HR_SALE_PIs.InsertOnSubmit(ux);
//----------------------------------------------------
//---------------------- HR_ChBal ---------------//
var USER = (from xx in db2.HR_SALE_USERs
where xx.STCODE == Set_USER
select xx).FirstOrDefault();
USER.BAL = ss.TOTAL - NET;
db2.SubmitChanges();
//----------------------------------------------------
}
}
}
else
{
var c = (from xx in db.HR_SALE_PIs
where xx.STCODE == data.Get_USER &&
xx.MPCODE == data.Get_MPCODE &&
xx.FLAG == 0
select xx);
if (c.Count() > 0)
{
value.Error = "check";
//return RedirectToAction("Main", "Employee");
}
else
{
value.q_FLAG = q.FLAG;
if (q.FLAG == 0)
{
int Set_QTY = data.QTY;
var Set_USER = data.Get_USER;
int Set_PRICE = Convert.ToInt32(Convert.ToDouble(data.Get_PRICE));
var Set_MPCODE = data.Get_MPCODE;
var ABB = q.ABBNO;
int NET = Set_QTY * Set_PRICE;
DateTime Get_date = DateTime.Now;
DateTime Get_today = DateTime.Today;
using (HR_SALEDataContext db2 = new HR_SALEDataContext())
{
var ss = db2.HR_SALE_GetBal(Set_USER).FirstOrDefault();
if (ss.NET + NET > ss.Total)
{
value.Error = "limit";
//return RedirectToAction("Main", "Employee");
}
else
{
//---------------------- HR_GetProduct ---------------//
var ux = new HR_SALE_PI();
ux.STCODE = Set_USER;
ux.ABBNO = ABB;
ux.MPCODE = Set_MPCODE;
ux.QTY = Set_QTY;
ux.PRICE = Set_PRICE;
ux.NET = NET;
ux.PTDATE = Get_date;
ux.WORKDATE = Get_today;
ux.FLAG = 0;
db2.HR_SALE_PIs.InsertOnSubmit(ux);
db2.SubmitChanges();
//----------------------------------------------------
var ss2 = db2.HR_SALE_GetBal(Set_USER).FirstOrDefault();
//---------------------- HR_ChBal ---------------//
var USER = (from xx in db2.HR_SALE_USERs
where xx.STCODE == Set_USER
select xx).FirstOrDefault();
USER.BAL = ss.Total - ss2.NET;
db2.SubmitChanges();
//----------------------------------------------------
}
}
}
else if (q.FLAG == 1 || q.FLAG == 2)
{
//var a = "00001";
//var b = intval();
int intTostr = Convert.ToInt32(Convert.ToDouble(q.ABBNO));
int Plus = intTostr + 1;
var New_ABBNO = Plus.ToString();
for (int i = New_ABBNO.Length; i < 5; i++)
{
New_ABBNO = "0" + New_ABBNO;
}
int Set_QTY = data.QTY;
var Set_USER = data.Get_USER;
int Set_PRICE = Convert.ToInt32(Convert.ToDouble(data.Get_PRICE));
var Set_MPCODE = data.Get_MPCODE;
var ABB = New_ABBNO;
int NET = Set_QTY * Set_PRICE;
DateTime Get_date = DateTime.Now;
DateTime Get_today = DateTime.Today;
using (HR_SALEDataContext db2 = new HR_SALEDataContext())
{
var ss2 = (from sale in db.HR_SALE_USERs
where sale.STCODE == Set_USER
select sale).FirstOrDefault();
//---------------------- HR_GetProduct ---------------//
var ux = new HR_SALE_PI();
ux.STCODE = Set_USER;
ux.ABBNO = ABB;
ux.MPCODE = Set_MPCODE;
ux.QTY = Set_QTY;
ux.PRICE = Set_PRICE;
ux.NET = NET;
ux.PTDATE = Get_date;
ux.WORKDATE = Get_today;
ux.FLAG = 0;
db2.HR_SALE_PIs.InsertOnSubmit(ux);
//----------------------------------------------------
//---------------------- HR_ChBal ---------------//
var USER = (from xx in db2.HR_SALE_USERs
where xx.STCODE == Set_USER
select xx).FirstOrDefault();
USER.BAL = ss2.TOTAL - NET;
db2.SubmitChanges();
//----------------------------------------------------
}
}
}
}
}
results.Add(value);
}
}
catch (Exception ex)
{
//Detail res = new Detail();
//res.status = "F";
//res.message = ex.Message;
//results.Add(res);
}
return(results.ToArray());
}
public IEnumerable <Management> ShowHistory(Input_Management data)
{
List <Management> results = new List <Management>();
try
{
Management getvalue = new Management();
getvalue.U_User = data.User;
getvalue.U_ABBNO = data.ABBNO;
using (HR_SALEDataContext db = new HR_SALEDataContext())
{
var sql = db.HR_SALE_ShowHistory(data.USERONLINE);
foreach (var ux in sql)
{
Management.GetManagement mp = new Management.GetManagement();
//mp.FULLNAME = ux.FULLNAME;
mp.ID_ST = ux.STCODE;
mp.ABBNO = ux.ABBNO;
mp.QTY = ux.QTY.ToString();
mp.NET = ux.NET;
mp.PTDATE = ux.WORKDATE.ToString();
mp.FLAG = ux.FLAG.ToString();
mp.Deteil = ux.DETEIL;
getvalue.AnsManagement.Add(mp);
//lstMP.Add(mp);
}
var sql2 = db.HR_SALE_ShowPI(data.USERONLINE, data.ABBNO);
foreach (var ux in sql2)
{
Management.GetPro sp = new Management.GetPro();
sp.MPCODE = ux.MPCODE;
sp.MPNAME = ux.FULLNAME;
sp.QTY = ux.QTY.ToString();
sp.DETAIL = ux.DETEIL;
sp.row = Int32.Parse(ux.Row_.ToString());
getvalue.ShowManagement.Add(sp);
//lstMP.Add(mp);
}
}
results.Add(getvalue);
}
catch (Exception ex)
{
//Detail res = new Detail();
//res.status = "F";
//res.message = ex.Message;
//results.Add(res);
}
return(results.ToArray());
}
public IEnumerable <Management> Setting(Input_Management data)
{
List <Management> results = new List <Management>();
try
{
Management getvalue = new Management();
using (HR_SALEDataContext db = new HR_SALEDataContext())
{
if (data.Check == "1")
{
getvalue.S_User = data.User;
getvalue.S_PTDATE = data.PTDATE;
getvalue.S_ABBNO = data.ABBNO;
getvalue.S_FULLNAME = data.FULLNAME;
getvalue.S_QTY = data.QTY;
getvalue.S_NET = data.NET;
var sql_PT = (from xx in db.HR_SALE_PTs
where xx.STCODE == data.User &&
xx.ABBNO == data.ABBNO
select xx).FirstOrDefault();
getvalue.Detail = sql_PT.DETEIL;
}
else if (data.Check == "2")
{
getvalue.C_ABBNO = data.ABBNO;
getvalue.C_User = data.User;
}
var sql = db.HR_SALE_GetManagement();
foreach (var ux in sql)
{
Management.GetManagement mp = new Management.GetManagement();
mp.FULLNAME = ux.FULLNAME;
mp.ID_ST = ux.STCODE;
mp.ABBNO = ux.ABBNO;
mp.QTY = ux.QTY.ToString();
mp.NET = ux.NET;
mp.PTDATE = ux.PTDATE.ToString();
mp.FLAG = ux.FLAG.ToString();
mp.Dpcode = ux.DPCODE;
getvalue.AnsManagement.Add(mp);
//lstMP.Add(mp);
}
var sql2 = db.HR_SALE_ShowPI(data.User, data.ABBNO);
foreach (var ux in sql2)
{
Management.GetPro sp = new Management.GetPro();
sp.MPCODE = ux.MPCODE;
sp.MPNAME = ux.FULLNAME;
sp.QTY = ux.QTY.ToString();
//sp.DETAIL = ux.DETEIL;
//sp.row = Int32.Parse(ux.Row_.ToString());
getvalue.ShowManagement.Add(sp);
//lstMP.Add(mp);
}
//}
results.Add(getvalue);
}
}
catch (Exception ex)
{
//Detail res = new Detail();
//res.status = "F";
//res.message = ex.Message;
//results.Add(res);
}
return(results.ToArray());
}
public IEnumerable <Detail> Del_now(ShowProduct data)
{
List <Detail> results = new List <Detail>();
try
{
Detail value = new Detail();
using (HR_SALEDataContext db = new HR_SALEDataContext())
{
//---------------------- HR_DelProduct ---------------//
var Del = (from xx in db.HR_SALE_PIs
where xx.STCODE == data.de_USER &&
xx.ABBNO == data.de_ABBNO &&
xx.MPCODE == data.de_MPCODE
select xx).FirstOrDefault();
db.HR_SALE_PIs.DeleteOnSubmit(Del);
db.SubmitChanges();
//----------------------------------------------------
var ss = db.HR_SALE_GetBal(data.de_USER).FirstOrDefault();
if (ss == null)
{
var ss2 = (from sale in db.HR_SALE_USERs
where sale.STCODE == data.de_USER
select sale).FirstOrDefault();
//---------------------- HR_ChBal ---------------//
var USER = (from xx in db.HR_SALE_USERs
where xx.STCODE == data.de_USER
select xx).FirstOrDefault();
USER.BAL = ss.Total - 0;
db.SubmitChanges();
//----------------------------------------------------
}
else
{
//---------------------- HR_ChBal ---------------//
var USER = (from xx in db.HR_SALE_USERs
where xx.STCODE == data.de_USER
select xx).FirstOrDefault();
USER.BAL = ss.Total - ss.NET;
db.SubmitChanges();
//----------------------------------------------------
}
}
results.Add(value);
}
catch (Exception ex)
{
Detail res = new Detail();
res.status = "F";
res.message = ex.Message;
results.Add(res);
}
return(results.ToArray());
}
public IEnumerable <Detail> Change_now(ShowProduct data)
{
List <Detail> results = new List <Detail>();
try
{
Detail value = new Detail();
if (data.ch_QTY <= 0)
{
value.Error = "QTY";
//TempData["QTY"] = "false";
//return RedirectToAction("Main", "Employee");
}
else
{
int price = Convert.ToInt32(Convert.ToDouble(data.ch_PRICE));
int ch_price = data.ch_QTY * price;
using (HR_SALEDataContext db = new HR_SALEDataContext())
{
var ss = db.HR_SALE_GetBal(data.ch_USER).FirstOrDefault();
try
{
if (ss.NET + ch_price > ss.Total)
{
value.Error = "limit";
//TempData["limit"] = "false";
//return RedirectToAction("Main", "Employee");
}
else
{
//---------------------- HR_ChProduct ---------------//
var ch = (from xx in db.HR_SALE_PIs
where xx.STCODE == data.ch_USER &&
xx.MPCODE == data.ch_MPCODE &&
xx.ABBNO == data.ch_ABBNO
select xx).FirstOrDefault();
ch.QTY = data.ch_QTY;
ch.NET = ch_price;
db.SubmitChanges();
//----------------------------------------------------
var ss2 = db.HR_SALE_GetBal(data.ch_USER).FirstOrDefault();
//---------------------- HR_ChBal ---------------//
var USER = (from xx in db.HR_SALE_USERs
where xx.STCODE == data.ch_USER
select xx).FirstOrDefault();
USER.BAL = ss2.Total - ss2.NET;
db.SubmitChanges();
//----------------------------------------------------
}
}
catch
{
}
}
}
results.Add(value);
}
catch (Exception ex)
{
Detail res = new Detail();
res.status = "F";
res.message = ex.Message;
results.Add(res);
}
return(results.ToArray());
}
