private void button1_Click(object sender, EventArgs e)
{
try
{
_entities = new MicroAccountsEntities1();
int rowNo = 1;
dgDailyRateReport.AutoGenerateColumns = false;
_entities = new MicroAccountsEntities1();
List <DailyRateVM> modelList = new List <DailyRateVM>();
List <DailyRate> data = new List <DailyRate>();
DateTime fromdate = DateTime.ParseExact(dateTimePicker1.Text, "dd-MM-yyyy", null);
DateTime todate = DateTime.ParseExact(dateTimePicker2.Text, "dd-MM-yyyy", null);
if (fromdate > todate)
{
MessageBox.Show("Invalid date entered. Select valid dates");
return;
}
else
{
data = _entities.DailyRates.Where(x => x.date >= fromdate && x.date <= todate).OrderByDescending(x => x.id).ToList();
foreach (var item in data)
{
DailyRateVM model = new DailyRateVM();
model.id = item.id;
model.rowNo = rowNo;
model.date = Convert.ToDateTime(item.date).Date.ToString("dd-MM-yyyy");
model.fineGold = Convert.ToDecimal(amtFormat.comma(item.fineGold));
model.twentyTwoC = Convert.ToDecimal(amtFormat.comma(item.twentyTwoC));
model.twentyThreeC = Convert.ToDecimal(amtFormat.comma(item.twentyThreeC));
model.silver = Convert.ToDecimal(amtFormat.comma(item.silver));
model.hallmark = Convert.ToDecimal(amtFormat.comma(item.hallmark));
model.hallmarkBuyBack = Convert.ToDecimal(amtFormat.comma(item.hallmarkBuyBack));
modelList.Add(model);
rowNo++;
}
dgDailyRateReport.DataSource = modelList;
}
}
catch (Exception x)
{
}
}
private void dataGridBind()
{
try
{
dgDailyRateReport.AutoGenerateColumns = false;
int rowNo = 1;
_entities = new MicroAccountsEntities1();
var data = _entities.DailyRates.OrderByDescending(x => x.id).ToList();
List <DailyRateVM> modelList = new List <DailyRateVM>();
foreach (var item in data)
{
if (data.Count < 8)
{
DailyRateVM model = new DailyRateVM();
model.id = item.id;
model.rowNo = rowNo;
model.date = Convert.ToDateTime(item.date).Date.ToString("dd-MM-yyyy");
model.fineGold = Convert.ToDecimal(amtFormat.comma(item.fineGold));
model.twentyTwoC = Convert.ToDecimal(amtFormat.comma(item.twentyTwoC));
model.twentyThreeC = Convert.ToDecimal(amtFormat.comma(item.twentyThreeC));
model.silver = Convert.ToDecimal(amtFormat.comma(item.silver));
model.hallmark = Convert.ToDecimal(amtFormat.comma(item.hallmark));
model.hallmarkBuyBack = Convert.ToDecimal(amtFormat.comma(item.hallmarkBuyBack));
modelList.Add(model);
rowNo++;
}
}
dgDailyRateReport.DataSource = modelList;
}
catch (Exception x)
{
}
}
