public IEnumerable <PM_INPUTORDER> GetAllPM_INPUTORDER()
{
List <PM_INPUTORDER> stoList = new List <PM_INPUTORDER>();
using (OracleConnection con = new OracleConnection(_connectString))
{
string queryString = "Select * from PM_INPUTORDER";
OracleCommand command = new OracleCommand(queryString, con);
con.Open();
OracleDataReader reader = command.ExecuteReader();
try
{
while (reader.Read())
{
PM_INPUTORDER store = new PM_INPUTORDER();
stoList.Add(store);
}
}
finally
{
reader.Close();
}
}
return(stoList);
}
public IActionResult ThemSanPham(PM_INPUTORDER pi, SP_TaoPhieuNhap spt)
{
Debug.WriteLine("Log" + list.Count);
TaoPhieuNhap mymodel = new TaoPhieuNhap();
mymodel.pS = service.GetAllStore();
mymodel.ispt = service.GetAllThemSanPham(list, spt);
mymodel.tpnt = new TaoPhieuNhap_Temp();
mymodel.pi = pi;
service.TaoPhieuNhap_Temp(mymodel.tpnt, mymodel);
return(View("TaoPhieuNhap", mymodel));
}
public void TaoPhieuNhap_NoSubmit(PM_INPUTORDER pi)
{
System.Diagnostics.Debug.WriteLine("Log" + pi.AUTOSTORECHANGETOSTOREID);
try
{
using (OracleConnection con = new OracleConnection(_connectString))
{
string queryString = "Insert into PM_INPUTORDER(INPUTVOUCHERID,AUTOSTORECHANGETOSTOREID,CUSTOMERNAME,CUSTOMERADDRESS,CUSTOMERPHONE,TAXID,CHECKREALINPUTNOTE) values" +
"('" + pi.INPUTVOUCHERID + "','" + pi.AUTOSTORECHANGETOSTOREID + "','" + pi.CUSTOMERNAME + "','" +
pi.CUSTOMERADDRESS + "','" + pi.CUSTOMERPHONE + "','" + pi.TAXID + "','" + pi.CHECKREALINPUTNOTE + "') ";
//string queryString = "Insert into PM_INPUTORDER(INPUTVOUCHERID) VALUES ('+"+pi.INPUTVOUCHERID.ToString()+"+')";
OracleCommand command = new OracleCommand(queryString, con);
con.Open();
}
}
catch (Exception)
{
throw;
}
}
public IEnumerable <PM_INPUTORDER> TraCuuPhieuNhap(TraCuuPhieuNhap traCuuPhieuNhap)
{
Debug.WriteLine("Log" + traCuuPhieuNhap.TuKhoa);
List <PM_INPUTORDER> stoList = new List <PM_INPUTORDER>();
using (OracleConnection con = new OracleConnection(_connectString))
{
string queryString = "Select * from PM_INPUTORDER where INPUTVOUCHERID like '%" + traCuuPhieuNhap.TuKhoa +
"%' and AUTOSTORECHANGETOSTOREID like '%" + traCuuPhieuNhap.Kho + "%'" +
" and INPUTDATE BETWEEN TO_DATE ('" + traCuuPhieuNhap.TuNgay.ToString("dd/MM/yyyy") + "', 'DD/MM/YYYY')" +
"AND TO_DATE('" + traCuuPhieuNhap.DenNgay.ToString("dd/MM/yyyy") + "', 'DD/MM/YYYY')" +
"and PAYABLETYPE like '%" + traCuuPhieuNhap.HinhThucNhap + "%' and PROCESSSTATUS like '%" + traCuuPhieuNhap.TrangThaiNhap + "%'";
Debug.WriteLine("Log" + queryString);
OracleCommand command = new OracleCommand(queryString, con);
con.Open();
OracleDataReader reader = command.ExecuteReader();
try
{
while (reader.Read())
{
PM_INPUTORDER store = new PM_INPUTORDER()
{
INPUTVOUCHERID = reader["INPUTVOUCHERID"].ToString(),
AUTOSTORECHANGETOSTOREID = Convert.ToInt32(reader["AUTOSTORECHANGETOSTOREID"]),
INPUTDATE = reader["INPUTDATE"].ToString(),
CUSTOMERNAME = reader["CUSTOMERNAME"].ToString(),
TOTALAMOUNTBF = Convert.ToInt32(reader["TOTALAMOUNTBF"]),
PROCESSSTATUS = Convert.ToInt32(reader["PROCESSSTATUS"])
};
Debug.WriteLine("Log" + stoList.Count());
stoList.Add(store);
}
}
finally
{
reader.Close();
}
}
return(stoList);
}
public IActionResult TaoPhieuNhap(PM_INPUTORDER pi)
{
service.TaoPhieuNhap(pi);
return(RedirectToAction(nameof(Index)));
}
