void comboBoxBind()
{
try
{
_entities = new MicroAccountsEntities1();
var data = _entities.tbl_CategoryMaster;
List <CategoryMasterVM> modellist = new List <CategoryMasterVM>();
CategoryMasterVM model = new CategoryMasterVM();
model.cId = -1;
model.cName = "--Select--";
modellist.Add(model);
foreach (var item in data)
{
model = new CategoryMasterVM();
model.cId = item.cId;
model.cName = item.cName;
modellist.Add(model);
}
cmbItemCategory.DataSource = modellist.ToList();
cmbItemCategory.DisplayMember = "cName";
cmbItemCategory.ValueMember = "cId";
}
catch (Exception x)
{
}
}
private void StockInventoryDetails_Load(object sender, EventArgs e)
{
dataGridBind();
itemNameAutoComplete();
cmbKarat.SelectedIndex = 0;
_entities = new MicroAccountsEntities1();
var data = _entities.tbl_CategoryMaster.ToList();
List <CategoryMasterVM> catList = new List <CategoryMasterVM>();
CategoryMasterVM model = new CategoryMasterVM();
model.cName = "--Select--";
model.cId = -1;
catList.Add(model);
foreach (var item in data)
{
model = new CategoryMasterVM();
model.cId = item.cId;
model.cName = item.cName;
catList.Add(model);
}
cmbCategory.DataSource = catList;
cmbCategory.DisplayMember = "cName";
cmbCategory.ValueMember = "cId";
}
public string InsertEntity(CategoryMasterVM entity)
{
var result = ConvertSourceToDest <CategoryMasterVM, Category> .ConvertSourceToDestination(entity);
dB_SPADevelopementEntities.Categories.Add(result);
dB_SPADevelopementEntities.SaveChanges();
return("Category created successfully");
}
public string UpdateEntity(CategoryMasterVM entity)
{
var result = ConvertSourceToDest <CategoryMasterVM, Category> .ConvertSourceToDestination(entity);
result.UpdatedBy = entity.CreatedBy;
result.UpdatedDate = DateTime.Now.Date;
dB_SPADevelopementEntities.Entry(result).State = System.Data.Entity.EntityState.Modified;
dB_SPADevelopementEntities.SaveChanges();
return("Category updated successfully");
}
public ActionResult CreateCategory(CategoryMasterVM categoryMasterVM)
{
categoryMasterVM.IsActive = 1;
int id = Request.QueryString["id"] != null?Convert.ToInt32(Request.QueryString["id"]) : 0;
if (id == 0)
{
_categoryMasterRepossitory.InsertEntity(categoryMasterVM);
}
else
{
categoryMasterVM.Id = Convert.ToInt32(id);
_categoryMasterRepossitory.UpdateEntity(categoryMasterVM);
}
return(View());
}
private void txtCategoryName_KeyUp(object sender, KeyEventArgs e)
{
try
{
dtCategoryList.AutoGenerateColumns = false;
int rowNo = 1;
_entities = new MicroAccountsEntities1();
List <CategoryMasterVM> modelList = new List <CategoryMasterVM>();
List <tbl_CategoryMaster> categoryData;
if (txtCategoryName.Text == "")
{
categoryData = _entities.tbl_CategoryMaster.ToList();
}
else
{
categoryData = _entities.tbl_CategoryMaster.Where(x => x.cName.Contains(txtCategoryName.Text)).ToList();
}
if (categoryData.Count != 0)
{
foreach (var item in categoryData)
{
CategoryMasterVM model = new CategoryMasterVM();
model.rowNo = rowNo;
model.cId = item.cId;
model.cName = item.cName;
model.prefix = item.prefix;
model.createdDate = Convert.ToDateTime(item.createdDate).ToString("dd-MM-yyyy hh:mm tt");
model.updatedDate = Convert.ToDateTime(item.updatedDate).ToString("dd-MM-yyyy hh:mm tt");
modelList.Add(model);
rowNo++;
}
dtCategoryList.DataSource = modelList;
lblTotalRows.Text = modelList.Count.ToString();
}
}
catch (Exception x)
{
}
}
void dataGridBind()
{
dtCategoryList.AutoGenerateColumns = false;
int rowNo = 1;
_entities = new MicroAccountsEntities1();
List <CategoryMasterVM> modelList = new List <CategoryMasterVM>();
var categoryData = _entities.tbl_CategoryMaster.ToList();
foreach (var item in categoryData)
{
CategoryMasterVM model = new CategoryMasterVM();
model.rowNo = rowNo;
model.cId = item.cId;
model.cName = item.cName;
model.prefix = item.prefix;
model.createdDate = Convert.ToDateTime(item.createdDate).ToString("dd-MM-yyyy hh:mm tt");
if (item.updatedDate == null)
{
model.updatedDate = "--";
}
else
{
model.updatedDate = Convert.ToDateTime(item.updatedDate).ToString("dd-MM-yyyy hh:mm tt");
}
modelList.Add(model);
rowNo++;
}
dtCategoryList.DataSource = modelList;
lblTotalRows.Text = modelList.Count.ToString();
}
