protected void btnUpload_Click(object sender, EventArgs e) { string filename = Path.GetFileName(fileUpload1.PostedFile.FileName); string GetExts = Path.GetExtension(filename); Stream str = fileUpload1.PostedFile.InputStream; BinaryReader br = new BinaryReader(str); Byte[] size = br.ReadBytes((int)str.Length); using (ROPAEntities obj = new ROPAEntities()) { UploadFile upld = new UploadFile(); upld.GUID = Guid.NewGuid().ToString(); //upld.FIleFor=100; upld.FIleFor = filename; upld.SurApp_Id = 47; upld.fileext = GetExts; obj.AddToUploadFiles(upld); obj.SaveChanges(); } BindGridviewData(); }
protected void btnUpload_Click(object sender, EventArgs e) { string filename = Path.GetFileName(fileUpload1.PostedFile.FileName); Stream stream = fileUpload1.PostedFile.InputStream; string extension = Path.GetExtension(filename); //Write Save Logic to file/ BinaryReader br = new BinaryReader(stream); Byte[] size = br.ReadBytes((int)stream.Length); //SaveToFolder(stream, filename); //Database already here List<UploadFile> L = ResolveList(); using (ROPAEntities obj = new ROPAEntities()) { Guid G = Guid.NewGuid(); UploadFile upld = new UploadFile(); upld.GUID = G.ToString(); upld.FIleFor = filename; upld.SurApp_Id = null; obj.AddToUploadFiles(upld); obj.SaveChanges(); L.Add(upld); } UpdateSession(L); BindGridviewData(); }
protected void btnUpload_Click(object sender, EventArgs e) { try { var filename = Path.GetFileName(fileUpload1.PostedFile.FileName); var getExts = Path.GetExtension(filename); var str = fileUpload1.PostedFile.InputStream; var br = new BinaryReader(str); var size = br.ReadBytes((int) str.Length); using (var obj = new ROPAEntities()) { var upld = new UploadFile(); upld.GUID = Guid.NewGuid().ToString(); upld.AppVersion = (decimal) 2.30; upld.FIleFor = filename; upld.SurApp_Id = 47; upld.fileext = getExts; obj.AddToUploadFiles(upld); obj.SaveChanges(); } BindGridviewData(); } catch (Exception) { } }
public List<FeedbackDeatils> FeedbackDetailsToGrid() { using (ROPAEntities obj = new ROPAEntities()) { var Query = (from a in obj.FeedBackForms select new FeedbackDeatils { Feedbackid = a.FeedBackId, Comments = a.Commments }).ToList().Take(5); return Query.ToList(); } }
public void BindDeatails() { using (ROPAEntities obj = new ROPAEntities()) { var userdetails = (from a in obj.UpcmomingSurveyors select a).ToList().Count; // userdetails; } }
private void GenrateDropDownlist() { var context = new ROPAEntities(); var query = from m in context.Countries select m; ddlCountry.DataValueField = "countrycode"; ddlCountry.DataTextField = "CountryName"; ddlCountry.DataSource = query; ddlCountry.DataBind(); }
public bool CheckAvliablity(string EmailId) { using (ROPAEntities context = new ROPAEntities()) { bool exists = context.UpcmomingSurveyors.Any(u => u.EMAILID == EmailId); return exists; } }
public UploadFile GetDocument(int id) { using (ROPAEntities entity = new ROPAEntities()) { var doc = (from a in entity.UploadFiles where a.UPloadId == id select a).FirstOrDefault(); return doc; } }
void GenrateDropdownlist() { //Model ROPAEntities context = new ROPAEntities(); //LinQ to sql Query var query = from m in context.UpcomingRoles select m; ddlRoleId.DataValueField = "RoleId"; ddlRoleId.DataTextField = "RoleName"; ddlRoleId.DataSource = query; ddlRoleId.DataBind(); }
public int Deleteuser(string FirstName) { int result = 0; using (ROPAEntities context = new ROPAEntities()) { var UserName = (from u in context.UpcmomingSurveyors where u.FirstName == FirstName select new { u.LastName }).FirstOrDefault(); var deleteQuery = (from u in context.UpcmomingSurveyors where u.FirstName == FirstName select u).FirstOrDefault(); context.DeleteObject(deleteQuery); result=context.SaveChanges(); return result; } }
protected void bttnseach_Click(object sender, EventArgs e) { //GenrateDropdownlist(); int value; value = Convert.ToInt32(txtSrch.Text); if (value != null) { ROPAEntities cont = new ROPAEntities(); var kk = (from a in cont.UpcmomingSurveyors where a.SurApp_Id == value select a).FirstOrDefault(); txtFrstName.Text = kk.FirstName; txtLastName.Text = kk.LastName; ddlRoleId.SelectedIndex = Convert.ToInt32(kk.ApplyAsRole); txtpsswrd.Text = kk.Password; tblreg.Visible = true; } }
public int insertRecord(string FName, string EmailId, string PhoneNumb, string Address, string CuntryCode, string commnts) { using (var cont = new ROPAEntities()) { var obj = new FeedBackForm{ FirstName = FName, EmailId = EmailId, PhoneNumber = PhoneNumb, Addres = Address, countrycode = CuntryCode, Commments = commnts, insertDate = DateTime.Now }; cont.AddToFeedBackForms(obj); int result = cont.SaveChanges(); return result; } }
public int insertRecord(string FName, string EmailId, string PhoneNumb, string Address, string CuntryCode, string commnts) { int result = 0; using (ROPAEntities cont = new ROPAEntities()) { FeedBackForm obj = new FeedBackForm(); obj.FirstName = FName; obj.EmailId = EmailId; obj.PhoneNumber = PhoneNumb; obj.Addres = Address; obj.countrycode = CuntryCode; obj.Commments = commnts; obj.insertDate = DateTime.Now; cont.AddToFeedBackForms(obj); result = cont.SaveChanges(); return result; } }
protected void Button1_Click(object sender, EventArgs e) { string emailid; emailid = txtInt.Text.Trim(); ROPAEntities context = new ROPAEntities(); var Query = (from a in context.UpcmomingSurveyors where a.EMAILID == emailid select a).FirstOrDefault(); if (Query != null) { ROPAUtil obj = new ROPAUtil(); Query.FirstName = txtFrstName.Text.Trim(); Query.LastName = txtLastName.Text.Trim(); Query.ApplyAsRole = Convert.ToInt32(ddlRoleId.SelectedValue); Query.Password = txtpsswrd.Text.Trim(); Query.EMAILID = txtEmailId.Text.Trim(); Query.ModifedDate = DateTime.Now; Query.AppId = 2; context.SaveChanges(); } }
protected void bttnsubmt_Click(object sender, EventArgs e) { //Get Record by id //int value; // value = Convert.ToInt32(txtInt.Text); string emailid; emailid = txtInt.Text.Trim(); if (emailid != null) { ROPAEntities cont = new ROPAEntities(); var Query = (from a in cont.UpcmomingSurveyors where a.EMAILID==emailid select a).FirstOrDefault(); txtFrstName.Text = Query.FirstName; txtLastName.Text = Query.LastName; ddlRoleId.SelectedIndex = Convert.ToInt32(Query.ApplyAsRole); txtpsswrd.Text = Query.Password; txtEmailId.Text = Query.EMAILID; } }
protected void DropDownlist() { ROPAEntities context = new ROPAEntities(); var query = from m in context.UpcomingRoles select m; Label lblddlrole = new Label(); lblddlrole.Text = "Apply As Role"; plcHldrRegsform.Controls.Add(lblddlrole); DropDownList ddldropdwnlist = new DropDownList(); ddldropdwnlist.ID = "Ddlroleid"; ddldropdwnlist.Items.Add(new ListItem("Select","0")); ddldropdwnlist.Items.Add(new ListItem(Convert.ToString(ddldropdwnlist.DataValueField="RoleId").ToString(),Convert.ToString(ddldropdwnlist.DataTextField="RoleName").ToString())); ddldropdwnlist.DataSource = query; ddldropdwnlist.DataBind(); plcHldrRegsform.Controls.Add(ddldropdwnlist); // for (int i = 65; i <= 70; i++) // { //ddldropdwnlist.Items.Add(new ListItem(Convert.ToChar(i).ToString(),Convert.ToChar(i).ToString())); // plcHldrRegsform.Controls.Add(ddldropdwnlist); // } }
public void UpdateRecord(string FirstName, string Lastname, int applyAsrole, string password, string emailId) { // int result = 0; using (ROPAEntities context = new ROPAEntities()) { UpcmomingSurveyor obj = new UpcmomingSurveyor(); obj.FirstName = FirstName; obj.LastName = Lastname; obj.ApplyAsRole = applyAsrole; obj.Password = password; obj.EMAILID = emailId; obj.ModifedDate = DateTime.Now; obj.AppId = 2; // context.AddToUpcmomingSurveyors(obj); // result= context.SaveChanges(); // return result; } }
public int InsertRecord(string FirstName, string Lastname, int applyAsrole, string password, string emailId, List<UploadFile> L) { int result = 0; using (ROPAEntities context = new ROPAEntities()) { UpcmomingSurveyor obj = new UpcmomingSurveyor(); obj.FirstName = FirstName; obj.LastName = Lastname; obj.ApplyAsRole = applyAsrole; obj.Password = password; obj.AppId = 1; obj.ModifedDate = DateTime.Now; obj.EMAILID = emailId; context.AddToUpcmomingSurveyors(obj); foreach (UploadFile G in L) { UploadFiles Upld = new UploadFiles(); string s = G.GUID; var Q = (from u in context.UploadFiles where u.GUID ==s select u).FirstOrDefault(); Q.SurApp_Id = obj.SurApp_Id; } context.SaveChanges(); return result; } }
protected void btnUpload_Click(object sender, EventArgs e) { string filename = Path.GetFileName(fileUpload1.PostedFile.FileName); Stream stream = fileUpload1.PostedFile.InputStream; int fileSize = fileUpload1.PostedFile.ContentLength; string extension = Path.GetExtension(filename); //Write Save Logic to file/ BinaryReader br = new BinaryReader(stream); Byte[] size = br.ReadBytes((int)stream.Length); //SaveToFolder(stream, filename); //Database already here List<UploadFile> L = ResolveList(); if (L.Count > 0) { //If file is Already Exist or not if exist skip this step bool flag; flag = IsFileExistOrNot(L, filename); if (IsFileExistOrNot(L, filename) == false) { using (ROPAEntities obj = new ROPAEntities()) { Guid G = Guid.NewGuid(); UploadFile upld = new UploadFile(); upld.GUID = G.ToString(); upld.FIleFor = filename; upld.SurApp_Id = null; upld.filecc = size; obj.AddToUploadFiles(upld); obj.SaveChanges(); L.Add(upld); } UpdateSession(L); BindGridviewData(); } } else { //Not there here first time using (ROPAEntities obj = new ROPAEntities()) { Guid G = Guid.NewGuid(); UploadFile upld = new UploadFile(); upld.GUID = G.ToString(); upld.FIleFor = filename; upld.filecc = size; obj.AddToUploadFiles(upld); obj.SaveChanges(); L.Add(upld); } UpdateSession(L); BindGridviewData(); } }
public List<UploadFiles> FilesToGrid() { using (ROPAEntities obj = new ROPAEntities()) { var query = (from a in obj.UploadFiles select new UploadFiles { UploadId = a.UPloadId, Filepath = a.FIleFor }).ToList(); return query.ToList(); } }
void GenrateDropdownlist() { try { ROPAEntities context = new ROPAEntities(); var query = from m in context.UpcomingRoles select m; ddlRoleId.DataValueField = "RoleId"; ddlRoleId.DataTextField = "RoleName"; ddlRoleId.DataSource = query; ddlRoleId.DataBind(); } catch (Exception) { } }
void Clear() { txtEmailId.Text = ""; txtFrstName.Text = ""; txtLastName.Text = ""; txtpsswrd.Text = ""; ddlRoleId.ClearSelection(); using (ROPAEntities context = new ROPAEntities()) { var deleteQuery = (from u in context.UploadFiles where u.SurApp_Id == null select u).ToList(); context.DeleteObject(deleteQuery); context.SaveChanges(); } ClearSession(); }
protected void gvDetails_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { e.Cancel = true; int UploadId = Convert.ToInt32(gvDetails.DataKeys[e.RowIndex].Value); List<UploadFile> L = ResolveList(); using (ROPAEntities contxt = new ROPAEntities()) { var entity = (from surapp in contxt.UploadFiles where surapp.UPloadId == UploadId select surapp).FirstOrDefault(); contxt.UploadFiles.DeleteObject(entity); contxt.SaveChanges(); foreach (UploadFile item in L) { if (item.UPloadId == UploadId) { L.Remove(item); break; } } } UpdateSession(L); BindGridviewData(); } catch (Exception ex) { // ACR.Framework.Common.Utilities.WriteToLogFile(new StackFrame(true), "LinkButtonDelete_Click", LoginUser.UserID.ToString(), TraceEventType.Error); } }
public string GetUserDetailsByEmailId(string EmailId) { using (ROPAEntities context = new ROPAEntities()) { var UserPassword = (from u in context.UpcmomingSurveyors where u.EMAILID == EmailId select u.Password).FirstOrDefault(); return UserPassword; } }
public byte GetDoc(int UploadId) { using (ROPAEntities obj = new ROPAEntities()) { var doc = (from a in obj.UploadFiles where a.UPloadId == UploadId select a.filecc); return Convert.ToByte(doc); } }
public void UPdateFeedbackdetails(int number, string Comments) { using (ROPAEntities obj = new ROPAEntities()) { var query = (from a in obj.FeedBackForms where a.FeedBackId == number select a).FirstOrDefault(); if (query != null) { query.Commments = Comments.Trim(); query.insertDate = DateTime.Now; obj.SaveChanges(); } } }