public IActionResult Get() { var db = new dal(); var data = db.Clientes.ToList(); return(Ok(data)); }
public ActionResult changepassword([Bind(Include = "ID,firstname,lastname,email,country,password,Roles")] user user, string newpassword, string confirmpassword) { if (ModelState.IsValid) { dal dl = new dal(); if (dl.getuser(user.email, user.password).password == user.password) { if (newpassword != confirmpassword) { ModelState.AddModelError("password not matching", "Confirm Password Field do not match with New Password"); return(View(user)); } user.password = newpassword; db.Entry(user).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Edit", new { id = user.ID })); } else { ModelState.AddModelError("Incorrect Password", "Incorrect Password"); return(View(user)); } } return(View(user)); }
public void getTabsContentDrp(DataTable dt) { db = new dal(); string qry = "SELECT H.IDX, H.DESCRIPTION FROM HIL.HICL_TABS_CONTENT H WHERE H.ISACTIVE = 1 ORDER BY IDX"; db.getData(qry, dt); }
protected void btnAdd_Click(object sender, EventArgs e) { try { db = new dal(); dt = new DataTable(); cc = new ClientClass(); cc.Screen = txtScreen.Text; cc.ProjectIdx = ddlProject.SelectedValue; if (chkActive.Checked == true) { cc.Active = "1"; } else { cc.Active = "0"; } cc.insertScreen(dt, Convert.ToInt32(cc.Active), Convert.ToInt32(cc.ProjectIdx), cc.Screen, txtUrl.Text, ddlParent.SelectedValue == "-1" ? 0 : Convert.ToInt32(ddlParent.SelectedValue), Convert.ToInt32(ddlIsParent.SelectedValue), txtIcon.Text, Convert.ToDecimal(txtSorting.Text)); string message = " Add Successfully."; string script = "window.onload = function(){ alert('"; script += message; script += "')};"; ClientScript.RegisterStartupScript(this.GetType(), "SuccessMessage", script, true); refreshText(); fillgrid(); } catch (Exception ex) { lblMsg.Text = ex.Message.ToString(); } }
public ActionResult Submit() { User objUser = new User(); objUser.UserName = Request.Form["UserName"].ToString(); objUser.Password = Request.Form["Password"].ToString(); dal dal = new dal(); Encryption enc = new Encryption(); if (ModelState.IsValid) { string hashedPassword = enc.CreateHash(objUser.Password); objUser.Password = hashedPassword; try { dal.Users.Add(objUser); dal.SaveChanges(); ViewBag.message = "User was added Successfuly!"; } catch (Exception) { TempData["error"] = "There was a problem in registration, possible reason: user already exist.\n"; // print error message return(View("AddUser")); } } else { ViewBag.message = "Error in registration!"; } return(View("Success")); }
public void InsertClient() { db = new dal(); cmd = new OracleCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "PF_InsertClient"; cmd.Parameters.Add("@clientname", clientname); cmd.Parameters.Add("@gend", Gender); cmd.Parameters.Add("@nic_no", nic); cmd.Parameters.Add("@ntn_no", Ntn); cmd.Parameters.Add("@old_no", oldNo); cmd.Parameters.Add("@csdate", DateTime.Now.ToString("dd-MMMM-yyyy hh:mm:ss")); cmd.Parameters.Add("@actv", Active); cmd.Parameters.Add("@iscode", iscode); cmd.Parameters.Add("@ptcode", Ptcode); cmd.Parameters.Add("@clientCate", clientCategory); cmd.Parameters.Add("@islam", islam); cmd.Parameters.Add("@CPonline", online); cmd.Parameters.Add("@refer", Refer); cmd.Parameters.Add("@ContNo", ContNo); cmd.Parameters.Add("@email_add", email); cmd.Parameters.Add("@addres", address); cmd.Parameters.Add("@username", "Kashif"); db.runProPortfolio(cmd); }
public void getControlsDrp(DataTable dt) { db = new dal(); string qry = "SELECT ROWID, CAST(H.IDX as NVARCHAR2(100)) as IDX, H.CONTROLS FROM HIL.HICL_CONTROLS H ORDER BY IDX"; db.getData(qry, dt); }
public ActionResult Create([Bind(Include = "ID,firstname,lastname,email,country,password,Roles")] user user) { if (ModelState.IsValid) { var userfound = db.users.Where(u => u.email == user.email).FirstOrDefault(); if (userfound == null) { db.users.Add(user); db.SaveChanges(); dal dl = new dal(); user userauth = dl.getuser(user.email, user.password); if (User.Identity.IsAuthenticated) { FormsAuthentication.SignOut(); } FormsAuthentication.SetAuthCookie(userauth.email, true); var authTicket = new FormsAuthenticationTicket(1, userauth.email, DateTime.Now, DateTime.Now.AddMinutes(20), false, userauth.Roles); string encryptedTicket = FormsAuthentication.Encrypt(authTicket); var authCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket); HttpContext.Response.Cookies.Add(authCookie); return(RedirectToAction("Index", "orders")); } else { ModelState.AddModelError("Emailexists", "This email is already taken!"); return(View(user)); } } return(View(user)); }
public void getProject(DataTable dt) { db = new dal(); string qry = "select IDX as projectIdx, PROJECT_DESC from HICL_PROJECTS "; db.getData(qry, dt); }
public void InsertCompany() { db = new dal(); cmd = new OracleCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "InsertCompany"; cmd.Parameters.Add("@compCode", compCode); cmd.Parameters.Add("@compName", compName); cmd.Parameters.Add("@compSymbol", compSymbol); cmd.Parameters.Add("@regNo", regNo); cmd.Parameters.Add("@ntnNo", ntn); cmd.Parameters.Add("@indCode", indCode); cmd.Parameters.Add("@sector", sector); cmd.Parameters.Add("@countReg", countReg); cmd.Parameters.Add("@PassEndDate", PassEndDate); cmd.Parameters.Add("@stateLoc", stateLoc); cmd.Parameters.Add("@sataInc", sataInc); DateTime todate = DateTime.Now; cmd.Parameters.Add("@creatDate", todate); //cmd.Parameters.Add("@creatDate", DateTime.Now.ToString("dd-MM-yyyy HH:mm:ss")); cmd.Parameters.Add("@creUSer", ""); cmd.Parameters.Add("@LocFlag", LocFlag); cmd.Parameters.Add("@annualRep", annualRep); cmd.Parameters.Add("@mcCode", mc); cmd.Parameters.Add("@oclause", oclause); cmd.Parameters.Add("@countory", count); cmd.Parameters.Add("@stockExc", stockExc); cmd.Parameters.Add("@repCurrency", repCurrency); cmd.Parameters.Add("@naicsCode", naics); db.runProXbrl(cmd); //insert comoany// }
public void getScreensDrp(DataTable dt, string filter) { db = new dal(); string qry = "SELECT ROWID, CAST(H.IDX as NVARCHAR2(100)) as IDX, H.IS_ACTIVE, H.SCREEN_DESC, H.PROJECTIDX FROM HIL.HICL_SCREENS H Where PROJECTIDX = '" + filter + "' AND IS_ACTIVE = 1 ORDER BY IDX"; db.getData(qry, dt); }
public void getUserId(DataTable dt) { db = new dal(); string qry = "select USERID,USERNAME from HICL_USERS order by USERID asc "; db.getData(qry, dt); }
public void getTabsDrp(DataTable dt) { db = new dal(); string qry = "SELECT H.IDX, H.TABNAME FROM HIL.HICL_TABS H WHERE H.ISACTIVE = 1"; db.getData(qry, dt); }
public void getProjectDrop(DataTable dt) { db = new dal(); string qry = "select distinct IDX,PROJECT_DESC from HICL_PROJECTS"; db.getData(qry, dt); }
public void getGISUserId(DataTable dt) { db = new dal(); string qry = "select SUS_USERCODE,SUS_NAME from SH_SM_US_USER order by SUS_USERCODE asc "; db.getData(qry, dt); }
public ActionResult SeeScheduleLecturer() { dal dal = new dal(); string sesseionLecturerId = Session["Lecturer"].ToString(); List <Course> coureseList = (from u in dal.Courses where (u.LecId == sesseionLecturerId && u.mode == true) select u).ToList <Course>(); List <Course> coursesUser = new List <Course>(); List <String> Schudele = new List <string>(); for (int i = 0; i < coureseList.Count; i++) { string currentCourseDeatils = "Course Name: " + coureseList[i].Name.ToString() + " , Day: " + coureseList[i].Day.ToString() + " ,Hours: " + coureseList[i].Hours.ToString(); Schudele.Add(currentCourseDeatils); } ViewBag.SchudeleLec = Schudele; return(View("SeeScheduleLecturer")); }
//Galit's Change public ActionResult Register() { dal dal = new dal(); User usr = new User(); return(View("AddUser", usr)); }
public void getUserGroupDrp(DataTable dt) { db = new dal(); string qry = "SELECT ROWID, CAST(H.IDX as NVARCHAR2(100)) as IDX, H.GROUP_DESC, H.IS_ACTIVE FROM HIL.HICL_USERGROUPS H Where IS_ACTIVE = 1 ORDER BY IDX"; db.getData(qry, dt); }
public bool Post_user() { string comand = "insert into [tbl_post] (title,subject,subject2,user_id,roman_id,roman_zhaner,url) values(@title,@subject,@subject2,@user_id,@roman_id,@roman_zhaner,@url)"; List <SqlParameter> parametrlist = new List <SqlParameter>(); var title_parametr = new SqlParameter("@title", this.Title); var sub1_parametr = new SqlParameter("@subject", this.Subject1); var sub2_parametr = new SqlParameter("@subject2", this.Subject2); var uid_parametr = new SqlParameter("@user_id", this.Uid); var rid_parametr = new SqlParameter("@roman_id", this.Rid); var zh_parametr = new SqlParameter("@roman_zhaner", this.Zhaner); var url_parametr = new SqlParameter("@url", this.Url); parametrlist.Add(title_parametr); parametrlist.Add(sub1_parametr); parametrlist.Add(sub2_parametr); parametrlist.Add(uid_parametr); parametrlist.Add(rid_parametr); parametrlist.Add(zh_parametr); parametrlist.Add(url_parametr); var db = new dal(); var result = db.Executecomand(comand, parametrlist); return(result); }
public void getUserType(DataSet ds) { db = new dal(); cmd = new OracleCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "HICL_Pro_GetUserTypes"; cmd.Parameters.Add("prc", OracleDbType.RefCursor).Direction = ParameterDirection.Output; db.getDataProcedure(cmd, ds); }
public void getControlsGroupMapping(DataSet ds) { db = new dal(); cmd = new OracleCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "hicl_pro_getcntr_mappinggroup"; cmd.Parameters.Add("prc", OracleDbType.RefCursor).Direction = ParameterDirection.Output; db.getDataProcedure(cmd, ds); }
public void getControls(DataSet ds) { db = new dal(); cmd = new OracleCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "HICL_PRO_GETCONTROLS"; cmd.Parameters.Add("PRC", OracleDbType.RefCursor).Direction = ParameterDirection.Output; db.getDataProcedure(cmd, ds); }
public void getScreenParent(DataTable dt) { db = new dal(); cmd = new OracleCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "HICL_GETPARENTMENUSNAME"; cmd.Parameters.Add("@PRC", OracleDbType.RefCursor).Direction = ParameterDirection.Output; db.getData(cmd, dt); }
public void InsertTimming() { db = new dal(); cmd = new OracleCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "PF_InsertTimming"; cmd.Parameters.Add("@Timming", Timming); db.runProPortfolio(cmd); }
static void Main(string[] args) { dal d = new dal(); foreach (var person in d.GetAllPersons()) { Console.WriteLine(person.FirstName + " " + person.LastName + " " + person.PersonType.ToString()); } }
protected void Page_Load(object sender, EventArgs e) { dal objdal = new dal(); DataSet1 ds = objdal.GetPolicyData(); CrystalReport1 objRpt = new CrystalReport1(); objRpt.SetDataSource(ds.Tables[1]); CrystalReportViewer1.ReportSource = objRpt; }
public void InsertBank() { db = new dal(); cmd = new OracleCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "PF_InsertBank"; cmd.Parameters.Add("@bank", Bank); db.runProPortfolio(cmd); }
public void InsertOrderProgress() { db = new dal(); cmd = new OracleCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "PF_OrderProgress"; cmd.Parameters.Add("@OrderProgress", OrderProgress); db.runProPortfolio(cmd); }
public void InsertRelationship() { db = new dal(); cmd = new OracleCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "PF_InsertRelationShip"; cmd.Parameters.Add("@relShip", relationship); db.runProPortfolio(cmd); }
public void InsertActionType() { db = new dal(); cmd = new OracleCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "PF_InsertActionType"; cmd.Parameters.Add("@ActionType", ActionType); db.runProPortfolio(cmd); }
public static void agregarUsuarioPredeterminado(blc.Usuario usuario, dal.DT dt) { System.Data.SqlClient.SqlCommand Comando; string query; query = "INSERT INTO Usuario VALUES('" + usuario.Codigo + "','" + usuario.Password + "','" + usuario.Nombre + "','" + usuario.Apellido + "','" + usuario.Celular + "','" + usuario.Email + "','" + usuario.Grupo.Codigo + "','" + usuario.Superusuario + "')"; Comando = new System.Data.SqlClient.SqlCommand(query); Comando.Connection = dt.Connecion; Comando.Connection.Open(); Comando.ExecuteNonQuery(); Comando.Connection.Close(); }
public static void insertarConfiguracion(string nombre, dal.DT dt) { System.Data.SqlClient.SqlCommand Comando; string query; query = "INSERT INTO Bufete VALUES('" + nombre + "', 'Español', 'Papiro', '')"; Comando = new System.Data.SqlClient.SqlCommand(query); Comando.Connection = dt.Connecion; Comando.Connection.Open(); Comando.ExecuteNonQuery(); Comando.Connection.Close(); }
public static void agregarGrupoPredeterminado(blc.Grupo grupo, dal.DT dt) { System.Data.SqlClient.SqlCommand Comando; string query = "INSERT INTO Grupo VALUES('" + grupo.Codigo + "','" + grupo.Nombre + "','" + grupo.PermisoGestion + "','" + grupo.PermisoCasos + "','" + grupo.PermisoClientes + "','" + grupo.PermisoTestigos + "','" + grupo.PermisoInventario + "','" + grupo.PermisoEvidencia + "','" + grupo.PermisoReportes + "','" + grupo.PermisoConfiguracion + "')"; Comando = new System.Data.SqlClient.SqlCommand(query); Comando.Connection = dt.Connecion; Comando.Connection.Open(); Comando.ExecuteNonQuery(); Comando.Connection.Close(); }