protected void btnRegister_Click(object sender, EventArgs e) { foreach (GridViewRow row in gvCourseRegistration.Rows) { CheckBox cb = (CheckBox)row.FindControl("RegisterThis"); if (cb != null && cb.Checked) { int id = Convert.ToInt32(gvCourseRegistration.DataKeys[row.RowIndex].Value); int cid = Convert.ToInt32(row.Cells[1].Text); RegistrationDAL rdal = new RegistrationDAL(); string email = Session["Course_Key"].ToString(); DataSet sid = rdal.getStudent(email); DataTable dt = sid.Tables[0]; DataRow dr = dt.Rows[0]; int stdid = (int)dr["Student_id"]; string fname = dr["first_name"].ToString(); string lname = dr["last_name"].ToString(); string name = fname + ' ' + lname; try { rdal.RegisterCourse(cid, stdid, name); gvCourseRegistration.Visible = false; btnRegister.Visible = false; heading1.InnerText = "Course has been Successfully registered"; } catch (Exception ex) { lblAlready.Text = " Course Already Registered"; } } } }
public bool GetById() { bool res = false; res = RegistrationDAL.GetById(this); return(res); }
public bool Delete() { bool res = false; res = RegistrationDAL.Delete(this); return(res); }
static void Main(string[] args) { Console.SetWindowSize((int)(Console.WindowWidth * 1.2), Console.WindowHeight); Console.Title = "Workshop 2"; var menu = new Menu(); var db = new RegistrationDAL(); var reg = new Registration(db); var V_console = new ConsoleView(menu); var C_app = new Application(V_console, reg); V_console.DisplayMenu(Menu.MenuItems.Main); //Simple error handling. Application starts over if an exception is thrown. Start: try { while (C_app.Run()) { ; } } catch { Console.Clear(); V_console.DisplayMenu(Menu.MenuItems.Main); Console.Write("Something went wrong. Please try again"); goto Start; } }
public string NewRegistration(string registrationString) //Want to change in this service as enc and dec algo { try { if (registrationString != null && !String.IsNullOrEmpty(registrationString) && !String.IsNullOrWhiteSpace(registrationString)) { String[] dataArray = registrationString.Split(new char[] { '*' }); if (dataArray.Length == 8) { //insert into database Random otpGenerator = new Random(); string otpNumber = otpGenerator.Next(1000, 9999).ToString(); RegistrationDAL registrationDal = new RegistrationDAL(); CommonCode commonCode = new CommonCode(); // string password = commonCode.DESEncrypt(dataArray[3]); //string password = dataArray[3]; string password = dataArray[3]; string userName = dataArray[2]; userName = EncryptDecrypt.DecodeAndDecrypt(userName); password = EncryptDecrypt.DecodeAndDecrypt(password); string pw = password.Substring(0, password.Length - 12); password = commonCode.DESEncrypt(pw); string dt1 = userName.Substring(userName.Length - 12); userName = userName.Substring(0, userName.Length - 12); string retVal = objenc.DateTimeDec(dt1); if (retVal == "0") { return(CommonCode.SQL_ERROR.ToString()); } //string result = registrationDal.newRegistration(dataArray[0], dataArray[1], dataArray[2], password, otpNumber, dataArray[4], dataArray[5], dataArray[6], dataArray[7]); string result = registrationDal.newRegistration(dataArray[0], dataArray[1], userName, password, otpNumber, dataArray[4], dataArray[5], dataArray[6], dataArray[7]); string[] r = result.Split(new Char[] { '*' }); if (r[0] == CommonCode.OK.ToString()) { //string message = "Dear " + dataArray[2] + " thanks to Register your Voter Profile in True Voter app. OTP for profile confirmation is " + otpNumber + ""; string message = "Dear " + userName + " thanks to Register your Voter Profile in True Voter app. OTP for profile confirmation is " + otpNumber + ""; SendSMS(dataArray[1], message); } return(result.ToString()); } else { return(CommonCode.WRONG_INPUT.ToString()); } } return(CommonCode.WRONG_INPUT.ToString()); } catch (Exception) { return(CommonCode.ERROR.ToString()); } }
public User Register(User user) { User u = new User(); RegistrationDAL registrationDAL = new RegistrationDAL(); u = registrationDAL.CreateNewUser(user); return(u); }
public static void CreateTables() { ClassDAL.CreateTable(); ClientDAL.CreateTable(); CoachDAL.CreateTable(); RegistrationDAL.CreateTable(); RoomDAL.CreateTable(); }
public bool Create() { bool res = false; if (!RegistrationDAL.GetByRef(this)) { res = RegistrationDAL.Create(this); } return(res); }
public void lbDRegister_Click(object sender, EventArgs e) { foreach (GridViewRow row in gvCourse.Rows) { int cid = Convert.ToInt32(row.Cells[0].Text); RegistrationDAL cdal = new RegistrationDAL(); cdal.DeRegisterCourse(cid); Response.Redirect(Request.Url.AbsoluteUri); } }
//public DataTable GetAllActive() //{ // try // { // DataTable dtList = GetAll(); // var rows = dtList.AsEnumerable().Where(x => ((bool)x["IsActive"]) == true); // DataTable dt = rows.Any() ? rows.CopyToDataTable() : dtList.Clone(); // if (dt != null) // if (dt.Rows.Count > 0) // return dt; // else // return null; // else // return null; // } // catch (Exception) // { // throw; // } //} public DataTable GetById(int id) { try { RegistrationDAL registrationDAL = new RegistrationDAL(); return(registrationDAL.GetById(id)); } catch (Exception) { throw; } }
public bool Delete(Registrations registration) { try { RegistrationDAL registrationDAL = new RegistrationDAL(); return(registrationDAL.Delete(registration)); } catch (Exception) { throw; } }
public string checkOtp(string mobileNo, string otp) //Want to change in this service as enc and dec algo { RegistrationDAL registrationDal = new RegistrationDAL(); string[] uregid = mobileNo.Split('$'); string[] otpid = otp.Split('$'); mobileNo = objenc.DecryptInteger(uregid[0], uregid[1]); otp = objenc.DecryptInteger(otpid[0], otpid[1]); return(registrationDal.checkOtp(mobileNo, otp)); }
public DataTable GetAll() { try { RegistrationDAL registrationDAL = new RegistrationDAL(); return(registrationDAL.GetAll()); } catch (Exception) { throw; } }
public void Page_Load(object sender, EventArgs e) { try { this.Master.name.Text = Session["User"].ToString(); } catch (Exception ex) { Response.Redirect("index.aspx"); } d.getcount(); count.Text = d.count.ToString(); ins(); venue(); vol(); hosp(); course(); registration(); atmosphere(); DataSet ds = cd.getOfferedCourse(); gvCourseRegistration.DataSource = ds; gvCourseRegistration.DataBind(); StringBuilder htmlTable = new StringBuilder(); RegistrationDAL rdal = new RegistrationDAL(); DataSet ds1 = rdal.getStudent(); htmlTable.Append("<table border='1' id='Table1' class='table table-bordered table-hover table-responsive' width='500px' height='80'>"); htmlTable.Append("<tr style='background-color:#591919; color: White; '><th style='text-align:center'>Course ID</th><th style='text-align:center'>Course Name</th><th style='text-align:center'>Total Enrolled Students</th></tr>"); int j = 1000; for (int i = 0; i < ds1.Tables[0].Rows.Count; i++) { int cid = Convert.ToInt32(ds1.Tables[0].Rows[i]["Course_id"]); int countt = rdal.getcount(cid); htmlTable.Append("<tr style='color: black;'>"); htmlTable.Append("<td>" + ds1.Tables[0].Rows[i]["Course_id"] + "</td>"); htmlTable.Append("<td>" + ds1.Tables[0].Rows[i]["Course_Name"] + "</td>"); htmlTable.Append("<td>" + countt + "</td>"); htmlTable.Append("</tr>"); } htmlTable.Append("</table>"); DBDataPlaceHolder.Controls.Add(new Literal { Text = htmlTable.ToString() }); }
public int gcmRegistration(string mobile, string regid, int userType) { try { RegistrationDAL reg = new RegistrationDAL(); string[] uregid = mobile.Split('$'); mobile = objenc.DecryptInteger(uregid[0], uregid[1]); return(reg.GCMRegistration(mobile, regid, userType)); } catch { return(0); } }
protected void Page_Load(object sender, EventArgs e) { try { this.Master.name.Text = Session["User"].ToString(); } catch (Exception ex) { Response.Redirect("index.aspx"); } StringBuilder htmlTable = new StringBuilder(); RegistrationDAL rdal = new RegistrationDAL(); DataSet ds = rdal.getStudent(); htmlTable.Append("<table border='1' id='Table1' class='table table-bordered table-hover table-responsive' width='500px' height='80'>"); htmlTable.Append("<tr style='background-color:#591919; color: White; '><th style='text-align:center'>Course ID</th><th style='text-align:center'>Course Name</th><th style='text-align:center'>Total Enrolled Students</th></tr>"); int j = 1000; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int cid = Convert.ToInt32(ds.Tables[0].Rows[i]["Course_id"]); int count = rdal.getcount(cid); htmlTable.Append("<tr style='color: black;'>"); htmlTable.Append("<td>" + ds.Tables[0].Rows[i]["Course_id"] + "</td>"); htmlTable.Append("<td>" + ds.Tables[0].Rows[i]["Course_Name"] + "</td>"); htmlTable.Append("<td>" + count + "</td>"); htmlTable.Append("</tr>"); } htmlTable.Append("</table>"); DBDataPlaceHolder.Controls.Add(new Literal { Text = htmlTable.ToString() }); lblNo.Visible = false; if (ds.Tables[0].Rows.Count == 0) { DBDataPlaceHolder.Visible = false; lblNo.Visible = true; } }
public string resendOtp(string mobileNo) //Want to change in this service as enc and dec algo { string[] uregid = mobileNo.Split('$'); mobileNo = objenc.DecryptInteger(uregid[0], uregid[1]); RegistrationDAL registrationDal = new RegistrationDAL(); string result = registrationDal.resendOTP(mobileNo); if (result != "" && result != CommonCode.WRONG_INPUT.ToString() && result != CommonCode.SQL_ERROR.ToString() && result != CommonCode.ERROR.ToString() && result != CommonCode.WRONG_INPUT.ToString()) { CommonCode commoncode = new CommonCode(); string message = "Dear " + mobileNo + " thanks to Register your Voter Profile in True Voter app. OTP for profile confirmation is " + result + ""; commoncode.SMS(mobileNo, message); return(CommonCode.OK.ToString()); } else { return(WRONG_INPUT.ToString()); } }
public List <Registration> GetRegistrationInfo(string productCode) { List <Registration> lstRegByProduct = new List <Registration>(); DataTable dtRegistration = new DataTable(); RegistrationDAL regDAL = new RegistrationDAL(); dtRegistration = regDAL.RetrieveRegistrations(productCode); foreach (DataRow dr in dtRegistration.Rows) { Registration aRegistration = new Registration(); aRegistration.CustomerID = (int)dr["CustomerID"]; aRegistration.Name = dr["Name"].ToString(); //Name is not in Registration table, need to verify aRegistration.CustomerEmail = dr["Email"].ToString(); aRegistration.DateRegistered = (DateTime)dr["RegistrationDate"]; lstRegByProduct.Add(aRegistration); } return(lstRegByProduct); }
public bool Save(Registrations registration) { try { RegistrationDAL registrationDAL = new RegistrationDAL(); if (IsContactNumberExist(registration)) { throw new Exception("Contact number already exist."); } else { return(registrationDAL.Save(registration)); } } catch (Exception) { throw; } }
public bool AddNewRegistration(Registration aRegistration) { RegistrationDAL regDAL = new RegistrationDAL(); //cast registration object into individual properties?? int cID = aRegistration.CustomerID; string pCode = aRegistration.ProductCode; DateTime rDate = aRegistration.RegistrationDate; bool registerProduct = regDAL.RegisterProduct(pCode, cID, rDate); if (registerProduct == true) { return(true); } else// if RegisterProduct() returns false, a record already exists! { return(false); } }
public static ObservableCollection <Registration> ClienteRegistado() { return(RegistrationDAL.ClienteRegistado()); }
public int newProfile(string profileString, string photo) { try { string[] dataArray = profileString.Split(new char[] { '*' }); if (dataArray.Length == 35) { Profile userProfile = new Profile(); string[] uregid = dataArray[0].Split('$'); string substr = uregid[0].Substring(0, 3); string ump = uregid[0].ToString(); int len = ump.Length; len = len - 3; ump = ump.Substring(3, len); userProfile.RegId = objenc.DecryptInteger(ump, uregid[1]); userProfile.RegId = substr + userProfile.RegId; //dataArray[0]; userProfile.dob = dataArray[1]; userProfile.email = dataArray[2]; userProfile.photo = photo; userProfile.userType = 1; userProfile.imeiNo = dataArray[3]; userProfile.registrationDate = DateTime.Now.Date.ToString("yyyy-MM-dd"); userProfile.updationDate = DateTime.Now.Date.ToString("yyyy-MM-dd"); userProfile.status = 1; userProfile.loginId = "0"; userProfile.acno = dataArray[4]; userProfile.partNo = dataArray[5]; userProfile.slnoinpart = dataArray[6]; userProfile.houseNo = dataArray[7]; userProfile.sectionno = dataArray[8]; userProfile.fm_name_v1 = dataArray[9]; userProfile.Lastname_v1 = dataArray[10]; userProfile.RLN_TYPE = dataArray[11]; userProfile.RLN_FM_NM_v1 = dataArray[12]; userProfile.RLN_L_NM_v1 = dataArray[13]; userProfile.IDCARD_NO = dataArray[14]; userProfile.STATUSTYPE = dataArray[15]; userProfile.SEX = dataArray[16]; userProfile.AGE = dataArray[17]; userProfile.FM_NAMEEN = dataArray[18]; userProfile.LASTNAMEEN = dataArray[19]; userProfile.RLN_FM_NMEN = dataArray[20]; userProfile.RLN_L_NMEN = dataArray[21]; userProfile.FULL_NAMEEN = dataArray[22]; userProfile.EB_No = dataArray[23]; userProfile.Allocated_Ward = dataArray[24]; userProfile.SerialNo_InWard = dataArray[25]; userProfile.BoothNo = dataArray[26]; userProfile.SerialNo_ForFinalList = dataArray[27]; userProfile.old_serialIn_ward = dataArray[28]; userProfile.localBody = dataArray[29]; userProfile.uid = dataArray[30]; userProfile.latitude = dataArray[31]; userProfile.langitute = dataArray[32]; userProfile.distritId = dataArray[33]; userProfile.assemblyId = dataArray[34]; userProfile.assemblyId = dataArray[35]; //Added18-1-17 RegistrationDAL registrationDal = new RegistrationDAL(); return(registrationDal.addProfile(userProfile)); } else { return(CommonCode.WRONG_INPUT); } } catch (Exception) { return(CommonCode.ERROR); } }
public RegistrationBLL(string connectionString) { data = new RegistrationDAL(connectionString); }
public bool AddNewRegistration(Registration aRegistration) { RegistrationDAL regDAL = new RegistrationDAL(); return(regDAL.RegisterProduct(aRegistration.ProductCode, aRegistration.CustomerID, aRegistration.RegistrationDate)); }
public XmlDocument GetProfile(string regId) { XmlDocument xmlDocument = new XmlDocument(); RegistrationDAL registrationDal = new RegistrationDAL(); try { string[] uregid = regId.Split('$'); string substr = uregid[0].Substring(0, 3); string ump = uregid[0].ToString(); int len = ump.Length; len = len - 3; ump = ump.Substring(3, len); regId = objenc.DecryptInteger(ump, uregid[1]); regId = substr + regId; registrationDal.UserProfileData(regId); if (registrationDal.isError == CommonCode.OK) { if (registrationDal.userData != null && registrationDal.userData.Tables[0].Rows.Count != 0) { registrationDal.userData.Tables[0].TableName = "UserProfile"; XmlDataDocument xmlDataDocument = new XmlDataDocument(registrationDal.userData); XmlElement element = xmlDataDocument.DocumentElement; return(xmlDataDocument); } else if (registrationDal.userData.Tables[0].Rows.Count == 0) { XmlDocument doc = new XmlDocument(); XmlNode docNode = doc.CreateXmlDeclaration("1.0", "UTF-8", null); doc.AppendChild(docNode); XmlNode errrorNode = doc.CreateElement("ErrorMainNode"); doc.AppendChild(errrorNode); XmlNode nameNode = doc.CreateElement("Error"); nameNode.AppendChild(doc.CreateTextNode(CommonCode.DATA_NOT_FOUND.ToString())); errrorNode.AppendChild(nameNode); return(doc); } } else { XmlDocument doc = new XmlDocument(); XmlNode docNode = doc.CreateXmlDeclaration("1.0", "UTF-8", null); doc.AppendChild(docNode); XmlNode errrorNode = doc.CreateElement("ErrorMainNode"); doc.AppendChild(errrorNode); XmlNode nameNode = doc.CreateElement("Error"); nameNode.AppendChild(doc.CreateTextNode(Convert.ToString(registrationDal.isError))); errrorNode.AppendChild(nameNode); } return(xmlDocument); } catch { CommonCode commonCode = new CommonCode(); return(commonCode.ErrorXml(CommonCode.SQL_ERROR)); } }
public static ObservableCollection <Registration> GetAll() { return(RegistrationDAL.GetAll()); }
public bool Update() { return(RegistrationDAL.Update(this)); }
public NinjectRegistrations() { _registrationDAL = new RegistrationDAL(); _registrationBLL = new RegistrationBLL(); }