private void ShowAssetInfoByAssetId(int AssetId)
{
try
{
DataTable dtAssetInfo = new DataTable();
AssetInformationBAL objAssetInfoBal = new AssetInformationBAL();
dtAssetInfo = objAssetInfoBal.GetAssetInfoByAssetId(AssetId);
if (dtAssetInfo.Rows.Count > 0)
{
ddlAssetList.Text = dtAssetInfo.Rows[0][0].ToString();
txtQuantity.Text = dtAssetInfo.Rows[0][1].ToString();
dtpPurchaseDate.Value = Convert.ToDateTime(dtAssetInfo.Rows[0][2].ToString());
dtpServicesDate.Value = Convert.ToDateTime(dtAssetInfo.Rows[0][3].ToString());
txtPurchasePrice.Text = dtAssetInfo.Rows[0][4].ToString();
txtSalvageValue.Text = dtAssetInfo.Rows[0][5].ToString();
int TotalDays = Int32.Parse(dtAssetInfo.Rows[0][6].ToString());
nudYear.Value = TotalDays / 365;
nudMonth.Value = (TotalDays % 365) / 30;
nudDays.Value = (TotalDays % 365) % 30;
lblDays.Text = TotalDays.ToString();
}
else
{
RefreshToDialogBox();
}
}
catch (Exception)
{
throw;
}
}
private void AddToAssetList()
{
try
{
if (CheeckToBlankInput())
{
AssetEntryBO objAssetBO = new AssetEntryBO();
objAssetBO.AssetName = ddlAssetList.Text;
objAssetBO.AssetQuantity = Int32.Parse(txtQuantity.Text);
objAssetBO.PurchaseDate = dtpPurchaseDate.Value;
objAssetBO.ServicesDate = dtpServicesDate.Value;
objAssetBO.PurchasePrice = float.Parse(txtPurchasePrice.Text);
objAssetBO.SalvageValue = float.Parse(txtSalvageValue.Text);
objAssetBO.LifeTime = GetTotalTotalDays(Int32.Parse(nudYear.Value.ToString()), Int32.Parse(nudMonth.Value.ToString()), Int32.Parse(nudDays.Value.ToString()));
lblDays.Text = objAssetBO.LifeTime.ToString();
AssetInformationBAL objAssetInfoBal = new AssetInformationBAL();
objAssetInfoBal.InsertIntoDataBase(objAssetBO);
MessageBox.Show("Data Secessfully Saved.", "Asset Entry", MessageBoxButtons.OK,
MessageBoxIcon.Information);
ShowAssetInfo();
RefreshToDialogBox();
ShowAssetList();
GetRecordInfo();
}
}
catch (Exception)
{
throw;
}
}
private void ShowAssetInfo()
{
try
{
DataTable dtAssetInfo = new DataTable();
AssetInformationBAL objAssetInfoBal = new AssetInformationBAL();
dtAssetInfo = objAssetInfoBal.GetAssetEntryInfo();
dgvAssetInfo.DataSource = dtAssetInfo;
dgvAssetInfo.Columns[0].Visible = false;
}
catch (Exception)
{
throw;
}
}
private void GetRecordInfo()
{
try
{
AssetInformationBAL objAssetBal = new AssetInformationBAL();
objAssetBal.GetAssetCommonInfo();
lblTotalRecord.Text = "Total Record: " + objAssetBal.TotalRecord.ToString();
lblPurposeAmount.Text = "Purchase:Tk. " + String.Format("{0:0.00}", objAssetBal.PurpasePrice);
lblSalaveAmount.Text = "Salvage Tk. " + String.Format("{0:0.00}", objAssetBal.SalvagePrice);
lblDepriciationAmount.Text = "Total Depriciation Tk. " + String.Format("{0:0.00}", objAssetBal.DepriceationValue);
}
catch (Exception)
{
throw;
}
}
private void ShowMonthlyExpenseReport(DateTime FromDate, DateTime ToDate)
{
try
{
AssetInformationBAL objAssetInfoBal = new AssetInformationBAL();
DataTable dtMonthlyExpenseInfo = new DataTable();
cr_MonthlyExpenseReport objcrMonthlyExpenseInfo = new cr_MonthlyExpenseReport();
frmReportViewer objfrmMonthlyExpenseInfo = new frmReportViewer();
RecordLevelFilteringBAL recordLevelFilteringBAL = new RecordLevelFilteringBAL();
int TempBranchId = -2;
dtMonthlyExpenseInfo = objAssetInfoBal.GetMonthlyCapexReport(FromDate, ToDate);
int branchid = Int32.Parse(dtMonthlyExpenseInfo.Rows[0][10].ToString());
int resourceId = recordLevelFilteringBAL.GetResourceID(ResourceName.Monthly_Expense_List);
int criteriaId = recordLevelFilteringBAL.GetCriteriaID(resourceId);
TempBranchId = Convert.ToInt32(recordLevelFilteringBAL.FilterBranchID(branchid.ToString(), resourceId, criteriaId));
if (TempBranchId == -1)
{
dtMonthlyExpenseInfo.Rows.Clear();
}
objcrMonthlyExpenseInfo.SetDataSource(dtMonthlyExpenseInfo);
((TextObject)objcrMonthlyExpenseInfo.ReportDefinition.Sections[2].ReportObjects["txtFromDate"]).Text = "Fom: " + dtpFromDate.Value.ToString("MM-dd-yyyy");
((TextObject)objcrMonthlyExpenseInfo.ReportDefinition.Sections[2].ReportObjects["txtToDate"]).Text = "To: " + dtpToDate.Value.ToString("MM-dd-yyyy");
GetCommonInfo();
((TextObject)objcrMonthlyExpenseInfo.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
((TextObject)objcrMonthlyExpenseInfo.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
objfrmMonthlyExpenseInfo.Text = "Monthly Expense Report";
objfrmMonthlyExpenseInfo.crvReportViewer.ReportSource = objcrMonthlyExpenseInfo;
objfrmMonthlyExpenseInfo.Show();
}
catch (Exception)
{
throw;
}
}
private void GetCurrentAssetList()
{
try
{
AssetInformationBAL objAssetInformationBal = new AssetInformationBAL();
DataTable dtCurrentAssetList = new DataTable();
frmCapexReportViewer objfrmReportViewer = new frmCapexReportViewer();
cr_CapexCurrentAssetList objcrCurrentAssetList = new cr_CapexCurrentAssetList();
dtCurrentAssetList = objAssetInformationBal.GetCurrentAssetInfo();
objcrCurrentAssetList.SetDataSource(dtCurrentAssetList);
objfrmReportViewer.crvReportView.ReportSource = objcrCurrentAssetList;
objfrmReportViewer.Text = "Current Asset List";
objfrmReportViewer.Show();
}
catch (Exception)
{
throw;
}
}
private void DeleteAssetInfo(int AssetId)
{
try
{
if (MessageBox.Show("Do you want to Delete this Asset Information", "Delete Asset Information", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
AssetInformationBAL objAssetInfoBAl = new AssetInformationBAL();
objAssetInfoBAl.DeleteAssetInfo(AssetId);
MessageBox.Show("Asset Information is Secessfully Deleted.", "", MessageBoxButtons.OK,
MessageBoxIcon.Information);
ShowAssetInfo();
GetRecordInfo();
}
}
catch (Exception)
{
throw;
}
}
private void GetCurrentAssetList()
{
try
{
AssetInformationBAL objAssetInformationBal = new AssetInformationBAL();
DataTable dtCurrentAssetList = new DataTable();
frmReportViewer objfrmReportViewer = new frmReportViewer();
cr_CurrentAssetList objcrCurrentAssetList = new cr_CurrentAssetList();
RecordLevelFilteringBAL recordLevelFilteringBAL = new RecordLevelFilteringBAL();
dtCurrentAssetList = objAssetInformationBal.GetCurrentAssetInfo();
int TempBranchId = -2;
int branchid = Int32.Parse(dtCurrentAssetList.Rows[0][8].ToString());
int resourceId = recordLevelFilteringBAL.GetResourceID(ResourceName.Current_Asset_List);
int criteriaId = recordLevelFilteringBAL.GetCriteriaID(resourceId);
TempBranchId = Convert.ToInt32(recordLevelFilteringBAL.FilterBranchID(branchid.ToString(), resourceId, criteriaId));
if (TempBranchId == -1)
{
dtCurrentAssetList.Rows.Clear();
}
objcrCurrentAssetList.SetDataSource(dtCurrentAssetList);
GetCommonInfo();
((TextObject)objcrCurrentAssetList.ReportDefinition.Sections[2].ReportObjects["txtCompanyName"]).Text = _CommpanyName;
((TextObject)objcrCurrentAssetList.ReportDefinition.Sections[2].ReportObjects["txtAddress"]).Text = "Branch Name:" + _branchName + "," + _branchAddress + ". Phone:" + _branchContactNumber;
objfrmReportViewer.crvReportViewer.ReportSource = objcrCurrentAssetList;
objfrmReportViewer.crvReportViewer.DisplayGroupTree = false;
objfrmReportViewer.Text = "Current Asset List";
objfrmReportViewer.Show();
}
catch (Exception)
{
throw;
}
}
private void ShowAssetList()
{
try
{
DataTable dtAssetList = new DataTable();
AssetInformationBAL objAssetBAL = new AssetInformationBAL();
dtAssetList = objAssetBAL.GetAssetList();
if (dtAssetList.Rows.Count > 0)
{
ddlAssetList.DataSource = dtAssetList;
ddlAssetList.DisplayMember = "AssetName";
}
else
{
ddlAssetList.Items.Clear();
}
}
catch
{
}
}
private void ShowMonthlyExpenseReport(DateTime FromDate, DateTime ToDate)
{
try
{
AssetInformationBAL objAssetInfoBal = new AssetInformationBAL();
DataTable dtMonthlyExpenseInfo = new DataTable();
cr_CapexMonthlyExpenseReport objcrMonthlyExpenseInfo = new cr_CapexMonthlyExpenseReport();
frmCapexReportViewer objfrmMonthlyExpenseInfo = new frmCapexReportViewer();
dtMonthlyExpenseInfo = objAssetInfoBal.GetMonthlyCapexReport(FromDate, ToDate);
objcrMonthlyExpenseInfo.SetDataSource(dtMonthlyExpenseInfo);
((TextObject)objcrMonthlyExpenseInfo.ReportDefinition.Sections[2].ReportObjects["txtFromDate"]).Text = "Fom: " + dtpFromDate.Value.ToString("MM-dd-yyyy");
((TextObject)objcrMonthlyExpenseInfo.ReportDefinition.Sections[2].ReportObjects["txtToDate"]).Text = "To: " + dtpToDate.Value.ToString("MM-dd-yyyy");
objfrmMonthlyExpenseInfo.Text = "Monthly Expense Report";
objfrmMonthlyExpenseInfo.crvReportView.ReportSource = objcrMonthlyExpenseInfo;
objfrmMonthlyExpenseInfo.Show();
}
catch (Exception)
{
throw;
}
}
