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