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