private void LoadOpportunityDropdowns() { Business.Sales.Opportunity Obj = new Business.Sales.Opportunity(); Entity.Sales.GetCampaignParam Param = new Entity.Sales.GetCampaignParam { EndDate = DateTime.MinValue, StartDate = DateTime.MinValue, Name = null }; ddlCampaign.DataSource = Obj.GetAllCampaign(Param); ddlCampaign.DataTextField = "Name"; ddlCampaign.DataValueField = "Id"; ddlCampaign.DataBind(); ddlCampaign.InsertSelect(); ddlCommitStage.DataSource = Obj.GetCommitStage(); ddlCommitStage.DataTextField = "Name"; ddlCommitStage.DataValueField = "Id"; ddlCommitStage.DataBind(); ddlCommitStage.InsertSelect(); ddlLeadSource.DataSource = Obj.GetAllLeadSource(); ddlLeadSource.DataTextField = "Name"; ddlLeadSource.DataValueField = "Id"; ddlLeadSource.DataBind(); ddlLeadSource.InsertSelect(); }
protected void gvOpportunity_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "Ed") { OpportunityId = Convert.ToInt32(e.CommandArgument.ToString()); GetOpportunityById(); LoadSocialMediaList(); Message.Show = false; btnSave.Text = "Update"; hdnOpenForm.Value = "true"; } else if (e.CommandName == "View") { OpportunityId = Convert.ToInt32(e.CommandArgument.ToString()); GetOpportunityById(); LoadSocialMediaList(); PopulateItems(); hdnOpenForm.Value = "true"; } else if (e.CommandName == "Del") { Business.Sales.Opportunity Obj = new Business.Sales.Opportunity(); int rows = Obj.DeleteOpportunities(Convert.ToInt32(e.CommandArgument.ToString())); if (rows > 0) { ClearControls(); LoadOpportunityList(); Message.IsSuccess = true; Message.Text = "Deleted Successfully"; } else { Message.IsSuccess = false; Message.Text = "Data Dependency Exists"; } Message.Show = true; } } catch (Exception ex) { ex.WriteException(); Message.IsSuccess = false; Message.Text = ex.Message; Message.Show = true; } }
private void BindQuote(int Id) { Business.Sales.Quote Obj = new Business.Sales.Quote(); string QuoteJson = Obj.GetQuoteJsonByStageId(Id); if (QuoteJson != null && QuoteJson != string.Empty) { Entity.Sales.Quote Quote = JsonConvert.DeserializeObject <Entity.Sales.Quote>(QuoteJson); lblQuoteNo.Text = Quote.QuoteNumber; lblDate.Text = System.DateTime.Today.ToString("dd MMM yyyy"); List <Entity.Sales.QuoteLineItem> lineItem = JsonConvert.DeserializeObject <List <Entity.Sales.QuoteLineItem> >(Quote.QuoteLineItem); decimal total = 0; for (int i = 0; i < lineItem.Count; i++) { if (lineItem[i].Quantity > 0 && lineItem[i].UnitPrice > 0) { lineItem[i].Amount = Math.Round(Convert.ToDecimal(lineItem[i].Quantity), 2) * Math.Round(Convert.ToDecimal(lineItem[i].UnitPrice), 2); if (lineItem[i].Discount > 0) { lineItem[i].Amount = lineItem[i].Amount - (lineItem[i].Amount * lineItem[i].Discount / 100); } total = total + Math.Round(Convert.ToDecimal(lineItem[i].Amount), 2); } } lblSubtotal.Text = Math.Round(total, 2).ToString(); if (Quote.TaxRate != null || Quote.TaxRate == 0) { lblTaxRate.Text = "0.00"; lblGST.Text = "0.00"; lblTotal.Text = Math.Round(total, 2).ToString(); } else { lblTaxRate.Text = Quote.TaxRate.ToString(); lblGST.Text = Math.Round(total * Convert.ToDecimal(Quote.TaxRate / 100), 2).ToString(); lblTotal.Text = Math.Round(total + total * Convert.ToDecimal(Quote.TaxRate / 100), 2).ToString(); } Business.Sales.Opportunity opportunity = new Business.Sales.Opportunity(); lblCustomer.Text = opportunity.GetOpportunityById(Convert.ToInt32(Quote.OpportunityId), Convert.ToInt32(ActityType.Lead), Convert.ToInt32(ActityType.Opportunity)).Name; if (lineItem.Count > 0) { rptrRepeatLineItem.DataSource = lineItem.ToList(); rptrRepeatLineItem.DataBind(); } } }
private void LoadOpportunity() { Business.Sales.Opportunity Obj = new Business.Sales.Opportunity(); Entity.Sales.GetOpportunityParam Param = new Entity.Sales.GetOpportunityParam { BestPrice = null, CommitStageId = null, Name = null, SourceActivityTypeId = Convert.ToInt32(ActityType.Lead), ChildActivityTypeId = Convert.ToInt32(ActityType.Opportunity) }; if (HttpContext.Current.User.IsInRole(Entity.HR.Utility.CUSTOMER_LIST_SHOW_ALL)) { Param.AssignEngineer = 0; } else { Param.AssignEngineer = int.Parse(HttpContext.Current.User.Identity.Name); } ddlOpportunity.DataSource = Obj.GetAllOpportunity(Param); ddlOpportunity.DataTextField = "Name"; ddlOpportunity.DataValueField = "Id"; ddlOpportunity.DataBind(); }
private void Save() { if (OpportunityControlValidation()) { Business.Sales.Opportunity Obj = new Business.Sales.Opportunity(); Entity.Sales.Opportunity Model = new Entity.Sales.Opportunity { Id = OpportunityId, CreatedBy = Convert.ToInt32(HttpContext.Current.User.Identity.Name), Description = txtDescription.Text, Name = txtName.Text, SourceName = txtSourceName.Text, ExpectedCloseDate = txtExpectedCloseDate.Text == "" ? (DateTime?)null : Convert.ToDateTime(txtExpectedCloseDate.Text), BestPrice = txtBestPrice.Text == "" ? (decimal?)null : Convert.ToDecimal(txtBestPrice.Text), LikelyPrice = txtLikelyPrice.Text == "" ? (decimal?)null : Convert.ToDecimal(txtLikelyPrice.Text), WorstPrice = txtWorstPrice.Text == "" ? (decimal?)null : Convert.ToDecimal(txtWorstPrice.Text), CampaignId = ddlCampaign.SelectedValue == "0" ? (int?)null : Convert.ToInt32(ddlCampaign.SelectedValue), CommitStageId = ddlCommitStage.SelectedValue == "0" ? (int?)null : Convert.ToInt32(ddlCommitStage.SelectedValue), LeadSource = ddlLeadSource.SelectedValue == "0" ? (int?)null : Convert.ToInt32(ddlLeadSource.SelectedValue), IsActive = true, ActivityLinkId = ActivityLinkId, ChildActivityTypeId = Convert.ToInt32(ActityType.Opportunity), SourceActivityTypeId = Convert.ToInt32(ActityType.Lead), SourceActivityId = ddlLinkName.SelectedValue == "0" ? (int?)null : Convert.ToInt32(ddlLinkName.SelectedValue) }; int rows = Obj.SaveOpportunity(Model); if (rows > 0) { ClearControls(); LoadOpportunityList(); OpportunityId = 0; Message.IsSuccess = true; Message.Text = "Saved Successfully"; } else { Message.IsSuccess = false; Message.Text = "Unable to save data."; } Message.Show = true; } }
private void GetOpportunityById() { Business.Sales.Opportunity Obj = new Business.Sales.Opportunity(); Entity.Sales.Opportunity Opportunity = Obj.GetOpportunityById(OpportunityId, Convert.ToInt32(ActityType.Lead), Convert.ToInt32(ActityType.Opportunity)); if (Opportunity.Id != 0) { txtName.Text = Opportunity.Name; txtDescription.Text = Opportunity.Description; txtExpectedCloseDate.Text = Opportunity.ExpectedCloseDate == null ? string.Empty : Opportunity.ExpectedCloseDate.GetValueOrDefault().ToString("dd MMM yyyy"); txtLikelyPrice.Text = Opportunity.LikelyPrice == null ? string.Empty : Opportunity.LikelyPrice.ToString(); txtBestPrice.Text = Opportunity.BestPrice == null ? string.Empty : Opportunity.BestPrice.ToString(); txtWorstPrice.Text = Opportunity.WorstPrice == null ? string.Empty : Opportunity.WorstPrice.ToString(); txtSourceName.Text = Opportunity.SourceName; ddlCampaign.SelectedValue = Opportunity.CampaignId == null ? "0" : Opportunity.CampaignId.ToString(); ddlCommitStage.SelectedValue = Opportunity.CommitStageId == null ? "0" : Opportunity.CommitStageId.ToString(); ddlLeadSource.SelectedValue = Opportunity.LeadSource == null ? "0" : Opportunity.LeadSource.ToString(); ddlLinkName.SelectedValue = Opportunity.SourceActivityId == null ? "0" : Opportunity.SourceActivityId.ToString(); ActivityLinkId = Opportunity.ActivityLinkId; } }