public void RevenuesExpenses_Delete(string vr_VoucherNumber, HttpContext vr_Context)
{
Db_Connection.Open();
Db_Query.Connection = Db_Connection;
Db_Query.CommandText = "Exec RevenuesExpensesDel @Voucher_Number='" + vr_VoucherNumber + "'";
Db_Query.ExecuteNonQuery();
vr_Context.Response.Write("<script lang='JavaScript'> alert ('Fiş Silindi.');</script>");
Db_Connection.Close();
}
public void RevenuesExpenses_Update(string vr_VoucherNumber, string vr_VoucherDate, string vr_VoucherExplanation, int vr_VoucherAmount, string vr_VoucherCurrency, string vr_VoucherCreditDebt, int vr_VoucherPositionCode, HttpContext vr_Context)
{
Db_Connection.Open();
Db_Query.Connection = Db_Connection;
Db_Query.CommandText = "Exec RevenuesExpensesUpdate @Voucher_Number='" + vr_VoucherNumber + "',@Voucher_Date='" + vr_VoucherDate + "',@Voucher_Explanation='" + vr_VoucherExplanation + "',@Voucher_Amount='" + vr_VoucherAmount + "',@Voucher_Currency='" + vr_VoucherCurrency + "',@Voucher_CreditDebt='" + vr_VoucherCreditDebt + "',@Voucher_PositionCode='" + vr_VoucherPositionCode + "'";
Db_Query.ExecuteNonQuery();
vr_Context.Response.Write("<script lang='JavaScript'> alert ('Fiş Güncellendi.');</script>");
Db_Connection.Close();
}
public string isDelete(string id)
{
Db_Connection dbconn = new Db_Connection();
try
{
dbconn.openConnection();
string strSQL = "";
string strResult = "";
//strSQL = @"SELECT ID FROM ASSETS WHERE SUPPLIER=@SUPPLIER";
//SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn);
//cmd.Parameters.Add("SUPPLIER", SqlDbType.VarChar).Value = id;
//SqlDataReader dr = cmd.ExecuteReader();
//if (dr.HasRows)
//{
// strResult = "Found";
//}
//dr.Dispose();
//cmd.Dispose();
//if (strResult == "")
//{
// strSQL = @"SELECT ID FROM LINENS WHERE SUPPLIER=@SUPPLIER";
// cmd = new SqlCommand(strSQL, dbconn.DbConn);
// cmd.Parameters.Add("SUPPLIER", SqlDbType.VarChar).Value = id;
// dr = cmd.ExecuteReader();
// if (dr.HasRows)
// {
// strResult = "Found";
// }
// dr.Dispose();
// cmd.Dispose();
//}
if (strResult == "")
{
strSQL = @"DELETE FROM SUPPLIER WHERE ID=@ID";
SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn);
cmd.Parameters.Add("ID", SqlDbType.VarChar).Value = id;
cmd.ExecuteNonQuery();
}
dbconn.closeConnection();
return(strResult);
}
finally
{
dbconn.closeConnection();
}
}
public ActionResult weaponCount(string date)
{
Db_Connection dbconn = new Db_Connection();
Utility util = new Utility();
try
{
string checkoutToday = "0", checkinToday = "0", actualCheckout = "0";
dbconn.openConnection();
string strSQL = "";
strSQL = @"SELECT COUNT(ID) FROM FIREARMS_INOUT WHERE CONVERT(VARCHAR(10),[DATE],110)=@DATE AND UPPER(STATUS)='CHECKOUT'";
SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn);
cmd.Parameters.Add("DATE", SqlDbType.VarChar).Value = Convert.ToDateTime(date).ToString("MM-dd-yyyy");
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
checkoutToday = dr[0].ToString();
dr.Dispose();
cmd.Dispose();
strSQL = @"SELECT COUNT(ID) FROM FIREARMS_INOUT WHERE CONVERT(VARCHAR(10),[DATE],110)=@DATE AND UPPER(STATUS)='CHECKIN'";
cmd = new SqlCommand(strSQL, dbconn.DbConn);
cmd.Parameters.Add("DATE", SqlDbType.VarChar).Value = Convert.ToDateTime(date).ToString("MM-dd-yyyy");
dr = cmd.ExecuteReader();
dr.Read();
checkinToday = dr[0].ToString();
dr.Dispose();
cmd.Dispose();
strSQL = @"SELECT COUNT(ID) FROM ASSIGN_FIREARMS WHERE UPPER(STATUS)='CHECKOUT'";
cmd = new SqlCommand(strSQL, dbconn.DbConn);
dr = cmd.ExecuteReader();
dr.Read();
actualCheckout = dr[0].ToString();
dr.Dispose();
cmd.Dispose();
dbconn.closeConnection();
ViewData["checkoutToday"] = checkoutToday;
ViewData["checkinToday"] = checkinToday;
ViewData["actualCheckout"] = actualCheckout;
return(PartialView());
}
finally
{
dbconn.closeConnection();
}
}
public string saveArea(mdlArea areainfo)
{
string result = "";
Db_Connection dbconn = new Db_Connection();
try
{
dbconn.openConnection();
string strSQL = @"SELECT ID FROM AREAS WHERE AREA=@AREA";
SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn);
cmd.Parameters.Add("AREA", SqlDbType.VarChar).Value = areainfo.AREA;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
result = "Area already exist";
}
else
{
dr.Dispose();
cmd.Dispose();
strSQL = @"INSERT INTO AREAS(AREA,ACTIVE,ENCODEDBY,MODIFIEDBY,DATEMODIFIED,DATEENCODED,AREATYPE)
VALUES(@AREA,@ACTIVE,@ENCODEDBY,@MODIFIEDBY,GETDATE(),GETDATE(),@AREATYPE);SELECT SCOPE_IDENTITY()";
cmd = new SqlCommand(strSQL, dbconn.DbConn);
cmd.Parameters.Add("AREA", SqlDbType.VarChar).Value = areainfo.AREA;
cmd.Parameters.Add("ACTIVE", SqlDbType.VarChar).Value = areainfo.ACTIVE;
cmd.Parameters.Add("ENCODEDBY", SqlDbType.VarChar).Value = "currentuser";
cmd.Parameters.Add("MODIFIEDBY", SqlDbType.VarChar).Value = "currentuser";
cmd.Parameters.Add("AREATYPE", SqlDbType.VarChar).Value = areainfo.AREATYPE;
var id = cmd.ExecuteScalar();
result = id.ToString();
}
dr.Dispose();
cmd.Dispose();
dbconn.closeConnection();
return(result);
}
catch (Exception ex)
{
return(ex.ToString());
}
finally
{
dbconn.closeConnection();
}
}
public void Contract_List_VehicleFilter(GridView dt_ContractListGrd, string vr_ContractCode, string vr_ContractNo)
{
Db_Table = new DataTable();
Db_Table.Clear();
Db_Connection.Open();
Db_Adapter = new SqlDataAdapter("Exec ContractFilter @Contract_Code='" + vr_ContractCode + "',@Contract_No='" + vr_ContractNo + "'", Db_Connection);
Db_Adapter.Fill(Db_Table);
dt_ContractListGrd.DataSource = Db_Table;
dt_ContractListGrd.DataBind();
Db_Connection.Close();
}
public void User_List_UserFilter(GridView dt_UsersListGrd, string vr_FQuery)
{
Db_Table = new DataTable();
Db_Table.Clear();
Db_Connection.Open();
Db_Adapter = new SqlDataAdapter(vr_FQuery, Db_Connection);
Db_Adapter.Fill(Db_Table);
dt_UsersListGrd.DataSource = Db_Table;
dt_UsersListGrd.DataBind();
Db_Connection.Close();
}
public void User_List(GridView dt_UsersListGrd)
{
Db_Table = new DataTable();
Db_Table.Clear();
Db_Connection.Open();
Db_Adapter = new SqlDataAdapter("select UserId,UserCode,UserNameSurName,UserDepartment,UserTelephone,UserMail from UsersList", Db_Connection);
Db_Adapter.Fill(Db_Table);
dt_UsersListGrd.DataSource = Db_Table;
dt_UsersListGrd.DataBind();
Db_Connection.Close();
}
public void Vehicle_List(GridView dt_VehiclesListGrd)
{
Db_Table = new DataTable();
Db_Table.Clear();
Db_Connection.Open();
Db_Adapter = new SqlDataAdapter("Select * From VehicleList", Db_Connection);
Db_Adapter.Fill(Db_Table);
dt_VehiclesListGrd.DataSource = Db_Table;
dt_VehiclesListGrd.DataBind();
Db_Connection.Close();
}
public void Customer_List_CustomerFilter(GridView dt_CustomersListGrd, string vr_CustomerID, string vr_CustomerTitle, string vr_CustomerTaxNumber)
{
Db_Table = new DataTable();
Db_Table.Clear();
Db_Connection.Open();
Db_Adapter = new SqlDataAdapter("Exec CustomerFilter @Customer_ID='" + vr_CustomerID + "',@Customer_Title='" + vr_CustomerTitle + "',@Customer_TaxNumber='" + vr_CustomerTaxNumber + "'", Db_Connection);
Db_Adapter.Fill(Db_Table);
dt_CustomersListGrd.DataSource = Db_Table;
dt_CustomersListGrd.DataBind();
Db_Connection.Close();
}
public string savePalletSize(mdlPalletSize sizeinfo)
{
string result = "";
Db_Connection dbconn = new Db_Connection();
try
{
dbconn.openConnection();
string strSQL = @"SELECT ID FROM SIZES WHERE SIZE=@SIZE";
SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn);
cmd.Parameters.Add("SIZE", SqlDbType.VarChar).Value = sizeinfo.SIZE;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
result = "Pallet size already exist";
}
else
{
dr.Dispose();
cmd.Dispose();
strSQL = @"INSERT INTO SIZES(SIZE,ACTIVE,ENCODEDBY,MODIFIEDBY,DATEMODIFIED,DATEENCODED)
VALUES(@SIZE,@ACTIVE,@ENCODEDBY,@MODIFIEDBY,GETDATE(),GETDATE())";
cmd = new SqlCommand(strSQL, dbconn.DbConn);
cmd.Parameters.Add("SIZE", SqlDbType.VarChar).Value = sizeinfo.SIZE;
cmd.Parameters.Add("ACTIVE", SqlDbType.VarChar).Value = sizeinfo.ACTIVE;
cmd.Parameters.Add("ENCODEDBY", SqlDbType.VarChar).Value = "currentuser";
cmd.Parameters.Add("MODIFIEDBY", SqlDbType.VarChar).Value = "currentuser";
cmd.ExecuteNonQuery();
result = "Pallet size successfully saved.";
}
dr.Dispose();
cmd.Dispose();
dbconn.closeConnection();
return(result);
}
catch (Exception ex)
{
return(ex.ToString());
}
finally
{
dbconn.closeConnection();
}
}
public void RevenuesExpenses_Filter(GridView dt_RevenuesExpensesListGrd, string vr_VoucherNumber, string vr_VoucherExplanation)
{
Db_Table = new DataTable();
Db_Table.Clear();
Db_Connection.Open();
Db_Adapter = new SqlDataAdapter("Exec RevenuesExpensesFilter @Voucher_Number='" + vr_VoucherNumber + "',@Voucher_Explanation='" + vr_VoucherExplanation + "'", Db_Connection);
Db_Adapter.Fill(Db_Table);
dt_RevenuesExpensesListGrd.DataSource = Db_Table;
dt_RevenuesExpensesListGrd.DataBind();
Db_Connection.Close();
}
public void Vehicle_List_VehicleFilter(GridView dt_VehiclesListGrd, string vr_VehicleCode, string vr_VehiclePlate)
{
Db_Table = new DataTable();
Db_Table.Clear();
Db_Connection.Open();
Db_Adapter = new SqlDataAdapter("Exec VehicleFilter @Vehicle_Code='" + vr_VehicleCode + "',@Vehicle_Plate='" + vr_VehiclePlate + "'", Db_Connection);
Db_Adapter.Fill(Db_Table);
dt_VehiclesListGrd.DataSource = Db_Table;
dt_VehiclesListGrd.DataBind();
Db_Connection.Close();
}
public ActionResult edit(string id, string gid)
{
Populate DropDown = new Populate();
List <SelectListItem> location_combo = new List <SelectListItem>();
location_combo = DropDown.getLocation();
Db_Connection dbconn = new Db_Connection();
try
{
dbconn.openConnection();
string strSQL = @"SELECT DOOR,LOCATION,DESCRIPTION FROM VDOOR WHERE ID=@ID AND GID=@GID";
SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn);
cmd.Parameters.Add("ID", SqlDbType.VarChar).Value = id;
cmd.Parameters.Add("GID", SqlDbType.VarChar).Value = gid;
SqlDataReader dr = cmd.ExecuteReader();
mdlDoor record = new mdlDoor();
record.ID = id;
record.GID = gid;
if (dr.HasRows)
{
dr.Read();
record.ID = id;
record.GID = gid;
record.DOOR = dr["DOOR"].ToString();
record.LOCATION = dr["LOCATION"].ToString();
record.DESCRIPTION = dr["DESCRIPTION"].ToString();
}
foreach (SelectListItem item in location_combo)
{
if (item.Text.ToUpper() == record.LOCATION.ToUpper())
{
item.Selected = true;
}
}
ViewData["location"] = location_combo;
return(PartialView(record));
}
finally
{
dbconn.closeConnection();
}
}
public static ProductosModel GetProdCategories(string categoria)
{
string Query = "EXECUTE obtener_producto_categoria '" + categoria + "';";
var ResulSet = Db_Connection.ReaderDatabase(Query);
ProductosModel infProCateg = new ProductosModel();
infProCateg.nombre_producto = ResulSet.Rows[0]["nombre_producto"].ToString();
infProCateg.descripcion = ResulSet.Rows[0]["descripcion"].ToString();
infProCateg.precio = float.Parse(ResulSet.Rows[0]["precio"].ToString());
infProCateg.stock = int.Parse(ResulSet.Rows[0]["stock"].ToString());
infProCateg.imagen = ResulSet.Rows[0]["imagen"].ToString();
return(infProCateg);
}
private void Won()
{
// Deafult Image
Load_blank_Image();
// Display Message in Text if guessed correct
Toast.MakeText(this, "You guessed the word correctly", ToastLength.Short).
Show();
var cc = new Db_Connection();
cc.UpdateScore(Id, PlayerName, score);
// New Word
LoadNewRandomWord();
}
public ActionResult getPalletInfo(string id, string gid)
{
mdlPallet model = new mdlPallet();
Db_Connection dbconn = new Db_Connection();
try
{
dbconn.openConnection();
string strSQL = @"SELECT * FROM PALLETS WHERE ID=@ID AND GID=@GID";
SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn);
cmd.Parameters.Add("ID", SqlDbType.VarChar).Value = id;
cmd.Parameters.Add("GID", SqlDbType.VarChar).Value = gid;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
model.ID = dr["ID"].ToString();
model.GID = dr["GID"].ToString();
model.BARCODE = dr["BARCODE"].ToString();
model.RFID = dr["RFID"].ToString();
model.TYPE = dr["TYPE"].ToString();
model.STYLE = dr["STYLE"].ToString();
model.SIZE = dr["SIZE"].ToString();
model.LOCATION = dr["LOCATION"].ToString();
model.SUPPLIER = dr["SUPPLIER"].ToString();
model.NAME = dr["NAME"].ToString();
model.ACTIVE = dr["ACTIVE"].ToString();
model.AREA = dr["AREA"].ToString();
}
dr.Dispose();
cmd.Dispose();
dbconn.closeConnection();
return(Json(model, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(model, JsonRequestBehavior.AllowGet));
}
finally
{
dbconn.closeConnection();
}
}
public ActionResult location_list(string from, string to, string location)
{
Db_Connection dbconn = new Db_Connection();
Utility util = new Utility();
try
{
dbconn.openConnection();
string strSQL = "";
string strWHERE = "";
strSQL = @"SELECT TAGS,READTIME,LOCATION,FIREARMTYPE,DEFPIC FROM VRFID_LOGS
WHERE READTIME>=@FROM AND READTIME<=DATEADD(day, 1,@TO) AND LOCATIONID=@LOCATION";
SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn);
cmd.Parameters.Add("FROM", SqlDbType.VarChar).Value = from;
cmd.Parameters.Add("TO", SqlDbType.VarChar).Value = to;
cmd.Parameters.Add("LOCATION", SqlDbType.VarChar).Value = location;
SqlDataReader dr = cmd.ExecuteReader();
List <mdlTrack> record = new List <mdlTrack>();
if (dr.HasRows)
{
while (dr.Read())
{
mdlTrack list = new mdlTrack();
list.TAGS = dr["TAGS"].ToString();
list.READTIME = util.formatLongDateTime(Convert.ToDateTime(dr["READTIME"].ToString()));
list.LOCATION = dr["LOCATION"].ToString();
list.LOCATIONID = location;
list.FIREARMTYPE = dr["FIREARMTYPE"].ToString();
list.DEFPIC = "/Content/firearms/NoImage.png";
if (!string.IsNullOrEmpty(dr["DEFPIC"].ToString()))
{
list.DEFPIC = "/" + dr["DEFPIC"].ToString();
}
record.Add(list);
}
}
dr.Dispose();
cmd.Dispose();
dbconn.closeConnection();
return(PartialView(record));
}
finally
{
dbconn.closeConnection();
}
}
public ActionResult search_list()
{
Db_Connection dbconn = new Db_Connection();
Utility util = new Utility();
try
{
dbconn.openConnection();
string strSQL = "";
strSQL = @"SELECT ID,GID,RFID,MODEL,FIREARMTYPE,CALIBER,CONDITION,DEFPIC,STATUS FROM VFIREARMS";
SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn);
SqlDataReader dr = cmd.ExecuteReader();
List <mdlFirearm> record = new List <mdlFirearm>();
if (dr.HasRows)
{
while (dr.Read())
{
mdlFirearm list = new mdlFirearm();
list.ID = dr["ID"].ToString();
list.GID = dr["GID"].ToString();
list.RFID = dr["RFID"].ToString();
list.MODEL = dr["MODEL"].ToString();
list.FIREARMTYPE = dr["FIREARMTYPE"].ToString();
list.CALIBER = dr["CALIBER"].ToString();
list.STATUS = dr["STATUS"].ToString();
list.CONDITION = dr["CONDITION"].ToString();
list.DEFPIC = "/Content/firearms/NoImage.png";
if (!string.IsNullOrEmpty(dr["DEFPIC"].ToString()))
{
list.DEFPIC = "/" + dr["DEFPIC"].ToString();
}
record.Add(list);
}
}
dr.Dispose();
cmd.Dispose();
dbconn.closeConnection();
return(PartialView(record));
}
finally
{
dbconn.closeConnection();
}
}
//LEER GIMNASIO SELECCIONADO
public static Tuple <List <GymModel>, List <CoachModel>, List <ClassModel> > ReadOneGyms(int IdGym)
{
var Connect = Db_Connection.ConexionSQL();
//ABRIMOS LA CONEXION
Connect.Open();
//QUERY QUE SE EJECUTARA EN LA BASE DE DATOS
var QueryC = new SqlCommand("EXECUTE ReadOneGym '" + IdGym + "';", Connect);
//CREAMOS UN ADAPTADOR PARA LA CONSULTA
SqlDataReader ResultSet = QueryC.ExecuteReader();;
//INICIAMOS EL MODELO
List <GymModel> resultGym = new List <GymModel>();
List <CoachModel> resultCoach = new List <CoachModel>();
List <ClassModel> resultClass = new List <ClassModel>();
while (ResultSet.Read())
{
GymModel InfoGym = new GymModel();
CoachModel InfoCoach = new CoachModel();
ClassModel InfoClass = new ClassModel();
//LLENAMOS EL MODELO CON LOS DATOS EXTRAIDOS
InfoGym.Id_Gym = int.Parse(ResultSet["Id_Gym"].ToString());
InfoGym.Gym_Campus = ResultSet["Gym_Campus"].ToString();
InfoGym.Gym_Address = ResultSet["Gym_Address"].ToString();
InfoGym.Gym_Phone = ResultSet["Gym_Phone"].ToString();
InfoGym.Gym_Income = int.Parse(ResultSet["Gym_Income"].ToString());
InfoGym.Gym_Email = ResultSet["Gym_Email"].ToString();
InfoClass.Id_Class = int.Parse(ResultSet["Id_Class"].ToString());
InfoClass.Id_Coach_Class = int.Parse(ResultSet["Id_Coach_Class"].ToString());
InfoClass.Class_Name = ResultSet["Class_Name"].ToString();
InfoClass.Class_Limit = int.Parse(ResultSet["Class_Limit"].ToString());
InfoClass.Class_Inscribed = int.Parse(ResultSet["Class_Inscribed"].ToString());
InfoClass.Class_Hour = ResultSet["Class_Hour"].ToString();
InfoClass.Class_Duration = int.Parse(ResultSet["Class_Duration"].ToString());
InfoCoach.Id_Coach = int.Parse(ResultSet["Id_Coach"].ToString());
InfoCoach.Coach_Name = ResultSet["Coach_Name"].ToString();
resultGym.Add(InfoGym);
resultClass.Add(InfoClass);
resultCoach.Add(InfoCoach);
}
Connect.Close();
return(Tuple.Create(resultGym, resultCoach, resultClass));
}
//metodo para los registros de usuarios logueados
public static ClientesModel LoginClientes(string email, string pass)
{
string Query = "EXECUTE login_clientes '" + email + "','" + pass + "';";
var ResultSet = Db_Connection.ReaderDatabase(Query);
ClientesModel InfClientesLgn = new ClientesModel();
InfClientesLgn.nombre = ResultSet.Rows[0]["nombre"].ToString();
InfClientesLgn.email = ResultSet.Rows[0]["email"].ToString();
InfClientesLgn.pass = ResultSet.Rows[0]["pass"].ToString();
return(InfClientesLgn);
}
//le mandamos un objeto de tipo clientesmodel como parametro
public static bool Registrar(ClientesModel c)
{
try
{
//ejecutamos el storeprocedure y le concatenamos los atributos del objeto clientes model
string Query = "EXECUTE registro_clientes '" + c.nombre + "','" + c.apellidos + "','" + c.email + "','" + c.pass + "';";
var ResultSet = Db_Connection.ReaderDatabase(Query);
}
catch (Exception e)
{
e.Message.ToString();
}
return(true);
}
public ActionResult accessdoor_list(string door)
{
Db_Connection dbconn = new Db_Connection();
Utility util = new Utility();
try
{
dbconn.openConnection();
string strSQL = "";
strSQL = @"SELECT ID,F_ID,FIREARMTYPE,ACCESS,LOCATION,DOOR,DEFPIC FROM VWEAPON_DOOR_ACCESS WHERE DOORID=@DOOR";
SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn);
cmd.Parameters.Add("DOOR", SqlDbType.VarChar).Value = door;
SqlDataReader dr = cmd.ExecuteReader();
List <mdlTrack> record = new List <mdlTrack>();
if (dr.HasRows)
{
while (dr.Read())
{
mdlTrack list = new mdlTrack();
list.FIREARMTYPE = dr["FIREARMTYPE"].ToString();
list.F_ID = dr["F_ID"].ToString();
list.ACCESS = dr["ACCESS"].ToString();
list.ID = dr["ID"].ToString();
list.LOCATION = dr["LOCATION"].ToString();
list.DOOR = dr["DOOR"].ToString();
list.DEFPIC = dr["DEFPIC"].ToString();
list.DEFPIC = "/Content/firearms/NoImage.png";
if (!string.IsNullOrEmpty(dr["DEFPIC"].ToString()))
{
list.DEFPIC = "/" + dr["DEFPIC"].ToString();
}
record.Add(list);
}
}
dr.Dispose();
cmd.Dispose();
dbconn.closeConnection();
return(PartialView(record));
}
finally
{
dbconn.closeConnection();
}
}
public ActionResult searchPalletLocation(string id)
{
List <mdlPallet> model = new List <mdlPallet>();
Db_Connection dbconn = new Db_Connection();
try
{
dbconn.openConnection();
string strSQL = @"SELECT ID,RFID,READTIME,LOCATION,READERNAME,TYPE,STYLE FROM VRFID_LOGS WHERE LOCATIONID=@LOCATIONID ";
SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn);
cmd.Parameters.Add("LOCATIONID", SqlDbType.VarChar).Value = id;
SqlDataReader dr = cmd.ExecuteReader();
mdlPallet list = new mdlPallet();
while (dr.Read())
{
list = new mdlPallet();
list.ID = dr["ID"].ToString();
list.RFID = dr["RFID"].ToString();
list.READTIME = Convert.ToDateTime(dr["READTIME"].ToString()).ToString("dd-MMM-yyyy H:mm:ss tt");
list.LOCATION = dr["LOCATION"].ToString();
list.READERNAME = dr["READERNAME"].ToString();
list.TYPE = dr["TYPE"].ToString();
list.STYLE = dr["STYLE"].ToString();
model.Add(list);
}
dr.Dispose();
cmd.Dispose();
dbconn.closeConnection();
return(Json(model, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(model, JsonRequestBehavior.AllowGet));
}
finally
{
dbconn.closeConnection();
}
}
public ActionResult getPallets()
{
List <mdlPallet> model = new List <mdlPallet>();
Db_Connection dbconn = new Db_Connection();
try
{
dbconn.openConnection();
string strSQL = @"SELECT ID,GID,BARCODE,RFID,TYPE,LOCATION,NAME,EMPLOYEE,ACTIVE,AREA FROM VPALLETS ";
SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn);
SqlDataReader dr = cmd.ExecuteReader();
mdlPallet list = new mdlPallet();
while (dr.Read())
{
list = new mdlPallet();
list.ID = dr["ID"].ToString();
list.GID = dr["GID"].ToString();
list.BARCODE = dr["BARCODE"].ToString();
list.RFID = dr["RFID"].ToString();
list.TYPE = dr["TYPE"].ToString();
list.EMPLOYEE = dr["EMPLOYEE"].ToString();
list.LOCATION = dr["LOCATION"].ToString();
list.NAME = dr["NAME"].ToString();
list.ACTIVE = dr["ACTIVE"].ToString();
list.AREA = dr["AREA"].ToString();
model.Add(list);
}
dr.Dispose();
cmd.Dispose();
dbconn.closeConnection();
return(Json(model, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(model, JsonRequestBehavior.AllowGet));
}
finally
{
dbconn.closeConnection();
}
}
public ActionResult getReaders()
{
List <mdlReader> model = new List <mdlReader>();
Db_Connection dbconn = new Db_Connection();
try
{
dbconn.openConnection();
string strSQL = @"SELECT ID,GID,READERMODEL,READERNAME,PORT,IP,TIME,GATE,ACTIVE FROM VREADERS ";
SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn);
SqlDataReader dr = cmd.ExecuteReader();
mdlReader list = new mdlReader();
while (dr.Read())
{
list = new mdlReader();
list.ID = dr["ID"].ToString();
list.GID = dr["GID"].ToString();
list.MODEL = dr["READERMODEL"].ToString();
list.READERNAME = dr["READERNAME"].ToString();
list.PORT = dr["PORT"].ToString();
list.IPADDRESS = dr["IP"].ToString();
list.TIME = dr["TIME"].ToString();
list.GATE = dr["GATE"].ToString();
list.ACTIVE = dr["ACTIVE"].ToString();
model.Add(list);
}
dr.Dispose();
cmd.Dispose();
dbconn.closeConnection();
return(Json(model, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(model, JsonRequestBehavior.AllowGet));
}
finally
{
dbconn.closeConnection();
}
}
public ActionResult getReaderInfo(string id)
{
mdlReader model = new mdlReader();
Db_Connection dbconn = new Db_Connection();
try
{
dbconn.openConnection();
string strSQL = @"SELECT * FROM READERS WHERE ID=@ID";
SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn);
cmd.Parameters.Add("ID", SqlDbType.VarChar).Value = id;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
model.ID = dr["ID"].ToString();
model.GID = dr["GID"].ToString();
model.MODEL = dr["READERMODEL"].ToString();
model.READERNAME = dr["READERNAME"].ToString();
model.PORT = dr["PORT"].ToString();
model.IPADDRESS = dr["IP"].ToString();
model.TIME = dr["TIME"].ToString();
model.GATE = dr["GATE"].ToString();
model.ACTIVE = dr["ACTIVE"].ToString();
}
dr.Dispose();
cmd.Dispose();
dbconn.closeConnection();
return(Json(model, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(model, JsonRequestBehavior.AllowGet));
}
finally
{
dbconn.closeConnection();
}
}
public ActionResult getAreaTypeInventory()
{
List <mdlPallet> model = new List <mdlPallet>();
Db_Connection dbconn = new Db_Connection();
try
{
dbconn.openConnection();
string strSQL = @"SELECT COUNT(dbo.vpallets.TYPE) AS CNT, dbo.vrfid_logs_max.AREA, dbo.vpallets.TYPE
FROM dbo.vpallets INNER JOIN
dbo.vrfid_logs_max ON dbo.vpallets.RFID = dbo.vrfid_logs_max.RFID
WHERE (dbo.vrfid_logs_max.READTIME IS NOT NULL) AND (dbo.vpallets.ACTIVE = 'Active')
GROUP BY dbo.vrfid_logs_max.AREA, dbo.vpallets.TYPE
ORDER BY dbo.vrfid_logs_max.AREA";
SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn);
SqlDataReader dr = cmd.ExecuteReader();
mdlPallet list = new mdlPallet();
while (dr.Read())
{
list = new mdlPallet();
list.AREA = dr["AREA"].ToString();
list.TYPE = dr["TYPE"].ToString();
list.CNT = dr["CNT"].ToString();
model.Add(list);
}
dr.Dispose();
cmd.Dispose();
dbconn.closeConnection();
return(Json(model, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(model, JsonRequestBehavior.AllowGet));
}
finally
{
dbconn.closeConnection();
}
}
public ActionResult AccessDoorEdit(string id)
{
Populate DropDown = new Populate();
Db_Connection dbconn = new Db_Connection();
List <SelectListItem> allowdeny_combo = new List <SelectListItem>();
allowdeny_combo = DropDown.getAllowDeny();
try
{
dbconn.openConnection();
string strSQL = @"SELECT LOCATION,DOOR,ACCESS FROM VWEAPON_DOOR_ACCESS WHERE ID=@ID";
SqlCommand cmd = new SqlCommand(strSQL, dbconn.DbConn);
cmd.Parameters.Add("ID", SqlDbType.VarChar).Value = id;
SqlDataReader dr = cmd.ExecuteReader();
mdlTrack record = new mdlTrack();
record.ID = id;
if (dr.HasRows)
{
dr.Read();
record.ID = id;
record.LOCATION = dr["LOCATION"].ToString();
record.DOOR = dr["DOOR"].ToString();
record.ACCESS = dr["ACCESS"].ToString();
}
foreach (SelectListItem item in allowdeny_combo)
{
if (item.Text.ToUpper() == record.ACCESS.ToUpper())
{
item.Selected = true;
}
}
ViewData["access"] = allowdeny_combo;
return(PartialView(record));
}
finally
{
dbconn.closeConnection();
}
}
public static ClassModel ReadClassGym(int idClas, int idUser, int idGym)
{
string Query = "EXECUTE ReadClassUser '" + idUser + "','" + idClas + "','" + idGym + "';";
//CREAMOS UN ADAPTADOR PARA LA CONSULTA
var ResultSet = Db_Connection.ReaderDatabase(Query);;
//INICIAMOS EL MODELO
ClassModel Clase = new ClassModel();
//LLENAMOS EL MODELO CON LOS DATOS EXTRAIDOS
Clase.Id_Class = int.Parse(ResultSet.Rows[0]["Id_UserClass"].ToString());
return(Clase);
}
