protected void gvProspects_OnRowUpdating(object sender, GridViewUpdateEventArgs e) { var row = gvProspects.Rows[e.RowIndex]; var prospectId =Convert.ToInt32(Convert.ToString(gvProspects.DataKeys[e.RowIndex].Values[0])); var company = (row.FindControl("txtCompanyEdit") as TextBox).Text; var contactName = (row.FindControl("txtContactNameEdit") as TextBox).Text; var contactEmail =(row.FindControl("txtContactEmailEdit") as TextBox).Text; var contactPhone =(row.FindControl("txtContactPhoneEdit") as TextBox).Text; var contactCity =(row.FindControl("txtContactCityEdit") as TextBox).Text; var contactState =(row.FindControl("ddlStateEdit") as DropDownList).SelectedValue; var contactTimeZone =(row.FindControl("ddlTimeZoneEdit") as DropDownList).SelectedIndex==-1?"":(row.FindControl("ddlTimeZoneEdit") as DropDownList).SelectedValue; var createdByUserId = Guid.Parse("CF7C8C10-F16B-4746-9F05-3195682CA327"); var lastActivityDate = (row.FindControl("txtLastActivityDateEdit") as TextBox).Text; using (var dataContext = new ProspectDataContext()) { var prospect = dataContext.Prospects.FirstOrDefault(p => p.ProspectId.Equals(prospectId)); if (prospect != null) { prospect.Company = company; prospect.ContactName = contactName; prospect.ContactEmail = contactEmail; prospect.ContactPhone = contactPhone; prospect.ContactCity = contactCity; prospect.ContactState = contactState; prospect.ContactTimeZone = contactTimeZone; prospect.CreatedByUserId = createdByUserId; prospect.LastActivityDate = Convert.ToDateTime(lastActivityDate); try { dataContext.SubmitChanges(); } catch (DbEntityValidationException ex) { foreach (var eve in ex.EntityValidationErrors) { Console.WriteLine( "Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } } } } gvProspects.EditIndex = -1; BindGrid(SearchOn.None); PopulateDropdowns(); }
protected void btnAddProspect_OnClick(object sender, EventArgs e) { var txtCompanyAdd = (TextBox)gvProspects.FooterRow.FindControl("txtCompanyAdd"); var txtContactNameAdd = (TextBox)gvProspects.FooterRow.FindControl("txtContactNameAdd"); var txtContactEmailAdd = (TextBox)gvProspects.FooterRow.FindControl("txtContactEmailAdd"); var txtContactPhoneAdd = (TextBox)gvProspects.FooterRow.FindControl("txtContactPhoneAdd"); var txtContactCityAdd = (TextBox)gvProspects.FooterRow.FindControl("txtContactCityAdd"); var ddlState = (DropDownList)gvProspects.FooterRow.FindControl("ddlStateAdd"); var ddlContactTimeZoneAdd = (DropDownList)gvProspects.FooterRow.FindControl("ddlTimeZoneAdd"); var txtLastActivityDateAdd = (TextBox)gvProspects.FooterRow.FindControl("txtLastActivityDateAdd"); var dbContext = new ProspectDataContext(); var dbProspect = new Prospect { Company = txtCompanyAdd.Text, ContactName = txtContactNameAdd.Text, ContactEmail = txtContactEmailAdd.Text, ContactPhone = txtContactPhoneAdd.Text, ContactCity = txtContactCityAdd.Text, ContactState = ddlState.SelectedValue, ContactTimeZone = ddlContactTimeZoneAdd.SelectedValue, LastActivityDate =Convert.ToDateTime(txtLastActivityDateAdd.Text), CreatedByUserId = UserId }; dbContext.Prospects.InsertOnSubmit(dbProspect); dbContext.SubmitChanges(); lblMsg.Text = "Prospect for Company: " + txtCompanyAdd.Text + " added."; BindGrid(SearchOn.None); PopulateDropdowns(); }
protected void gvComments_OnRowUpdating(object sender, GridViewUpdateEventArgs e) { var row = gvComments.Rows[e.RowIndex]; var conversationId = Convert.ToInt32(Convert.ToString(gvComments.DataKeys[e.RowIndex].Values[0])); var prospectId = Convert.ToInt32(spanProspectId.InnerText); var prospectComment = (row.FindControl("txtProspectCommentEdit") as TextBox).Text; var prospectCommentType =Convert.ToInt32((row.FindControl("ddlProspectCommentTypeEdit") as DropDownList).SelectedValue); var prospectStage = Convert.ToInt32((row.FindControl("ddlProspectStageIDEdit") as DropDownList).SelectedValue); var commentSource = Convert.ToInt32((row.FindControl("ddlCommentSourcesEdit") as DropDownList).SelectedValue); var lastActivityDate2Edit = Convert.ToDateTime((row.FindControl("txtLastActivityDate2Edit") as TextBox).Text); var keyPhrase = (row.FindControl("txtKeyPhraseEdit") as TextBox).Text; using (var dataContext = new ProspectDataContext()) { var conversation = dataContext.ProspectConversations.FirstOrDefault(p => p.ConversationId.Equals(conversationId)); if (conversation != null) { conversation.ProspectComment = prospectComment; conversation.ProspectCommentTypeID = prospectCommentType; conversation.ProspectStageID = prospectStage; conversation.ProspectCommentSourceID = commentSource; conversation.KeyPhrase = keyPhrase; conversation.LastActivityDate = lastActivityDate2Edit; conversation.CreatedByUserId = UserId; try { dataContext.SubmitChanges(); } catch (DbEntityValidationException ex) { foreach (var eve in ex.EntityValidationErrors) { Console.WriteLine( "Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } } } } gvComments.EditIndex = -1; BindListOfProspects(Convert.ToInt32(spanProspectId.InnerText)); PopulateDropdownsProspectConversations(); }
protected void btnAddComments_OnClick(object sender, EventArgs e) { var txtProspectCommentAdd = (TextBox)gvComments.FooterRow.FindControl("txtProspectCommentAdd"); var ddlProspectCommentTypeAdd = (DropDownList)gvComments.FooterRow.FindControl("ddlProspectCommentTypeAdd"); var ddlProspectStageIdAdd = (DropDownList)gvComments.FooterRow.FindControl("ddlProspectStageIDAdd"); var ddlCommentSourcesAdd = (DropDownList)gvComments.FooterRow.FindControl("ddlCommentSourcesAdd"); var txtLastActivityDate2Add = (TextBox)gvComments.FooterRow.FindControl("txtLastActivityDate2Add"); var txtKeyPhraseAdd = (TextBox)gvComments.FooterRow.FindControl("txtKeyPhraseAdd"); var dbContext = new ProspectDataContext(); var dbProspectConversation = new ProspectConversation { ProspectId = Convert.ToInt32(spanProspectId.InnerText) , ProspectComment = txtProspectCommentAdd.Text, ProspectCommentTypeID = Convert.ToInt32(ddlProspectCommentTypeAdd.SelectedValue), ProspectStageID = Convert.ToInt32(ddlProspectStageIdAdd.SelectedValue), ProspectCommentSourceID = Convert.ToInt32(ddlCommentSourcesAdd.SelectedValue), KeyPhrase = txtKeyPhraseAdd.Text, LastActivityDate = Convert.ToDateTime(txtLastActivityDate2Add.Text), CreatedByUserId = UserId }; dbContext.ProspectConversations.InsertOnSubmit(dbProspectConversation); dbContext.SubmitChanges(); BindListOfProspects(Convert.ToInt32(spanProspectId.InnerText)); PopulateDropdownsProspectConversations(); }