public ActionResult EditCategory(string Id)
{
CategoryMaster c = new CategoryMaster();
c = Commonhelper.GetCategoryById(Id);
return(View(c));
}
public JsonResult Create(CategoryMaster cat)
{
try
{
string query = @"insert into CategoryMaster (Category_Name,Category_Description,User_Id,Product_Id) values ('" + cat.CategoryName + "','" + cat.CategoryDescription + "','" + cat.Id + "','" + cat.ProductId + "')";
DataTable table = new DataTable();
string sqlDataSource = configuration.GetConnectionString("DataConnection");
SqlDataReader dataReader;
using (SqlConnection connection = new SqlConnection(sqlDataSource))
{
connection.Open();
using (SqlCommand command = new SqlCommand(query, connection))
{
dataReader = command.ExecuteReader();
table.Load(dataReader);
dataReader.Close();
connection.Close();
}
}
return(new JsonResult("Data Inserted"));
}
catch (Exception e)
{
return(new JsonResult(e.Message));
}
}
protected void rpProduct_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
var rpSubProduct = e.Item.FindControl("rpSubProduct") as Repeater;
if (rpSubProduct != null)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
CategoryMaster cat = e.Item.DataItem as CategoryMaster;
if (cat != null)
{
var subCatList = _subCategorys.Where(x => x.Category_ID == cat.CATEGORY_ID).ToList();
if (subCatList == null || subCatList.Count == 0)
{
rpSubProduct.HeaderTemplate = null;
rpSubProduct.FooterTemplate = null;
}
else
{
rpSubProduct.DataSource = subCatList;
rpSubProduct.DataBind();
}
}
}
}
}
public IHttpActionResult PutCategoryMaster(int id, CategoryMaster categoryMaster)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != categoryMaster.Id)
{
return(BadRequest());
}
db.Entry(categoryMaster).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CategoryMasterExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public virtual IList <CategoryMaster> GetCategoryBreadCrumb(CategoryMaster category, IList <CategoryMaster> allCategories = null, bool showHidden = false)
{
try
{
if (category == null)
{
throw new ArgumentNullException(nameof(category));
}
List <CategoryMaster> result = new List <CategoryMaster>();
//used to prevent circular references
List <int> alreadyProcessedCategoryIds = new List <int>();
while (category != null && //not null
category.IsActive &&
!alreadyProcessedCategoryIds.Contains(Convert.ToInt32(category.CategoryID))) //prevent circular references
{
result.Add(category);
alreadyProcessedCategoryIds.Add(Convert.ToInt32(category.CategoryID));
category = allCategories != null?allCategories.FirstOrDefault(c => c.CategoryID == category.ParentCategoryId)
: GetCategoryById(category.ParentCategoryId);
}
result.Reverse();
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public DataBaseResultSet SaveCategoryMaster <T>(T objData) where T : class, IModel, new()
{
CategoryMaster obj = objData as CategoryMaster;
string sQuery = "sprocCategoryMasterInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("CategoryCode", "CategoryCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.CategoryCode));
list.Add(SqlConnManager.GetConnParameters("ICode", "ICode", 13, GenericDataType.String, ParameterDirection.Input, obj.ICode));
list.Add(SqlConnManager.GetConnParameters("CategoryName", "CategoryName", 50, GenericDataType.String, ParameterDirection.Input, obj.CategoryName));
list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser));
list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime));
list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser));
list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime));
list.Add(SqlConnManager.GetConnParameters("LCode", "LCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.LCode));
list.Add(SqlConnManager.GetConnParameters("DLock", "DLock", 3, GenericDataType.String, ParameterDirection.Input, obj.DLock));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag));
list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null));
list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null));
return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray()));
}
public async Task <IActionResult> PostCategoryMaster([FromBody] CategoryMaster categoryMaster)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.CategoryMaster.Add(categoryMaster);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (CategoryMasterExists(categoryMaster.CategoryId))
{
return(new StatusCodeResult(StatusCodes.Status409Conflict));
}
else
{
throw;
}
}
return(CreatedAtAction("GetCategoryMaster", new { id = categoryMaster.CategoryId }, categoryMaster));
}
public async Task <IActionResult> PutCategoryMaster([FromRoute] int id, [FromBody] CategoryMaster categoryMaster)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != categoryMaster.CategoryId)
{
return(BadRequest());
}
_context.Entry(categoryMaster).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CategoryMasterExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
/// <summary>
/// used to save the category info in the database
/// </summary>
/// <param name="categoryId"></param>
/// <param name="categoryName"></param>
/// <param name="isVisible"></param>
/// <returns></returns>
public static bool SaveCategoryInfo(int categoryId, string categoryName, bool isVisible)
{
try
{
using (var nie = new NewsIndiaTVEntities())
{
var categoryMaster = nie.CategoryMasters.FirstOrDefault(m => m.ID == categoryId);
if (categoryMaster != null)
{
categoryMaster.CategoryName = categoryName;
categoryMaster.IsVisible = isVisible;
}
else
{
categoryMaster = new CategoryMaster()
{
CategoryName = categoryName,
IsVisible = isVisible,
IsActive = true
};
nie.CategoryMasters.Add(categoryMaster);
}
nie.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public long InsertUpdateCategoryDetails(CompanyBE.CategoryBE lst)
{
if (lst.CategoryId != 0)
{
var objCategory = _ObjEINS_RBMSEntities.CategoryMasters.FirstOrDefault(x => x.CategoryId == lst.CategoryId);
objCategory.CategoryName = lst.CategoryName;
objCategory.CategoryDescription = lst.CategoryDescription;
objCategory.CategoryStatus = true;
objCategory.ModifiedBy = lst.LastModifiedBy;
objCategory.ModifiedOn = DateTime.Now;
_ObjEINS_RBMSEntities.SaveChanges();
return(objCategory.CategoryId);
}
else
{
CategoryMaster _Obj = new CategoryMaster();
_Obj.CategoryName = lst.CategoryName;
_Obj.CategoryDescription = lst.CategoryDescription;
_Obj.CategoryStatus = true;
_Obj.AddedBy = lst.AddedBy;
_Obj.AddedOn = DateTime.Now;
_ObjEINS_RBMSEntities.AddToCategoryMasters(_Obj);
_ObjEINS_RBMSEntities.SaveChanges();
return(_Obj.CategoryId);
}
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
try
{
CategoryMaster cm = new CategoryMaster();
if (btnsubmit.Text == "Submit")
{
cm.CATEGORY_ID = CategoryMaster.MaxID() + 1;
cm.CATEGORY_NAME = txtcategory.Text;
cm.REMARK = txtremark.Text;
cm.Save();
grid();
ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<Script>alert('Submit Successfully....');</Script>", false);
}
else if (btnsubmit.Text == "Update")
{
cm = CategoryMaster.GetByCATEGORY_ID(int.Parse(ViewState["id"].ToString()));
cm.CATEGORY_ID = int.Parse(ViewState["id"].ToString());
cm.CATEGORY_NAME = txtcategory.Text;
cm.REMARK = txtremark.Text;
cm.Save();
grid();
ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<Script>alert('Update Successfully...');</Script>", false);
}
ClearInputs(Page.Controls);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert(error);</script>", false);
}
}
public ActionResult AddCategory(CategoryMaster U)
{
if (ModelState.IsValid)
{
if (TempData["IsEdit"] != null && TempData["IsEdit"] == "1")
{
U.CategoryID = Convert.ToInt32(TempData["Id"].ToString());
repository.Update(U);
repository.Save();
TempData["Message"] = "Record Update Succesfully";
TempData["IsEdit"] = "0";
}
else
{
repository.Insert(U);
repository.Save();
TempData["Message"] = "Record Save Succesfully";
TempData["IsEdit"] = "0";
}
}
else
{
TempData["Message"] = "All fields are required with *";
}
ViewBag.userdetails = repository.GetAll();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
CategoryMaster categoryMaster = uow.CategoryRepository.GetByID(id);
uow.CategoryRepository.Delete(categoryMaster);
uow.Save();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
CategoryMaster categoryMaster = db.CategoryMasters.Find(id);
db.CategoryMasters.Remove(categoryMaster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void GetListCategoryMaster <T>(T objFilter, ref List <T> listData) where T : class, IModel, new()
{
string sQuery = "GetListCategoryMaster";
CategoryMaster objData = objFilter as CategoryMaster;
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("CategoryCode", "CategoryCode", 8, GenericDataType.Long, ParameterDirection.Input, objData.CategoryCode));
SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillCategoryMasterDataFromReader, ref listData);
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
CategoryMaster categoryMaster = await db.CategoryMasters.FindAsync(id);
db.CategoryMasters.Remove(categoryMaster);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,CategoryName,CategoryOverview")] CategoryMaster categoryMaster)
{
if (ModelState.IsValid)
{
db.Entry(categoryMaster).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(categoryMaster));
}
public ActionResult Edit([Bind(Include = "ID,Name")] CategoryMaster categoryMaster)
{
if (ModelState.IsValid)
{
uow.CategoryRepository.Update(categoryMaster);
uow.Save();
return(RedirectToAction("Index"));
}
return(View(categoryMaster));
}
private void FillCategoryMasterDataFromReader <T>(DbDataReader DbReader, ref List <T> listData) where T : class, IModel, new()
{
while (DbReader.Read())
{
T obj = new T();
CategoryMaster objData = obj as CategoryMaster;
obj.FillDataFromDB(DbReader);
listData.Add(obj);
}
}
public ActionResult Create([Bind(Include = "Id,CategoryName,CategoryOverview")] CategoryMaster categoryMaster)
{
if (ModelState.IsValid)
{
db.CategoryMasters.Add(categoryMaster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(categoryMaster));
}
public async Task <ActionResult> Edit([Bind(Include = "ID,Name")] CategoryMaster categoryMaster)
{
if (ModelState.IsValid)
{
db.Entry(categoryMaster).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(categoryMaster));
}
public void Update(CategoryMaster categoryMaster)
{
var category = testContext.CategoryMaster.Find(categoryMaster.CategoryId);
category.Cgst = categoryMaster.Cgst;
category.Igst = categoryMaster.Igst;
category.Name = categoryMaster.Name;
category.Sgst = categoryMaster.Sgst;
testContext.SaveChanges();
}
public IHttpActionResult GetCategoryMaster(int id)
{
CategoryMaster categoryMaster = db.CategoryMaster.Find(id);
if (categoryMaster == null)
{
return(NotFound());
}
return(Ok(categoryMaster));
}
public ActionResult Edit(int id)
{
CategoryMaster Editcoat = (from u in repository.GetAll()
where u.CategoryID == id
select u).FirstOrDefault();
TempData["Id"] = id;
ViewBag.userdetails = repository.GetAll();
TempData["IsEdit"] = "1";
return(View("Index", Editcoat));
}
public ActionResult DeleteConfirmed(int id)
{
if (Session["admin"] == null)
{
return(RedirectToAction("Index", "adminLogin"));
}
CategoryMaster categoryMaster = db.CategoryMasters.Find(id);
db.CategoryMasters.Remove(categoryMaster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Create([Bind(Include = "ID,Name")] CategoryMaster categoryMaster)
{
if (ModelState.IsValid)
{
db.CategoryMasters.Add(categoryMaster);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(categoryMaster));
}
public async Task <IActionResult> PostCategoryMaster([FromBody] CategoryMaster categoryMaster)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.CategoryMaster.Add(categoryMaster);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetCategoryMaster", new { id = categoryMaster.CategoryId }, categoryMaster));
}
public void InsertCategory(CategoryMaster category)
{
try
{
context.Category.Add(category);
context.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public IHttpActionResult PostCategoryMaster(CategoryMaster categoryMaster)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.CategoryMaster.Add(categoryMaster);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = categoryMaster.Id }, categoryMaster));
}
public void UpdateCategory(CategoryMaster category)
{
try
{
context.Update(category);
context.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}