protected void gvBranch_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { int BranchId = Convert.ToInt32(gvBranch.DataKeys[e.RowIndex].Values[0]); Branch_Detail objCV = (from c in dbJalagam.Branch_Details where c.Branch_Id == BranchId select c).FirstOrDefault(); dbJalagam.Branch_Details.DeleteOnSubmit(objCV); dbJalagam.SubmitChanges(); } catch (Exception ex) { throw ex; // dbEMUP.Transaction.Rollback(); } finally { this.BindGridBranches(); } }
private void GetData() { var objC = from objV in dbJalagam.Branch_Details where objV.Branch_Id == Convert.ToInt32(Request.QueryString["Id"]) select objV; Branch_Detail objK = objC.SingleOrDefault(); lblAddress.Text = Convert.ToString(objK.Address); lblBranchName.Text = Convert.ToString(objK.Branch_Name); lblContactNumbers.Text = Convert.ToString(objK.ContactNumbers); lblEmailId.Text = Convert.ToString(objK.EmailId); }
private void Save() { Branch_Detail objK = new Branch_Detail(); // objU.UserEmailId = Context.User.Identity.Name.ToString(); objK.Branch_Name = Convert.ToString(txtBranchName.Text); objK.Address = Convert.ToString(txtAddress.Text); objK.ContactNumbers = Convert.ToString(txtContactNo.Text); objK.EmailId = Convert.ToString(txtEMailId.Text); objK.State = Convert.ToString(ddlState.SelectedValue); objK.CreatedDate = DateTime.Now; dbJalagam.Branch_Details.InsertOnSubmit(objK); dbJalagam.SubmitChanges(); clsPublic.ClearControls(Page.Controls); lblMsg.Text = "<div><i class='fa fa-check fa-2x'></i>" + "Submitted Successfully" + "</div>"; }