/// <summary>
/// Check user login in-case auto and direct login mode.
/// </summary>
/// <param name="model">The user login information.</param>
/// <returns>The login status.</returns>
public DCW001Login DCW001CheckLoginByMultiStatus(DCW001Login model)
{
DCW001Login results;
// Create new DBManager object for check user login into system.
using (DBManager manager = new DBManager("stp_DCW001UserLogin"))
{
// Declare parameter input for stp_DCW001UserLogin.
manager.Add("@userName", model.TANTOSHA_NAME);
manager.Add("@password", model.PASSWORD);
// Get the user login information from database.
DataTable dataTable = manager.GetDataTable();
// Check data login from database.
if (dataTable.Rows.Count == 0)
{
results = null;
}
else
{
results = EntityHelper <DCW001Login> .GetListObject(dataTable)[0];
}
}
// Return status login to service.
return(results);
}
/// <summary>
/// Insert uketori detail
/// </summary>
/// <param name="lstFuzokuhin"></param>
/// <param name="errMsg"></param>
public void DCW003InsertDocUketoriDetail(List <DCW003UketoriUpdate> lstUpdate, List <DCW003UketoriDetail> lstDetail, out string errMsg)
{
DataTable tblDetail = new DataTable();
tblDetail = EntityHelper <DCW003UketoriDetail> .ConvertToDataTable(lstDetail);
if (tblDetail == null)
{
tblDetail = new DataTable();
tblDetail.Columns.Add("DocControlNo", typeof(string));
tblDetail.Columns.Add("DocFuzokuhinCd", typeof(string));
tblDetail.Columns.Add("DocCount", typeof(int));
tblDetail.Columns.Add("Note", typeof(string));
tblDetail.Columns.Add("IsChecked", typeof(int));
}
using (DBManager DbManager = new DBManager(DWC003StoreName.STP_DCW003_INSERT_DOC_UKETORI_DETAIL))
{
DbManager.Add(DWC003StoreName.PARAM_LIST_UKETORI_UPDATE, SqlDbType.Structured, EntityHelper <DCW003UketoriUpdate> .ConvertToDataTable(lstUpdate));
DbManager.Add(DWC003StoreName.PARAM_LIST_UKETORI_DETAIL, SqlDbType.Structured, tblDetail);
DbManager.Add(DWC003StoreName.PARAM_USER, CmnEntityModel.UserName);
DbManager.Add(DWC003StoreName.PARAM_ERROR_MSG, SqlDbType.VarChar, 500, ParameterDirection.Output);
DbManager.ExecuteNonQuery();
// Output error message
errMsg = DbManager.GetValueInString(DWC003StoreName.PARAM_ERROR_MSG);
}
}
/// <summary>
/// Get data to report
/// </summary>
/// <param name="param"></param>
/// <param name="nameStoreProcedure"></param>
/// <param name="messErr"></param>
/// <returns>DataSet</returns>
private DataSet GetDataReports(string[,] param, string nameStoreProcedure, ref string messErr)
{
DataSet dataSetResult = new DataSet();
try
{
using (DBManager dbManager = new DBManager(nameStoreProcedure))
{
for (int i = param.GetLowerBound(0); i <= param.GetUpperBound(0); i++)
{
if (param[i, 0] != "")
{
if (!string.IsNullOrEmpty(param[i, 1]))
{
dbManager.Add(param[i, 0].ToString(), param[i, 1].ToString());
}
else
{
dbManager.Add(param[i, 0].ToString(), DBNull.Value);
}
}
}
dataSetResult = dbManager.GetDataSet();
}
}
catch (Exception)
{
messErr = "E0003";//err.Message;
}
return(dataSetResult);
}
/// <summary>
/// Update all
/// </summary>
/// <param name="lstUpdate"></param>
public void DCW003UpdateAll(List <DCW003Update> lstUpdate)
{
using (DBManager DbManager = new DBManager(DWC003StoreName.STP_DCW003_UPDATE_ALL_DOC_CONTROL))
{
DbManager.Add(DWC003StoreName.PARAM_LIST_UPDATE, SqlDbType.Structured, EntityHelper <DCW003Update> .ConvertToDataTable(lstUpdate));
DbManager.Add(DWC003StoreName.PARAM_USER, CmnEntityModel.UserName);
DbManager.ExecuteNonQuery();
}
}
//TRAMD ADD PHASE 2 IMPORT 5
public void DCW003InsertHensoIf(List <DCW003CsvModel> lstCsvTempHenso)
{
using (DBManager DbManager = new DBManager(DWC003StoreName.STP_DCW003_INSERT_HENSO_IF))
{
DbManager.Add(DWC003StoreName.PARAM_LIST_CSV, SqlDbType.Structured, EntityHelper <DCW003CsvModel> .ConvertToDataTable(lstCsvTempHenso));
DbManager.Add(DWC003StoreName.PARAM_USER, CmnEntityModel.UserName);
DbManager.ExecuteNonQuery();
}
}
/// <summary>
/// Insert Jishamei Massho
/// </summary>
/// <param name="lstCsv"></param>
public void DCW003InsertJishameiMassho(List <DCW003CsvModel> lstCsv)
{
using (DBManager DbManager = new DBManager(DWC003StoreName.STP_DCW003_INSERT_JISHAMEI_MASSHO))
{
DbManager.Add(DWC003StoreName.PARAM_LIST_CSV, SqlDbType.Structured, EntityHelper <DCW003CsvModel> .ConvertToDataTable(lstCsv));
DbManager.Add(DWC003StoreName.PARAM_USER, CmnEntityModel.UserName);
DbManager.ExecuteNonQuery();
}
}
public void GetSuggestion <T>(string textPattern, int maxResult, out List <T> listSuggest, string storeName) where T : new()
{
using (var dbManager = new DBManager(storeName))
{
dbManager.Add(SysStoreName.para_MaxResult, maxResult);
dbManager.Add(SysStoreName.para_TextPattern, textPattern);
DataTable dt = dbManager.GetDataTable();
listSuggest = EntityHelper <T> .GetListObject(dt);
}
}
public void DCW003ExportCSVLinkGHQ(List <DCW003UketoriExportCSVLinkGHQ> lstExportCSVLinkGHQ, out string errMsg)
{
using (DBManager DbManager = new DBManager(DWC003StoreName.STP_DCW003_EXPORT_CSV_LINK_GHQ))
{
DbManager.Add(DWC003StoreName.PARAM_EXPORT_CSV_LINK_GHQ, SqlDbType.Structured, EntityHelper <DCW003UketoriExportCSVLinkGHQ> .ConvertToDataTable(lstExportCSVLinkGHQ));
DbManager.Add(DWC003StoreName.PARAM_USER, CmnEntityModel.UserName);
DbManager.Add(DWC003StoreName.PARAM_ERROR_MSG, SqlDbType.VarChar, 5, ParameterDirection.Output);
DbManager.ExecuteNonQuery();
// Output error message
errMsg = DbManager.GetValueInString(DWC003StoreName.PARAM_ERROR_MSG);
}
}
// TODO
/// <summary>
/// The sequence get value.
/// </summary>
/// <param name="seqKey">
/// The seq key.
/// </param>
/// <param name="seqValue">
/// The seq value.
/// </param>
/// <returns>
/// The <see cref="ReturnCode"/>.
/// </returns>
public static ReturnCode SequenceGetValue(string seqKey, out string seqValue)
{
seqValue = String.Empty;
using (var dbManager = new DBManager("stp_Sequence_GetValue"))
{
dbManager.Add("@SeqKey", seqKey);
dbManager.Add("@SeqValue", seqValue, ParameterDirection.Output);
dbManager.ExecuteNonQuery();
return((ReturnCode)dbManager.ReturnValue);
}
}
/// <summary>
/// Get doc control from master
/// </summary>
/// <param name="lstRfid"></param>
/// <returns></returns>
public List <DCW003Result> DCW003GetDocControlMaster(List <DCW003RFID> lstRfid, int pageIndex, int pageSize, out int rowCount)
{
using (DBManager DbManager = new DBManager(DWC003StoreName.STP_DCW003_GET_DOC_CONTROL_MASTER))
{
DbManager.Add(DWC003StoreName.PARAM_LIST_RFID, SqlDbType.Structured, EntityHelper <DCW003RFID> .ConvertToDataTable(lstRfid));
DbManager.Add(DWC003StoreName.PARAM_PAGE_INDEX, pageIndex);
DbManager.Add(DWC003StoreName.PARAM_PAGE_SIZE, pageSize);
DataTable tableResult = DbManager.GetDataTable();
rowCount = tableResult.Rows.Count;
return(Entities.EntityHelper <DCW003Result> .GetListObject(tableResult));
}
}
public List <DCW003Result> DCW003GetHenSoIf(List <DCW003CsvModel> lstCsv, int pageIndex, int pageSize, int modeSearch, out int rowCount)
{
using (DBManager DbManager = new DBManager(DWC003StoreName.STP_DCW003_GET_HENSO_IF))
{
DbManager.Add(DWC003StoreName.PARAM_LIST_CSV, SqlDbType.Structured, EntityHelper <DCW003CsvModel> .ConvertToDataTable(lstCsv));
DbManager.Add(DWC003StoreName.PARAM_MODE_SEARCH, modeSearch);
DbManager.Add(DWC003StoreName.PARAM_PAGE_INDEX, pageIndex);
DbManager.Add(DWC003StoreName.PARAM_PAGE_SIZE, pageSize);
DataTable tableResult = DbManager.GetDataTable();
rowCount = tableResult.Rows.Count;
return(Entities.EntityHelper <DCW003Result> .GetListObject(tableResult));
}
}
/// <summary>
/// Insert Doc Uketori Detail IF
/// </summary>
/// <param name="lstCsv"></param>
/// <param name="errMsg"></param>
public void DCW003InsertDocUketoriIf(List <DCW003CsvModel> lstCsv, out string errMsg)
{
using (DBManager DbManager = new DBManager(DWC003StoreName.STP_DCW003_INSERT_DOC_UKETORI_IF))
{
DbManager.Add(DWC003StoreName.PARAM_LIST_CSV, SqlDbType.Structured, EntityHelper <DCW003CsvModel> .ConvertToDataTable(lstCsv));
DbManager.Add(DWC003StoreName.PARAM_USER, CmnEntityModel.UserName);
DbManager.Add(DWC003StoreName.PARAM_ERROR_MSG, SqlDbType.VarChar, 500, ParameterDirection.Output);
DbManager.ExecuteNonQuery();
// Output error message
errMsg = DbManager.GetValueInString(DWC003StoreName.PARAM_ERROR_MSG);
}
}
/// <summary>
/// Insert auto search
/// </summary>
/// <param name="lstUpdate"></param>
public void DCW003InsertAutoSearch(List <DCW003Update> lstUpdate, out string lstSuccess, out string lstError)
{
using (DBManager DbManager = new DBManager(DWC003StoreName.STP_DCW003_INSERT_AUTO_SEARCH))
{
DbManager.Add(DWC003StoreName.PARAM_LIST_UPDATE, SqlDbType.Structured, EntityHelper <DCW003Update> .ConvertToDataTable(lstUpdate));
DbManager.Add(DWC003StoreName.PARAM_USER, CmnEntityModel.UserName);
DbManager.Add(DWC003StoreName.PARAM_LIST_SUCCESS, SqlDbType.VarChar, 500, ParameterDirection.Output);
DbManager.Add(DWC003StoreName.PARAM_LIST_ERROR, SqlDbType.VarChar, 500, ParameterDirection.Output);
DbManager.ExecuteNonQuery();
lstSuccess = DbManager.GetValueInString(DWC003StoreName.PARAM_LIST_SUCCESS);
lstError = DbManager.GetValueInString(DWC003StoreName.PARAM_LIST_ERROR);
}
}
//Add fix bug 66 HoaVV end
// <summary>
/// Check InputTorokuno
/// </summary>
/// <param name="lstFuzokuhin"></param>
/// <param name="errMsg"></param>
public void DCW003CheckInputTorokuno(string UriageShuppinnTorokuNo, string DocControlNo, out string errorMsg)
{
using (DBManager DbManager = new DBManager(DWC003StoreName.STP_DCW003_CHECK_INPUT_TOROKUNO))
{
DbManager.Add(DWC003StoreName.PARAM_DOC_CONTROL_NO, DocControlNo);
DbManager.Add(DWC003StoreName.PARAM_URIAGE_SHUPPINN_TOROKUNO, UriageShuppinnTorokuNo);
DbManager.Add(DWC003StoreName.PARAM_USER, CmnEntityModel.UserName);
DbManager.Add(DWC003StoreName.PARAM_ERROR_MSG, SqlDbType.VarChar, 5, ParameterDirection.Output);
DbManager.ExecuteNonQuery();
// Output error message
errorMsg = DbManager.GetValueInString(DWC003StoreName.PARAM_ERROR_MSG);
}
}
public ActionResult Create(Contact p)
{
DBManager db = new DBManager();
db.Add(p);
return(RedirectToAction("index"));
}
public ActionResult Create(PassWord p)
{
DBManager db = new DBManager();
db.Add(p);
return(RedirectToAction("Index"));
}
public static void LogSave(string logDiv,
string method,
string loginUser,
string loginStore,
string ipAddress,
string logMessage,
string detail)
{
try
{
using (DBManager dbManager = new DBManager("stp_Log_Save"))
{
dbManager.Add("@LogDiv", logDiv);
dbManager.Add("@Method", method);
dbManager.Add("@LoginUser", loginUser);
dbManager.Add("@LoginStore", loginStore);
dbManager.Add("@IPAddress", ipAddress);
dbManager.Add("@LogMessage", logMessage);
dbManager.Add("@Detail", detail);
dbManager.ExecuteNonQuery();
// safe
DBManager.CommitTransaction();
}
}
catch (Exception)
{
}
}
public ActionResult UploadSuccess(UploadedPicture picture, HttpPostedFileBase image)
{
string file = Guid.NewGuid().ToString() + Path.GetExtension(image.FileName);
image.SaveAs(Server.MapPath("/Pictures/") + file);
picture.Image = file;
manager.Add(picture);
return(View(picture));
}
public bool DCW001CheckDomainLogin(string domainLogin)
{
using (DBManager manager = new DBManager("stp_DCW001CheckDomainLogin"))
{
manager.Add("@domain_Login", domainLogin);
DataTable dataTable = manager.GetDataTable();
return(dataTable.Rows.Count == 0);
}
}
public void DCW003InsertHisUketoriDetail(List <string> lst)
{
DataTable tblDocControlNo = new DataTable();
tblDocControlNo.Columns.Add("DocControlNo", typeof(string));
foreach (var item in lst)
{
DataRow row = tblDocControlNo.NewRow();
row["DocControlNo"] = item;
tblDocControlNo.Rows.Add(row);
}
using (DBManager DbManager = new DBManager(DWC003StoreName.STP_DCW003_INSERT_HIS_UKETORI_DETAIL))
{
DbManager.Add(DWC003StoreName.PARAM_LIST_DOC_CONTROL_NO, SqlDbType.Structured, tblDocControlNo);
DbManager.Add(DWC003StoreName.PARAM_USER, CmnEntityModel.UserName);
DbManager.ExecuteNonQuery();
}
}
public int InsertData(string _itemCd, string _itemNm, string _harga, string _uom, string _grpCd, string _custCd, string _typeCd)
{
int result = 0;
string sSql = string.Format("INSERT INTO SPA02MT (ITEM_CD, ITEM_NM, HARGA, USED, UNIT_QTY, GROUP_CD, VISIT_GRP, TYPE_CD) "
+ " VALUES ('{0}', '{1}', {2}, 'Y', '{3}', '{4}', '{5}', '{6}')", new DBHelper().GetAutoNo("spa02mt", "ITEM_CD"), _itemNm, Convert.ToInt32(_harga), "Y", _uom, _grpCd, _custCd, _typeCd);
DBManager db = new DBManager();
result = db.Add(sSql);
return(result);
}
public DataTable ExportPDFRD0020(DataTable table)
{
DataTable dt = new DataTable();
DataTable dataSetResult = new DataTable();
using (DBManager dbManager = new DBManager(ConstantsStpReports.RD0020))
{
dbManager.Add("@list", SqlDbType.Structured, table);
dataSetResult = dbManager.GetDataTable();
}
return(dataSetResult);
}
public void TestAdd()
{
using (var mDBManager = new DBManager())
{
for (var i = 11; i <= 100; i++)
{
var entity = new SYS_DEPT();
entity.SD_ID = Guid.NewGuid();
entity.SD_NAME = "TEST" + i;
entity.SD_ORDER = i;
mDBManager.Add(entity);
}
mCurrentController.ViewBag.Message = mDBManager.Commit() ? "Ok" : mDBManager.ErrorMsg;
}
}
/// <summary>
/// Get list import
/// </summary>
/// <param name="lstDocControlNo"></param>
/// <returns></returns>
public List <DCW003Result> DCW003GetListImport(List <string> lstDocControlNo, int pageIndex, int pageSize, out int rowCount)
{
DataTable tblDocControlNo = new DataTable();
tblDocControlNo.Columns.Add("DocControlNo", typeof(string));
foreach (var item in lstDocControlNo)
{
DataRow row = tblDocControlNo.NewRow();
row["DocControlNo"] = item;
tblDocControlNo.Rows.Add(row);
}
using (DBManager DbManager = new DBManager(DWC003StoreName.STP_DCW003_GET_LIST_IMPORT))
{
DbManager.Add(DWC003StoreName.PARAM_LIST_DOC_CONTROL_NO, SqlDbType.Structured, tblDocControlNo);
DbManager.Add(DWC003StoreName.PARAM_PAGE_INDEX, pageIndex);
DbManager.Add(DWC003StoreName.PARAM_PAGE_SIZE, pageSize);
DataTable tableResult = DbManager.GetDataTable();
rowCount = tableResult.Rows.Count;
return(Entities.EntityHelper <DCW003Result> .GetListObject(tableResult));
}
}
private DataSet GetDataReports(DataTable listData, string nameStoreProcedure, string paramList, ref string messErr)
{
DataSet dataSetResult = new DataSet();
try
{
using (DBManager dbManager = new DBManager(nameStoreProcedure))
{
dbManager.Add(paramList, SqlDbType.Structured, listData);
dataSetResult = dbManager.GetDataSet();
}
}
catch (Exception err)
{
messErr = err.Message;
}
return(dataSetResult);
}
public ActionResult Create(Product product)
{
try
{
if (ModelState.IsValid)
{
if (UploadedImages.Count > 0 || UploadedImages != null)
{
product.Images = UploadedImages;
}
DBManager <Product> .Add(product);
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
/// <summary>
/// Get uketori detail
/// </summary>
/// <param name="lstDocControlNo"></param>
/// <returns></returns>
public List <DCW003UketoriDetail> DCW003GetUketoriDetail(List <string> lstDocControlNo)
{
DataTable tblDocControlNo = new DataTable();
tblDocControlNo.Columns.Add("DocControlNo", typeof(string));
foreach (var item in lstDocControlNo)
{
DataRow row = tblDocControlNo.NewRow();
row["DocControlNo"] = item;
tblDocControlNo.Rows.Add(row);
}
using (DBManager DbManager = new DBManager(DWC003StoreName.STP_DCW003_GET_FUZOKUHIN))
{
DbManager.Add(DWC003StoreName.PARAM_LIST_DOC_CONTROL_NO, SqlDbType.Structured, tblDocControlNo);
DataTable tableResult = DbManager.GetDataTable();
return(Entities.EntityHelper <DCW003UketoriDetail> .GetListObject(tableResult));
}
}
public ActionResult Register(User user)
{
var kul = DBManager <User> .Get(x => x.UserName == user.UserName || x.Email == user.Email);
if (kul != null)
{
ModelState.AddModelError("", "Bu email ya da kullanıcı adı sistemde Kayıtlı");
//ModelState.Clear();
return(View("Login"));
}
else
{
DBManager <User> .Add(user);
FormsAuthentication.SetAuthCookie(user.UserName, false);
return(RedirectToAction("Index", "Home"));
}
}
/// <summary>
/// Insert Doc Control
/// </summary>
/// <param name="lstCsv"></param>
/// <param name="lstError"></param>
/// <param name="lstNoMap"></param>
/// <param name="lstImport"></param>
public void DCW003ImportCsv(List <DCW003CsvModel> lstCsv, out string lstError, out string lstErrorExist, out string lstNoMap, out string lstImport, out string lstDocControlNo)
{
using (DBManager DbManager = new DBManager(DWC003StoreName.STP_DCW003_IMPORT_CSV))
{
DbManager.Add(DWC003StoreName.PARAM_LIST_CSV, SqlDbType.Structured, EntityHelper <DCW003CsvModel> .ConvertToDataTable(lstCsv));
DbManager.Add(DWC003StoreName.PARAM_USER, CmnEntityModel.UserName);
DbManager.Add(DWC003StoreName.PARAM_LIST_ERROR, SqlDbType.VarChar, 8000, ParameterDirection.Output);
DbManager.Add(DWC003StoreName.PARAM_LIST_ERROR_EXIST, SqlDbType.VarChar, 8000, ParameterDirection.Output);
DbManager.Add(DWC003StoreName.PARAM_LIST_NO_MAP, SqlDbType.VarChar, 8000, ParameterDirection.Output);
DbManager.Add(DWC003StoreName.PARAM_LIST_IMPORT, SqlDbType.VarChar, 8000, ParameterDirection.Output);
DbManager.Add(DWC003StoreName.PARAM_LIST_DOC_CONTROL_NO, SqlDbType.VarChar, 8000, ParameterDirection.Output);
DbManager.ExecuteNonQuery();
// Output error message
lstError = DbManager.GetValueInString(DWC003StoreName.PARAM_LIST_ERROR);
lstErrorExist = DbManager.GetValueInString(DWC003StoreName.PARAM_LIST_ERROR_EXIST);
lstNoMap = DbManager.GetValueInString(DWC003StoreName.PARAM_LIST_NO_MAP);
lstImport = DbManager.GetValueInString(DWC003StoreName.PARAM_LIST_IMPORT);
lstDocControlNo = DbManager.GetValueInString(DWC003StoreName.PARAM_LIST_DOC_CONTROL_NO);
}
}
public ActionResult Index(Order newOrder)
{
double[] subPrices = new double[] { 1.5, 2.0, 2.5, 3.0, 3.5 };
String subName = Enum.GetName(typeof(Order.SubType), newOrder.Sub);
var priceOfSub = subPrices[(int)newOrder.Sub];
double[] sizePrices = new double[] { 4.25, 5.0, 5.75 };
String subSize = Enum.GetName(typeof(Order.SizeType), newOrder.Size);
var priceOfSize = sizePrices[(int)newOrder.Size];
double[] mealPrices = new double[] { 0.0, 2.0, 2.25 };
String subMeal = Enum.GetName(typeof(Order.MealType), newOrder.Meal);
var priceOfMeal = mealPrices[(int)newOrder.Meal];
int quantity = newOrder.Quantity;
double subtot = priceOfSub * priceOfSize * quantity;
double subTotal = subtot + (priceOfMeal * quantity);
double tax = subTotal * (TPS + TVQ);
DBM.Add(newOrder);
ViewBag.subName = subName;
ViewBag.subSize = subSize;
ViewBag.subMeal = subMeal;
ViewBag.quantity = quantity;
ViewBag.priceOfSub = priceOfSub;
ViewBag.priceOfSize = priceOfSize;
ViewBag.priceOfMeal = priceOfMeal * quantity;
ViewBag.subtot = subtot;
ViewBag.subTotal = subTotal;
ViewBag.total = subTotal + tax;
ViewBag.tax = tax;
return(View("Receipt"));
}
