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();
}
