void Initialize()
{
lblSalesCount.Text = SalesCount.ToString() + " " + StringSales;
lblType.Text = Type;
lblAmount.Text = Revenue + " " + Currency;
Seperator.Visible = AddSeperator;
}
public override global::System.Data.DataSet Clone()
{
SalesCount cln = ((SalesCount)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
private void salesButton_Click(object sender, EventArgs e)
{
SalesCount++;
salesCountTextBox.Text = SalesCount.ToString();
salesCountDateLabel.Text = DateTime.Now.ToString();
salesButton.Enabled = false;
salesButton.BackColor = Color.Gray;
salesTimer.Start();
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
SalesCount ds = new SalesCount();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
public List <SalesCount> SalesChartforReport()
{
SClist sclist = new SClist();
DataTable dt = d.SalesChartforReport();
for (int i = 0; i < dt.Rows.Count; i++)
{
SalesCount sc = new SalesCount()
{
sid = dt.Rows[i][0].ToString(),
sname = dt.Rows[i][1].ToString(),
scount = (int)dt.Rows[i][2]
};
sclist.AddSC(sc);
}
return(sclist.getSCList());
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex == 0)
{
FoodCount.Hide();
SalesCount.Show();
FoodToday.Hide();
}
if (comboBox1.SelectedIndex == 1)
{
SalesCount.Hide();
FoodCount.Show();
FoodCount.Location = new Point(155, 85);
FoodToday.Hide();
}
if (comboBox1.SelectedIndex == 2)
{
FoodCount.Hide();
SalesCount.Hide();
FoodToday.Show();
FoodToday.Location = new Point(155, 85);
}
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
SalesCount ds = new SalesCount();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "SalesCountDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
public List <SalesCount> GetSalesCounts(DateTime Fromdt, DateTime Todt, string salesmanager)
{
// List<salesCountDetails> lstsalescountdetailes = new List<salesCountDetails>();
SalesCount objsalescount = new SalesCount();
salesCountDetails objsalesCountDetails = new salesCountDetails();
List <salesCountDetails> lstsalesCountDetails = new List <salesCountDetails>();
List <SalesCount> lstsalescount = new List <SalesCount>();
List <SALES_tblLeadTracking> lstleadtracking = new List <SALES_tblLeadTracking>();
List <SALES_tblLeads> lstleads = new List <SALES_tblLeads>();
try {
using (var context = new CommonDBContext())
{
if (!string.IsNullOrEmpty(salesmanager))
{
objsalescount.NoOfMeeting = context.SALES_tblLeadTracking.Where(x => x.MeetingType == "1stMeeting" && x.AddedDate >= Fromdt && x.AddedDate <= Todt && x.AssignedLead == salesmanager).Count();
decimal?totalamt = (decimal?)0.00;
var grouprecord = (from d in context.BOTS_TblDealDetails
join g in context.BOTS_TblGroupMaster
on d.GroupId equals g.GroupId
join r in context.BOTS_TblRetailMaster on g.GroupId equals r.GroupId
where g.CreatedBy == salesmanager && g.CreatedDate >= Fromdt && g.CreatedDate <= Todt && g.CustomerStatus != "Draft"
select new
{
GroupId = d.GroupId,
LoyaltyFees = d.LoyaltyFees,
WAPaidPackFees = d.WAPaidPackFees,
SMSPaidPackFees = d.SMSPaidPackFees,
EcommIntegration = d.EcommIntegration,
AnyOtherFees = d.AnyOtherFees,
TotalFeesA = d.TotalFeesA,
GST = d.GST,
TotalFeesB = d.TotalFeesB,
PaymentFrequency = d.PaymentFrequency,
AnyOtherFeesDesc = d.AnyOtherFeesDesc,
AmountReceived = d.AmountReceived,
TDSDeducted = d.TDSDeducted,
PaymentMode = d.PaymentMode,
PaymentStatus = d.PaymentStatus,
GSTRate = d.GSTRate,
AdvanceAmount = d.AdvanceAmount,
Boproduct = r.BOProduct,
Noofoutlets = r.NoOfEnrolled,
createddate = g.CreatedDate,
createdby = g.CreatedBy
}).Distinct().ToList();
foreach (var itemgrp in grouprecord)
{
if (itemgrp.PaymentFrequency == "2")
{
totalamt = totalamt + itemgrp.AdvanceAmount;
//Octaxstotalamt = TotalAmount;
}
else
{
totalamt = totalamt + itemgrp.AmountReceived;
// OctaPlustotalamt = TotalAmount;
}
}
objsalescount.TotalAmount = totalamt;
objsalescount.NoOfSalesDone = grouprecord.Count();
objsalescount.NoofEnrolledOutlet = grouprecord.Select(x => x.Noofoutlets).Sum();
objsalescount.ratio = objsalescount.NoofEnrolledOutlet / objsalescount.NoOfSalesDone;
objsalescount.octaxs = grouprecord.Where(x => x.Boproduct == "2").Count();
objsalescount.octaplus = grouprecord.Where(x => x.Boproduct == "1").Count();
objsalescount.NoOfBillingpartner = (from s in context.SALES_tblLeads
join r in context.BOTS_TblRetailMaster on
s.GroupId equals r.GroupId
where (s.MeetingType == "salesdone" && s.UpdatedDate >= Fromdt && s.UpdatedDate <= Todt && s.AssignedLead == salesmanager)
select new { r.BillingPartner }).Distinct().Count();
objsalescount.lstSalesCountDetail = (from s in context.SALES_tblLeads
join ct in context.CustomerLoginDetails on s.AddedBy equals ct.LoginId
join r in context.BOTS_TblRetailMaster on
s.GroupId equals r.GroupId
join g in context.BOTS_TblGroupMaster
on r.GroupId equals g.GroupId
join d in context.BOTS_TblDealDetails on
r.GroupId equals d.GroupId
join b in context.tblBillingPartners on
s.BillingPartner equals b.BillingPartnerId.ToString()
where (g.CreatedBy == salesmanager && g.CreatedDate >= Fromdt && g.CreatedDate <= Todt && g.CustomerStatus != "Draft")
select new salesCountDetails
{
LeadId = s.LeadId,
SalesManager = ct.UserName,
BusinessName = r.BrandName,
PaymentFrequency = d.PaymentFrequency,
Product = r.BOProduct,
BillingPartner = r.BillingProduct,
OutletName = r.NoOfEnrolled,
AdvanceAmount = d.AdvanceAmount,
AmountReceived = d.AmountReceived
}).ToList();
}
else
{
objsalescount.NoOfMeeting = context.SALES_tblLeadTracking.Where(x => x.MeetingType == "1stMeeting" && x.AddedDate >= Fromdt && x.AddedDate <= Todt).Count();
decimal?totalamt = (decimal?)0.00;
var grouprecord = (from d in context.BOTS_TblDealDetails
join g in context.BOTS_TblGroupMaster
on d.GroupId equals g.GroupId
join r in context.BOTS_TblRetailMaster on g.GroupId equals r.GroupId
where g.CreatedDate >= Fromdt && g.CreatedDate <= Todt && g.CustomerStatus != "Draft"
select new
{
GroupId = d.GroupId,
LoyaltyFees = d.LoyaltyFees,
WAPaidPackFees = d.WAPaidPackFees,
SMSPaidPackFees = d.SMSPaidPackFees,
EcommIntegration = d.EcommIntegration,
AnyOtherFees = d.AnyOtherFees,
TotalFeesA = d.TotalFeesA,
GST = d.GST,
TotalFeesB = d.TotalFeesB,
PaymentFrequency = d.PaymentFrequency,
AnyOtherFeesDesc = d.AnyOtherFeesDesc,
AmountReceived = d.AmountReceived,
TDSDeducted = d.TDSDeducted,
PaymentMode = d.PaymentMode,
PaymentStatus = d.PaymentStatus,
GSTRate = d.GSTRate,
AdvanceAmount = d.AdvanceAmount,
Boproduct = r.BOProduct,
Noofoutlets = r.NoOfEnrolled,
createddate = g.CreatedDate
}).Distinct().ToList();
foreach (var itemgrp in grouprecord)
{
if (itemgrp.PaymentFrequency == "2")
{
totalamt = totalamt + itemgrp.AdvanceAmount;
//Octaxstotalamt = TotalAmount;
}
else
{
totalamt = totalamt + itemgrp.AmountReceived;
// OctaPlustotalamt = TotalAmount;
}
}
objsalescount.TotalAmount = totalamt;
objsalescount.NoOfSalesDone = grouprecord.Count();
objsalescount.NoofEnrolledOutlet = grouprecord.Select(x => x.Noofoutlets).Sum();
objsalescount.ratio = objsalescount.NoofEnrolledOutlet / objsalescount.NoOfSalesDone;
objsalescount.octaxs = grouprecord.Where(x => x.Boproduct == "2").Count();
objsalescount.octaplus = grouprecord.Where(x => x.Boproduct == "1").Count();
objsalescount.NoOfBillingpartner = (from s in context.SALES_tblLeads
join r in context.BOTS_TblRetailMaster on
s.GroupId equals r.GroupId
where (s.MeetingType == "salesdone" && s.UpdatedDate >= Fromdt && s.UpdatedDate <= Todt)
select new { r.BillingPartner }).Distinct().Count();
objsalescount.lstSalesCountDetail = (from s in context.SALES_tblLeads
join ct in context.CustomerLoginDetails on s.AddedBy equals ct.LoginId
join r in context.BOTS_TblRetailMaster on
s.GroupId equals r.GroupId
join g in context.BOTS_TblGroupMaster
on r.GroupId equals g.GroupId
join d in context.BOTS_TblDealDetails on
r.GroupId equals d.GroupId
join b in context.tblBillingPartners on
s.BillingPartner equals b.BillingPartnerId.ToString()
where (g.CreatedDate >= Fromdt && g.CreatedDate <= Todt && g.CustomerStatus != "Draft")
select new salesCountDetails
{
LeadId = s.LeadId,
SalesManager = ct.UserName,
BusinessName = r.BrandName,
PaymentFrequency = d.PaymentFrequency,
Product = r.BOProduct,
BillingPartner = r.BillingProduct,
OutletName = r.NoOfEnrolled,
AdvanceAmount = d.AdvanceAmount,
AmountReceived = d.AmountReceived
}).ToList();
}
}
lstsalescount.Add(objsalescount);
}
catch (Exception ex)
{
newexception.AddException(ex, "GetSalesCounts");
}
return(lstsalescount);
}
