private void btnDelete_Click(object sender, EventArgs e)
{
try
{
DEWSRMEntities db = new DEWSRMEntities();
int[] selRows = ((GridView)grdInvFixed.MainView).GetSelectedRows();
DataRowView oExpenseID = (DataRowView)(((GridView)grdInvFixed.MainView).GetRow(selRows[0]));
int nID = Convert.ToInt32(oExpenseID["ID"]);
ShareInvestmentHead oShareInvestmentHead = db.ShareInvestmentHeads.FirstOrDefault(p => p.SIHID == nID);
if (oShareInvestmentHead == null)
{
MessageBox.Show("select an item to delete", "Item not yet selected", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (MessageBox.Show("Do you want to delete the selected item?", "Delete Setup", MessageBoxButtons.YesNo,
MessageBoxIcon.Question) == DialogResult.Yes)
{
db.ShareInvestmentHeads.Attach(oShareInvestmentHead);
db.ShareInvestmentHeads.Remove(oShareInvestmentHead);
db.SaveChanges();
MessageBox.Show("Data Deleted Successfully.", "Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information);
RefreshFixedList();
}
}
catch (Exception Ex)
{
MessageBox.Show("Cannot delete item due to " + Ex.Message);
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
try
{
DEWSRMEntities db = new DEWSRMEntities();
int[] selRows = ((GridView)grdInvFixed.MainView).GetSelectedRows();
DataRowView oExpenseID = (DataRowView)(((GridView)grdInvFixed.MainView).GetRow(selRows[0]));
int nID = Convert.ToInt32(oExpenseID["ID"]);
ShareInvestmentHead oSIHead = db.ShareInvestmentHeads.FirstOrDefault(p => p.SIHID == nID);
if (oSIHead == null)
{
MessageBox.Show("select an item to edit", "Item not yet selected", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
fInvestmentHead frm = new fInvestmentHead();
frm.ItemChanged = RefreshFixedList;
frm.ShowDlg(oSIHead, false, 2);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void ShowDlg(ShareInvestmentHead oShareInvestmentHead, bool IsNew, int nParaentID)
{
_IsNew = IsNew;
_ShareInvestmentHead = oShareInvestmentHead;
//PopulateInvTypeCbo();
_ParentId = nParaentID;
RefreshValue();
this.ShowDialog();
}
private void RefreshListLiabilityPay()
{
try
{
using (DEWSRMEntities db = new DEWSRMEntities())
{
//var _ShareInvesntments = db.ShareInvestments.Where(a => a.TransactionType == (int)EnumTransactionType.Pay);
//var _InvesntmentHeads = db.ShareInvestmentHeads.Where(a => a.Type == (int)EnumInvestmentType.Loan || a.Type == (int)EnumInvestmentType.FromOwner || a.Type == (int)EnumInvestmentType.Others);
decimal LPAmt = 0;
var _ShareInvesntments = db.ShareInvestments.Where(a => a.TransactionType == (int)EnumTransactionType.Pay &&
a.ShareInvestmentHead.ParentId == (int)EnumParentType.Liability);
var _InvesntmentHeads = db.ShareInvestmentHeads.Where(a => a.ParentId == (int)EnumParentType.Liability);
ShareInvestmentHead oSIHead = null;
DataTable dt = new DataTable();
DataRow dr = null;
int Count = 0;
dt.Columns.Add("ID");
dt.Columns.Add("InvHead");
dt.Columns.Add("Purpose");
dt.Columns.Add("Amount");
dt.Columns.Add("EntryDate");
if (_ShareInvesntments != null)
{
Count = 0;
foreach (ShareInvestment grd in _ShareInvesntments)
{
oSIHead = _InvesntmentHeads.FirstOrDefault(s => s.SIHID == grd.SIHID);
if (oSIHead != null)//&& oSIHead.Type!=(int)EnumInvestmentType.FixedAsset
{
dr = dt.NewRow();
dr["ID"] = grd.SIID;
dr["EntryDate"] = grd.EntryDate.ToString("dd MMM yyyy");
dr["InvHead"] = oSIHead.Name;
dr["Purpose"] = grd.Purpose;
dr["Amount"] = grd.Amount;
//dr["Type"] = "";//((EnumInvestmentType)Enum.Parse(typeof(EnumInvestmentType), grd.ShareInvestmentHead.Type.ToString())).ToString(); ;
dt.Rows.Add(dr);
Count++;
LPAmt = LPAmt + grd.Amount;
}
}
grdLiabilitiesPay.DataSource = dt;
label3.Text = "Total :" + Count.ToString();
lblLP.Text = "T.Amount :" + LPAmt.ToString();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void RefreshFAssetList()
{
try
{
using (DEWSRMEntities db = new DEWSRMEntities())
{
decimal FixedAssetAmt = 0;
//var _ShareInvesntments = db.ShareInvestments.Where(a => a.ShareInvestmentHead.Type == (int)EnumInvestmentType.FixedAsset);
//var _InvesntmentHeads = db.ShareInvestmentHeads.Where(a => a.Type == (int)EnumInvestmentType.FixedAsset|| a.Type == (int)EnumInvestmentType.FixedAsset);
var _ShareInvesntments = db.ShareInvestments.Where(a => a.ShareInvestmentHead.ParentId == (int)EnumParentType.FixedAsset);
var _InvesntmentHeads = db.ShareInvestmentHeads.Where(a => a.ParentId == (int)EnumParentType.FixedAsset);
ShareInvestmentHead oSIHead = null;
DataTable dt = new DataTable();
DataRow dr = null;
dt.Columns.Add("ID");
dt.Columns.Add("InvHead");
dt.Columns.Add("Purpose");
dt.Columns.Add("Amount");
dt.Columns.Add("EntryDate");
if (_ShareInvesntments != null)
{
foreach (ShareInvestment grd in _ShareInvesntments)
{
oSIHead = _InvesntmentHeads.FirstOrDefault(s => s.SIHID == grd.SIHID);
dr = dt.NewRow();
dr["ID"] = grd.SIID;
dr["EntryDate"] = grd.EntryDate.ToString("dd MMM yyyy");
dr["InvHead"] = oSIHead.Name;
dr["Purpose"] = grd.Purpose;
dr["Amount"] = grd.Amount;
//dr["Type"] = "Fixed Asset";//((EnumInvestmentType)Enum.Parse(typeof(EnumInvestmentType), grd.ShareInvestmentHead.Type.ToString())).ToString(); ;
dt.Rows.Add(dr);
FixedAssetAmt = FixedAssetAmt + grd.Amount;
}
grdInvestment.DataSource = dt;
lblTotal.Text = "Total :" + _ShareInvesntments.Count().ToString();
lblFA.Text = "T.Amount :" + FixedAssetAmt.ToString();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
bool isNew = false;
if (!IsValid())
{
return;
}
using (DEWSRMEntities db = new DEWSRMEntities())
{
if (_ShareInvestmentHead.SIHID <= 0)
{
#region Validation Check
if (txtName.Text.Length > 0)
{
ShareInvestmentHead oShareInvestmentHead = (ShareInvestmentHead)(db.ShareInvestmentHeads.FirstOrDefault(o => o.Name.Trim().ToUpper() == txtName.Text.Trim().ToUpper()));
if (oShareInvestmentHead != null)
{
MessageBox.Show("Investment name already Exists.", "Duplicate Invest Item.", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtName.Focus();
return;
}
}
#endregion
RefreshObject();
_ShareInvestmentHead.SIHID = db.ShareInvestmentHeads.Count() > 0 ? db.ShareInvestmentHeads.Max(obj => obj.SIHID) + 1 : 1;
db.ShareInvestmentHeads.Add(_ShareInvestmentHead);
isNew = true;
}
else
{
_ShareInvestmentHead = db.ShareInvestmentHeads.FirstOrDefault(obj => obj.SIHID == _ShareInvestmentHead.SIHID);
RefreshObject();
}
db.SaveChanges();
MessageBox.Show("Data saved successfully.", "Save Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (!isNew)
{
if (ItemChanged != null)
{
ItemChanged();
}
this.Close();
}
else
{
if (ItemChanged != null)
{
ItemChanged();
}
_ShareInvestmentHead = new ShareInvestmentHead();
RefreshValue();
txtCode.Text = GenerateInvestCode();
}
}
}
catch (Exception ex)
{
if (ex.InnerException == null)
{
MessageBox.Show(ex.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show(ex.InnerException.Message, "Failed to save", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void grdItems_MouseDoubleClick(object sender, MouseEventArgs e)
{
try
{
ShareInvestmentHead oShareHead = null;
int[] selRows = ((GridView)grdItems.MainView).GetSelectedRows();
DataRowView oID = (DataRowView)(((GridView)grdItems.MainView).GetRow(selRows[0]));
int nID = Convert.ToInt32(oID["ID"]);
if (nID > 0)
{
if (_ObjectName == "FAsset")
{
this.Text = "Fixed Asset";
oShareHead = db.ShareInvestmentHeads.FirstOrDefault(p => p.SIHID == nID);
_ctl.SelectedID = oShareHead.SIHID;
_ctl.Code = oShareHead.Code;
_ctl.Name = oShareHead.Name;
}
else if (_ObjectName == "CAsset")
{
this.Text = "Current Asset";
oShareHead = db.ShareInvestmentHeads.FirstOrDefault(p => p.SIHID == nID);
_ctl.SelectedID = oShareHead.SIHID;
_ctl.Code = oShareHead.Code;
_ctl.Name = oShareHead.Name;
}
else if (_ObjectName == "LReceive")
{
this.Text = "Liability Receive";
oShareHead = db.ShareInvestmentHeads.FirstOrDefault(p => p.SIHID == nID);
_ctl.SelectedID = oShareHead.SIHID;
_ctl.Code = oShareHead.Code;
_ctl.Name = oShareHead.Name;
}
else if (_ObjectName == "LPay")
{
this.Text = "Liability Pay";
oShareHead = db.ShareInvestmentHeads.FirstOrDefault(p => p.SIHID == nID);
_ctl.SelectedID = oShareHead.SIHID;
_ctl.Code = oShareHead.Code;
_ctl.Name = oShareHead.Name;
}
else if (_ObjectName == "Liability")
{
this.Text = "Liability";
oShareHead = db.ShareInvestmentHeads.FirstOrDefault(p => p.SIHID == nID);
_ctl.SelectedID = oShareHead.SIHID;
_ctl.Code = oShareHead.Code;
_ctl.Name = oShareHead.Name;
}
}
if (ItemChanged != null)
{
ItemChanged();
}
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Refresh()
{
try
{
using (DEWSRMEntities db = new DEWSRMEntities())
{
if (ObjectName == "Company")
{
_Supplier = db.Suppliers.FirstOrDefault(o => o.SupplierID == SelectedID);
if (_Supplier == null)
{
_CID = 0;
}
else
{
_CID = _Supplier.SupplierID;
}
if (_Supplier != null)
{
txtCode.Text = _Supplier.Code;
txtName.Text = _Supplier.OwnerName;//_Supplier.Name;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "Customer")
{
_Customer = db.Customers.FirstOrDefault(o => o.CustomerID == SelectedID);
if (_Customer != null)
{
_CID = _Customer.CustomerID;
txtCode.Text = _Customer.Code;
txtName.Text = _Customer.Name;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "Model")
{
_Model = db.Models.FirstOrDefault(o => o.ModelID == SelectedID);
if (_Model != null)
{
txtCode.Text = _Model.Code;
txtName.Text = _Model.Description;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "ReturnProduct")
{
StockDetail oSD = db.StockDetails.FirstOrDefault(o => o.SDetailID == SelectedID);
if (oSD != null)
{
_Product = db.Products.FirstOrDefault(o => o.ProductID == oSD.Stock.ProductID);
txtCode.Text = _Product.Code;
txtName.Text = _Product.ProductName;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "Employee")
{
_Employee = db.Employees.FirstOrDefault(o => o.EmployeeID == SelectedID);
if (_Employee != null)
{
txtCode.Text = _Employee.Code;
txtName.Text = _Employee.Name;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "Product")
{
_Product = db.Products.FirstOrDefault(o => o.ProductID == SelectedID);
if (_Product != null)
{
txtCode.Text = _Product.Code;
txtName.Text = _Product.ProductName;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "OProduct")
{
_Product = db.Products.FirstOrDefault(o => o.ProductID == SelectedID);
if (_Product != null)
{
txtCode.Text = _Product.Code;
txtName.Text = _Product.ProductName;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "SPReport")
{
_Product = db.Products.FirstOrDefault(o => o.ProductID == SelectedID);
if (_Product != null)
{
txtCode.Text = _Product.Code;
txtName.Text = _Product.ProductName;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "CCompany")
{
_Supplier = db.Suppliers.FirstOrDefault(o => o.SupplierID == SelectedID);
if (_Supplier != null)
{
txtCode.Text = _Supplier.Code;
txtName.Text = _Supplier.OwnerName;//_Supplier.Name;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "IncomeOnly")
{
_ExpenseItem = db.ExpenseItems.FirstOrDefault(o => o.ExpenseItemID == SelectedID);
if (_ExpenseItem != null)
{
txtCode.Text = _ExpenseItem.Code;
txtName.Text = _ExpenseItem.Description;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "ExpenseOnly")
{
_ExpenseItem = db.ExpenseItems.FirstOrDefault(o => o.ExpenseItemID == SelectedID);
if (_ExpenseItem != null)
{
txtCode.Text = _ExpenseItem.Code;
txtName.Text = _ExpenseItem.Description;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "CCustomer")
{
_Customer = db.Customers.FirstOrDefault(o => o.CustomerID == SelectedID);
if (_Customer != null)
{
txtCode.Text = _Customer.Code;
txtName.Text = _Customer.Name;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "CreditCustomer")
{
_Customer = db.Customers.FirstOrDefault(o => o.CustomerID == SelectedID);
if (_Customer != null)
{
txtCode.Text = _Customer.Code;
txtName.Text = _Customer.Name;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "SReturn")
{
StockDetail OSD = db.StockDetails.FirstOrDefault(o => o.SDetailID == SelectedID);
if (OSD != null)
{
_Product = db.Products.FirstOrDefault(o => o.ProductID == OSD.ProductID);
}
else
{
_Product = null;
}
if (_Product != null)
{
txtCode.Text = _Product.Code;
txtName.Text = _Product.ProductName;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "PReturn")
{
StockDetail OSD = db.StockDetails.FirstOrDefault(o => o.SDetailID == SelectedID);
if (OSD != null)
{
_Product = db.Products.FirstOrDefault(o => o.ProductID == OSD.ProductID);
}
else
{
_Product = null;
}
if (_Product != null)
{
txtCode.Text = _Product.Code;
txtName.Text = _Product.ProductName;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "StockDetail")
{
StockDetail stockDetail = db.StockDetails.FirstOrDefault(o => o.SDetailID == SelectedID);
if (stockDetail != null)
{
txtName.Text = stockDetail.Product.ProductName;
txtCode.Text = stockDetail.Product.Code;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "Category")
{
_Category = db.Categorys.FirstOrDefault(o => o.CategoryID == SelectedID);
if (_Category != null)
{
txtCode.Text = _Category.Code;
txtName.Text = _Category.Description;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "BCompany")
{
_Company = db.Companies.FirstOrDefault(o => o.CompanyID == SelectedID);
if (_Company != null)
{
txtCode.Text = _Company.Code;
txtName.Text = _Company.Description;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "Color")
{
_Color = db.Colors.FirstOrDefault(o => o.ColorID == SelectedID);
if (_Color != null)
{
txtCode.Text = _Color.Code;
txtName.Text = _Color.Description;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "FAsset")
{
_ShareInvestment = db.ShareInvestmentHeads.FirstOrDefault(o => o.SIHID == SelectedID);
if (_ShareInvestment != null)
{
txtCode.Text = _ShareInvestment.Code;
txtName.Text = _ShareInvestment.Name;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "CAsset")
{
_ShareInvestment = db.ShareInvestmentHeads.FirstOrDefault(o => o.SIHID == SelectedID);
if (_ShareInvestment != null)
{
txtCode.Text = _ShareInvestment.Code;
txtName.Text = _ShareInvestment.Name;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "LReceive")
{
_ShareInvestment = db.ShareInvestmentHeads.FirstOrDefault(o => o.SIHID == SelectedID);
if (_ShareInvestment != null)
{
txtCode.Text = _ShareInvestment.Code;
txtName.Text = _ShareInvestment.Name;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "LPay")
{
_ShareInvestment = db.ShareInvestmentHeads.FirstOrDefault(o => o.SIHID == SelectedID);
if (_ShareInvestment != null)
{
txtCode.Text = _ShareInvestment.Code;
txtName.Text = _ShareInvestment.Name;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "Liability")
{
_ShareInvestment = db.ShareInvestmentHeads.FirstOrDefault(o => o.SIHID == SelectedID);
if (_ShareInvestment != null)
{
txtCode.Text = _ShareInvestment.Code;
txtName.Text = _ShareInvestment.Name;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "Expense")
{
_ExpenseItem = db.ExpenseItems.FirstOrDefault(o => o.ExpenseItemID == SelectedID);
if (_ExpenseItem != null)
{
txtCode.Text = _ExpenseItem.Code;
txtName.Text = _ExpenseItem.Description;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "Godown")
{
_Godown = db.Godowns.FirstOrDefault(o => o.GodownID == SelectedID);
if (_Godown != null)
{
txtCode.Text = _Godown.GodownCode;
txtName.Text = _Godown.GodownName;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
else if (ObjectName == "MSCustomer")
{
if (_IDList == null)
{
txtCode.Text = "";
txtName.Text = "";
}
else
{
txtCode.Text = "00000";
txtName.Text = "Selected Total:" + _IDList.Count().ToString();
}
}
else if (ObjectName == "Bank")
{
_BankInfo = db.Banks.FirstOrDefault(o => o.BankID == SelectedID);
if (_BankInfo != null)
{
BankID = _BankInfo.BankID;
txtCode.Text = _BankInfo.Code;
txtName.Text = _BankInfo.BankName + "," + _BankInfo.AccountNo;
}
else
{
txtCode.Text = "";
txtName.Text = "";
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
