public ChangeStampModel CheangeStamp(string ternCode, string ternSubCode, string inoutTrainStamp, string visitor_id, int?adminLevel)
{
ChangeStampModel model = new ChangeStampModel();
DataTable data_card_type = new DataTable();
List <stampCodeList> stampcodelist = new List <stampCodeList>();
string CardType = "";
SqlParameterCollection parameter1 = new SqlCommand().Parameters;
parameter1.Add("@inoutTranstamp", SqlDbType.NVarChar).Value = inoutTrainStamp;
var data_ChangeStamp = this.db.StoreQuery("Change_Stamp_Detail", parameter1);
string sql_cardType = "select Cartype from PkCard where CscMain_ID = '" + visitor_id + "' ";
data_card_type = db.QueryDataTable(sql_cardType);
CardType = data_card_type.Rows[0]["Cartype"].ToString();
string sql_StampCodeList = "SELECT StampCode, StampCode+' '+ZDesc as StampDese FROM [dbo].[PkStamp] where Cartype = '" + CardType + "' and TernCode = '" + ternCode + "' and TernSubCode = '" + ternSubCode + "' and admin_level_id >= " + adminLevel + " ";
var data_StampCodeList = db.QueryDataTable(sql_StampCodeList);
stampcodelist = (from c in data_StampCodeList.AsEnumerable() select new stampCodeList {
stampcode = c["StampCode"].ToString(),
stampCodeName = c["StampDese"].ToString()
}).ToList();
model.stampCodeList = stampcodelist;
model.inoutTranID = data_ChangeStamp.Rows[0]["InOutTran_ID"].ToString();
model.inoutTrainStampID = data_ChangeStamp.Rows[0]["InOutTranstamp_ID"].ToString();
model.DateTimeStamp = Convert.ToDateTime(data_ChangeStamp.Rows[0]["datetimestamp"]);
model.stampCode = data_ChangeStamp.Rows[0]["StampCode"].ToString();
model.stampCodeOld = data_ChangeStamp.Rows[0]["StampCode"].ToString();
model.VisitorId = visitor_id;
model.licensePlate = data_ChangeStamp.Rows[0]["CarID"].ToString();
return(model);
}
public ChangeStampModel ChangeStamp(string inoutTrainStamp, string visitor_id)
{
HttpContext context = HttpContext.Current;
var Userdata = (UserLoginModel)context.Items["user_data"];
ChangeStampModel model = new ChangeStampModel();
model = this.stampservice.CheangeStamp(Userdata.CompanyID, Userdata.DeptID, inoutTrainStamp, visitor_id, Userdata.AdminLevel);
return(model);
}
public IHttpActionResult ChangeStamp(ChangeStampModel model)
{
HttpContext context = HttpContext.Current;
var Userdata = (UserLoginModel)context.Items["user_data"];
string ip = HttpContext.Current.Request.UserHostAddress;
string result = this.stampservice.UpdateStamp(model.stampCode, model.inoutTranID, model.inoutTrainStampID);
this._log.insert_log(
Userdata.Aminname, Userdata.name, "WEB", "ChangeStamp", "Change " + model.stampCode, "5", model.stampCodeOld, "", "", ip, Userdata.AdminLevel.ToString(), DateTime.Now.ToString(), "", "");
//List<ActiveStampModel> list = new List<ActiveStampModel>();
//list = this.stampservice.ActiveStampList(Userdata.CompanyID, Userdata.DeptID, Userdata.AdminLevel.ToString());
//data_active_stamp = list
return(Ok(new { mes = result }));
}
