protected void cboGroup_SelectedIndexChanged(object sender, EventArgs e)
{
ProductSubGroupDetails clsSearchKeys = new ProductSubGroupDetails();
clsSearchKeys.ProductGroupID = long.Parse(cboGroup.SelectedItem.Value);
ProductSubGroupColumns clsProductSubGroupColumns = new ProductSubGroupColumns()
{
ColumnsNameID = true
};
ProductSubGroup clsProductSubGroup = new ProductSubGroup();
cboSubGroup.DataTextField = "ProductSubGroupName";
cboSubGroup.DataValueField = "ProductSubGroupID";
cboSubGroup.DataSource = clsProductSubGroup.ListAsDataTable(clsProductSubGroupColumns, clsSearchKeys, SortField: "ProductSubGroupName", SortOrder: System.Data.SqlClient.SortOrder.Ascending);
cboSubGroup.DataBind();
if (cboGroup.SelectedItem.Value != Constants.ZERO_STRING)
{
cboSubGroup.Items.Insert(0, new ListItem(Constants.ALL + " " + cboGroup.SelectedItem.Text, Constants.ZERO_STRING));
}
else
{
cboSubGroup.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
}
cboSubGroup.SelectedIndex = 0;
clsProductSubGroup.CommitAndDispose();
}
public ActionResult EdtiGroup()
{
var lang = FillLanguagesList();
var grouplist = ProductManager.GetProductGroupList(lang);
var grp = new SelectList(grouplist, "ProductGroupId", "GroupName");
ViewBag.MainGroup = grp;
if (RouteData.Values["id"] != null)
{
int nid = 0;
bool isnumber = int.TryParse(RouteData.Values["id"].ToString(), out nid);
if (isnumber)
{
ProductSubGroup editnews = ProductManager.GetSubGroupById(nid);
return(View(editnews));
}
else
{
return(View());
}
}
else
{
return(View());
}
}
public ActionResult Edit(int?Id)
{
FillFropDowns();
ProductSubGroup model = repo.GetProductSubGroup(Id ?? 0);
return(View(model));
}
private bool Delete()
{
bool boRetValue = false;
string stIDs = "";
foreach (DataListItem item in lstItem.Items)
{
HtmlInputCheckBox chkList = (HtmlInputCheckBox)item.FindControl("chkList");
if (chkList != null)
{
if (chkList.Checked == true)
{
stIDs += chkList.Value + ",";
boRetValue = true;
}
}
}
if (boRetValue)
{
ProductSubGroup clsProductSubGroup = new ProductSubGroup();
clsProductSubGroup.Delete(stIDs.Substring(0, stIDs.Length - 1));
clsProductSubGroup.CommitAndDispose();
}
return(boRetValue);
}
protected void imgProductSubGroupSearch_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
ProductSubGroupColumns clsProductSubGroupColumns = new ProductSubGroupColumns()
{
ColumnsNameID = true
};
ProductSubGroupDetails clsSearchKey = new ProductSubGroupDetails()
{
ProductSubGroupName = txtProductSubGroup.Text
};
ProductSubGroup clsProductSubGroup = new ProductSubGroup();
cboProductSubGroup.DataTextField = "ProductSubGroupName";
cboProductSubGroup.DataValueField = "ProductSubGroupID";
cboProductSubGroup.DataSource = clsProductSubGroup.ListAsDataTable(clsProductSubGroupColumns, clsSearchKey, SortField: "ProductSubGroupName").DefaultView;
cboProductSubGroup.DataBind();
cboProductSubGroup.SelectedIndex = 0;
cboProductSubGroup.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
if (cboProductSubGroup.Items.Count > 1 && txtProductSubGroup.Text.Trim() != string.Empty)
{
cboProductSubGroup.SelectedIndex = 1;
}
else
{
cboProductSubGroup.SelectedIndex = 0;
}
clsProductSubGroup.CommitAndDispose();
}
private void LoadOptions()
{
ProductGroup clsProductGroup = new ProductGroup();
cboGroup.DataTextField = "ProductGroupName";
cboGroup.DataValueField = "ProductGroupID";
cboGroup.DataSource = clsProductGroup.ListAsDataTable();
cboGroup.DataBind();
cboGroup.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
cboGroup.SelectedIndex = 0;
ProductSubGroupColumns clsProductSubGroupColumns = new ProductSubGroupColumns()
{
ColumnsNameID = true
};
ProductSubGroup clsSubGroup = new ProductSubGroup(clsProductGroup.Connection, clsProductGroup.Transaction);
cboSubGroup.DataTextField = "ProductSubGroupName";
cboSubGroup.DataValueField = "ProductSubGroupID";
cboSubGroup.DataSource = clsSubGroup.ListAsDataTable(clsProductSubGroupColumns, SortField: "ProductSubGroupName", SortOrder: System.Data.SqlClient.SortOrder.Ascending);
cboSubGroup.DataBind();
cboSubGroup.Items.Insert(0, new ListItem(Constants.ALL, Constants.ZERO_STRING));
cboSubGroup.SelectedIndex = 0;
clsProductGroup.CommitAndDispose();
}
private void LoadOptions()
{
DataClass clsDataClass = new DataClass();
lblSubGroupID.Text = Common.Decrypt((string)Request.QueryString["subgroupid"], Session.SessionID);
ProductSubGroupVariations clsProductSubGroupVariation = new ProductSubGroupVariations();
lstItem.DataSource = clsDataClass.DataReaderToDataTable(clsProductSubGroupVariation.List(Convert.ToInt32(lblSubGroupID.Text), "VariationType", SortOption.Ascending)).DefaultView;
lstItem.DataBind();
clsProductSubGroupVariation.CommitAndDispose();
Data.Unit clsUnit = new Data.Unit();
cboUnit.DataTextField = "UnitName";
cboUnit.DataValueField = "UnitID";
cboUnit.DataSource = clsUnit.ListAsDataTable(SortField: "UnitName").DefaultView;
cboUnit.DataBind();
cboUnit.SelectedIndex = cboUnit.Items.Count - 1;
clsUnit.CommitAndDispose();
ProductSubGroup clsProductSubGroup = new ProductSubGroup();
ProductSubGroupDetails clsProductSubGroupDetails = clsProductSubGroup.Details(Convert.ToInt32(lblSubGroupID.Text));
clsProductSubGroup.CommitAndDispose();
cboUnit.SelectedIndex = cboUnit.Items.IndexOf(cboUnit.Items.FindByValue(clsProductSubGroupDetails.BaseUnitID.ToString()));
txtProductPrice.Text = clsProductSubGroupDetails.Price.ToString("#,##0.#0");
txtProductPrice.Text = clsProductSubGroupDetails.Price.ToString("#,##0.#0");
txtPurchasePrice.Text = clsProductSubGroupDetails.PurchasePrice.ToString("#,##0.#0");
chkIncludeInSubtotalDiscount.Checked = clsProductSubGroupDetails.IncludeInSubtotalDiscount;
txtVAT.Text = clsProductSubGroupDetails.VAT.ToString("#,##0.#0");
txtEVAT.Text = clsProductSubGroupDetails.EVAT.ToString("#,##0.#0");
txtLocalTax.Text = clsProductSubGroupDetails.LocalTax.ToString("#,##0.#0");
}
public static bool EditProductSubGroup(int id, string name, string pageslug)
{
using (MainContext db = new MainContext())
{
try
{
ProductSubGroup record = db.ProductSubGroup.Where(d => d.ProductSubGroupId == id && d.Deleted == false).SingleOrDefault();
if (record != null)
{
record.GroupName = name;
record.PageSlug = pageslug;
record.TimeUpdated = DateTime.Now;
db.SaveChanges();
//LogtrackManager logkeeper = new LogtrackManager();
//logkeeper.LogDate = DateTime.Now;
//logkeeper.LogProcess = EnumLogType.DokumanGrup.ToString();
//logkeeper.Message = LogMessages.ProductGroupEdited;
//logkeeper.User = HttpContext.Current.User.Identity.Name;
//logkeeper.Data = record.GroupName;
//logkeeper.AddInfoLog(logger);
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
}
public static bool AddProductSubGroup(ProductSubGroup record)
{
using (MainContext db = new MainContext())
{
try
{
record.TimeCreated = DateTime.Now;
record.Deleted = false;
record.Online = true;
record.SortNumber = 9999;
db.ProductSubGroup.Add(record);
db.SaveChanges();
//LogtrackManager logkeeper = new LogtrackManager();
//logkeeper.LogDate = DateTime.Now;
//logkeeper.LogProcess = EnumLogType.DokumanGrup.ToString();
//logkeeper.Message = LogMessages.ProductGroupAdded;
//logkeeper.User = HttpContext.Current.User.Identity.Name;
//logkeeper.Data = record.GroupName;
//logkeeper.AddInfoLog(logger);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
const string defaultHeading = "Master Files";
string stHeading = defaultHeading;
const string defaultTitle = "List of Product SubGroup Variation Types";
SiteTitle.Title = defaultTitle;
const SearchCategoryID defaultSearchIndex = SearchCategoryID.ProductSubGroups;
SearchCategoryID SearchIndex = defaultSearchIndex;
HorizontalNavBar.PageNavigatorid = HorizontalNavID.MasterFiles;
if (Request.QueryString["task"] != null)
{
ProductSubGroup clsProductSubGroup = new ProductSubGroup();
ProductSubGroupDetails clsDetails = new ProductSubGroupDetails();
int id = Convert.ToInt32(Common.Decrypt(Request.QueryString["subgroupid"].ToString(), Session.SessionID));
clsDetails = clsProductSubGroup.Details(id);
clsProductSubGroup.CommitAndDispose();
string groupCode = " for SubGroup : " + clsDetails.ProductSubGroupName;
string task = Common.Decrypt(Request.QueryString["task"].ToString(), Session.SessionID);
switch (task)
{
case "add":
stHeading = "Register New Variation";
SearchIndex = SearchCategoryID.ProductVariations;
ctrlInsert.Visible = true;
break;
case "edit":
stHeading = "Modify Variation";
SearchIndex = SearchCategoryID.ProductVariations;
ctrlUpdate.Visible = true;
break;
case "list":
stHeading = "Variations List";
SearchIndex = SearchCategoryID.ProductVariations;
ctrlList.Visible = true;
break;
default:
break;
}
LargeHeading.Text = stHeading + groupCode;
RightBodySectionSearch.SearchIDSelectedItem = SearchIndex;
}
}
protected void cboProductSubGroup_SelectedIndexChanged(object sender, System.EventArgs e)
{
if (cboProductSubGroup.Items.Count != 0)
{
ProductSubGroup clsProductSubGroup = new ProductSubGroup();
ProductSubGroupDetails clsProductSubGroupDetails = clsProductSubGroup.Details(Convert.ToInt32(cboProductSubGroup.SelectedItem.Value));
cboProductUnit.SelectedIndex = cboProductUnit.Items.IndexOf(cboProductUnit.Items.FindByValue(clsProductSubGroupDetails.BaseUnitID.ToString()));
txtProductPrice.Text = clsProductSubGroupDetails.Price.ToString("#,##0.#0");
clsProductSubGroup.CommitAndDispose();
}
}
public int Edit(ProductSubGroup model)
{
using (IDbConnection connection = OpenConnection(sqlConnString))
{
string query = @"UPDATE ProductSubGroup SET
prdSGCode=@prdSGCode
,prdSGName=@prdSGName
,prdMGId=@prdMGId
,gstId=@gstId
,prdSGRemarks=@prdSGRemarks
WHERE prdSGId=@prdSGId";
int rowsAffected = connection.Execute(query, model);
return(rowsAffected);
}
}
private void SaveRecord()
{
ProductSubGroupDetails clsDetails = new ProductSubGroupDetails();
clsDetails.ProductSubGroupID = Convert.ToInt16(lblProductSubGroupID.Text);
clsDetails.ProductGroupID = Convert.ToInt32(cboGroup.SelectedItem.Value);
clsDetails.ProductSubGroupCode = txtProductSubGroupCode.Text;
clsDetails.ProductSubGroupName = txtProductSubGroupName.Text;
clsDetails.BaseUnitID = Convert.ToInt32(cboProductSubGroupUnit.SelectedItem.Value);
clsDetails.Price = Convert.ToDecimal(txtProductPrice.Text);
clsDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text);
clsDetails.IncludeInSubtotalDiscount = chkIncludeInSubtotalDiscount.Checked;
clsDetails.VAT = Convert.ToDecimal(txtVAT.Text);
clsDetails.EVAT = Convert.ToDecimal(txtEVAT.Text);
clsDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text);
clsDetails.SequenceNo = Int32.Parse(txtSequenceNo.Text);
clsDetails.ImagePath = lblImagePath.Text;
string strfile = "";
string strfolder = "/RetailPlus/temp/uploaded/subgroupimages/";
for (int i = 0; i < Request.Files.Count; i++)
{
HttpPostedFile pfile = Request.Files[i];
if (pfile.ContentLength > 0)
{
strfile = Server.MapPath(strfolder + System.IO.Path.GetFileName(pfile.FileName));
if (!System.IO.Directory.Exists(Server.MapPath(strfolder)))
{
System.IO.Directory.CreateDirectory(Server.MapPath(strfolder));
}
if (System.IO.File.Exists(strfile))
{
System.IO.File.Delete(strfile);
}
pfile.SaveAs(strfile);
clsDetails.ImagePath = pfile.FileName;
}
}
ProductSubGroup clsProductSubGroup = new ProductSubGroup();
clsProductSubGroup.Update(clsDetails);
clsProductSubGroup.CommitAndDispose();
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
if (Visible)
{
Branch clsBranch = new Branch();
cboBranch.DataTextField = "BranchCode";
cboBranch.DataValueField = "BranchID";
cboBranch.DataSource = clsBranch.ListAsDataTable().DefaultView;
cboBranch.DataBind();
cboBranch.SelectedIndex = cboBranch.Items.IndexOf(cboBranch.Items.FindByValue(Constants.BRANCH_ID_MAIN.ToString()));
mlngItemNo = 0;
ProductSubGroupColumns clsProductSubGroupColumns = new ProductSubGroupColumns()
{
ColumnsNameID = true
};
ProductSubGroupDetails clsSearchKey = new ProductSubGroupDetails()
{
ProductSubGroupName = txtProductSubGroup.Text
};
ProductSubGroup clsProductSubGroup = new ProductSubGroup(clsBranch.Connection, clsBranch.Transaction);
cboProductSubGroup.DataTextField = "ProductSubGroupName";
cboProductSubGroup.DataValueField = "ProductSubGroupID";
cboProductSubGroup.DataSource = clsProductSubGroup.ListAsDataTable(clsProductSubGroupColumns, clsSearchKey, SortField: "ProductSubGroupName").DefaultView;
cboProductSubGroup.DataBind();
cboProductSubGroup.SelectedIndex = 0;
clsBranch.CommitAndDispose();
txtClosingDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
ManageSecurity();
LoadList();
cmdZeroOutActualQuantity.Attributes.Add("onClick", "return confirm_zeroout_inventory();");
imgZeroOutActualQuantity.Attributes.Add("onClick", "return confirm_zeroout_inventory();");
cmdCopyPOSToActual.Attributes.Add("onClick", "return confirm_copypostoactual_inventory();");
imgCopyPOSToActual.Attributes.Add("onClick", "return confirm_copypostoactual_inventory();");
//cmdCloseInventory.Attributes.Add("onClick", "return confirm_close_inventory();");
//imgCloseInventory.Attributes.Add("onClick", "return confirm_close_inventory();");
}
}
}
protected void cboProductSubGroup_SelectedIndexChanged(object sender, System.EventArgs e)
{
if (cboProductSubGroup.Items.Count != 0)
{
ProductSubGroup clsProductSubGroup = new ProductSubGroup();
ProductSubGroupDetails clsProductSubGroupDetails = clsProductSubGroup.Details(Convert.ToInt32(cboProductSubGroup.SelectedItem.Value));
cboProductUnit.SelectedIndex = cboProductUnit.Items.IndexOf(cboProductUnit.Items.FindByValue(clsProductSubGroupDetails.BaseUnitID.ToString()));
txtProductPrice.Text = clsProductSubGroupDetails.Price.ToString("#,##0.#0");
txtWSPrice.Text = clsProductSubGroupDetails.Price.ToString("#,##0.#0");
txtPurchasePrice.Text = clsProductSubGroupDetails.PurchasePrice.ToString("#,##0.#0");
chkIncludeInSubtotalDiscount.Checked = clsProductSubGroupDetails.IncludeInSubtotalDiscount;
txtVAT.Text = clsProductSubGroupDetails.VAT.ToString("#,##0.#0");
txtEVAT.Text = clsProductSubGroupDetails.EVAT.ToString("#,##0.#0");
txtLocalTax.Text = clsProductSubGroupDetails.LocalTax.ToString("#,##0.#0");
clsProductSubGroup.CommitAndDispose();
}
}
public ActionResult Create(int productGroupId, ProductSubGroup productSubGroup, FormCollection collection)
{
var username = User.Identity.Name;
var existProductSubGroupName = db.ProductSubGroups.Where(x => x.Name == productSubGroup.Name).SingleOrDefault();
var existSAPCode = db.ProductSubGroups.Where(x => x.SAPCode == productSubGroup.SAPCode).SingleOrDefault();
var groupProductCurrentPage = collection.GetValues("currentPage");
ViewBag.ProductGroupID = productGroupId;
ViewBag.GroupProductCurrentPage = groupProductCurrentPage[0];
try
{
// TODO: Add Product Sub Group
if (existProductSubGroupName != null)
{
ViewBag.ExistProductSubGroupName = "Product sub group already exist";
return(View());
}
else if (existSAPCode != null)
{
ViewBag.ExistSAPCode = "SAP Code already exist";
return(View());
}
else
{
productSubGroup.ProductGroupID = productGroupId;
productSubGroup.Created = DateTime.Now;
productSubGroup.CreatedBy = username;
productSubGroup.LastModified = DateTime.Now;
productSubGroup.LastModifiedBy = username;
db.ProductSubGroups.Add(productSubGroup);
db.SaveChanges();
ViewBag.Message = "success";
return(View("Create"));
}
}
catch (Exception ex)
{
ViewBag.ErrorMessage = "An error occured, please check your data input and try again";
ViewBag.Exception = ex;
}
return(View("Error"));
}
public ActionResult Edit(ProductSubGroup model)
{
if (ModelState.IsValid)
{
int rowsAffected = repo.Edit(model);
if (rowsAffected > 0)
{
TempData["message"] = "Successfully Updated";
return(RedirectToAction("Index"));
}
else
{
FillFropDowns();
return(View(model));
}
}
return(View(model));
}
private void LoadRecord()
{
Int32 iID = Convert.ToInt32(Common.Decrypt(Request.QueryString["id"], Session.SessionID));
ProductSubGroup clsProductSubGroup = new ProductSubGroup();
ProductSubGroupDetails clsDetails = clsProductSubGroup.Details(iID);
clsProductSubGroup.CommitAndDispose();
lblProductSubGroupID.Text = clsDetails.ProductSubGroupID.ToString();
cboGroup.SelectedIndex = cboGroup.Items.IndexOf(cboGroup.Items.FindByValue(clsDetails.ProductGroupID.ToString()));
txtProductSubGroupCode.Text = clsDetails.ProductSubGroupCode;
txtProductSubGroupName.Text = clsDetails.ProductSubGroupName;
cboProductSubGroupUnit.SelectedIndex = cboProductSubGroupUnit.Items.IndexOf(cboProductSubGroupUnit.Items.FindByValue(clsDetails.BaseUnitID.ToString()));
txtProductPrice.Text = clsDetails.Price.ToString("#,##0.#0");
txtPurchasePrice.Text = clsDetails.PurchasePrice.ToString("#,##0.#0");
chkIncludeInSubtotalDiscount.Checked = clsDetails.IncludeInSubtotalDiscount;
txtVAT.Text = clsDetails.VAT.ToString("#,##0.#0");
txtEVAT.Text = clsDetails.EVAT.ToString("#,##0.#0");
txtLocalTax.Text = clsDetails.LocalTax.ToString("#,##0.#0");
}
protected void cboProductSubGroup_SelectedIndexChanged(object sender, System.EventArgs e)
{
try
{
LoadProduct();
if (cboProductSubGroup.SelectedItem.Value != Constants.ZERO_STRING)
{
ProductSubGroup clsProductSubGroup = new ProductSubGroup();
ProductSubGroupDetails clsProductSubGroupDetails = clsProductSubGroup.Details(long.Parse(cboProductSubGroup.SelectedItem.Value));
clsProductSubGroup.CommitAndDispose();
txtVAT.Text = clsProductSubGroupDetails.VAT.ToString("#,##0.#0");
txtEVAT.Text = clsProductSubGroupDetails.EVAT.ToString("#,##0.#0");
txtLocalTax.Text = clsProductSubGroupDetails.LocalTax.ToString("#,##0.#0");
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Edit(int id, ProductSubGroup productSubGroup)
{
var username = User.Identity.Name;
var productSubGroupData = db.ProductSubGroups.Find(id);
var existProductSubGroupName = db.ProductSubGroups.Where(x => x.ID != productSubGroup.ID && x.Name == productSubGroup.Name).SingleOrDefault();
var existSAPCode = db.ProductSubGroups.Where(x => x.ID != productSubGroup.ID && x.SAPCode == productSubGroup.SAPCode).SingleOrDefault();
ViewBag.ProductGroupID = Convert.ToString(productSubGroupData.ProductGroupID);
try
{
// TODO: Update Product Sub Group
if (existProductSubGroupName != null)
{
ViewBag.ExistProductSubGroupName = "Product sub group already exist";
return(View(productSubGroupData));
}
else if (existSAPCode != null)
{
ViewBag.ExistSAPCode = "SAP Code already exist";
return(View(productSubGroupData));
}
else
{
productSubGroupData.Name = productSubGroup.Name;
productSubGroupData.SAPCode = productSubGroup.SAPCode;
productSubGroupData.LastModified = DateTime.Now;
productSubGroupData.LastModifiedBy = username;
db.SaveChanges();
ViewBag.Message = "success";
return(View(productSubGroupData));
}
}
catch (Exception ex)
{
ViewBag.Exception = ex;
ViewBag.ErrorMessage = "An error occured, please check your data input and try again";
}
return(View("Error"));
}
private void SaveRecord()
{
ProductSubGroupDetails clsDetails = new ProductSubGroupDetails();
clsDetails.ProductSubGroupID = Convert.ToInt16(lblProductSubGroupID.Text);
clsDetails.ProductGroupID = Convert.ToInt32(cboGroup.SelectedItem.Value);
clsDetails.ProductSubGroupCode = txtProductSubGroupCode.Text;
clsDetails.ProductSubGroupName = txtProductSubGroupName.Text;
clsDetails.BaseUnitID = Convert.ToInt32(cboProductSubGroupUnit.SelectedItem.Value);
clsDetails.Price = Convert.ToDecimal(txtProductPrice.Text);
clsDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text);
clsDetails.IncludeInSubtotalDiscount = chkIncludeInSubtotalDiscount.Checked;
clsDetails.VAT = Convert.ToDecimal(txtVAT.Text);
clsDetails.EVAT = Convert.ToDecimal(txtEVAT.Text);
clsDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text);
ProductSubGroup clsProductSubGroup = new ProductSubGroup();
clsProductSubGroup.Update(clsDetails);
clsProductSubGroup.CommitAndDispose();
}
protected void cboProductGroup_SelectedIndexChanged(object sender, System.EventArgs e)
{
ProductSubGroupColumns clsProductSubGroupColumns = new ProductSubGroupColumns()
{
ColumnsNameID = true
};
ProductSubGroupDetails clsSearchKey = new ProductSubGroupDetails()
{
ProductGroupID = Int64.Parse(cboProductGroup.SelectedItem.Value)
};
ProductSubGroup clsProductSubGroup = new ProductSubGroup();
cboProductSubGroup.DataTextField = "ProductSubGroupName";
cboProductSubGroup.DataValueField = "ProductSubGroupID";
cboProductSubGroup.DataSource = clsProductSubGroup.ListAsDataTable(clsProductSubGroupColumns, clsSearchKey, SortField: "ProductSubGroupName").DefaultView;
cboProductSubGroup.DataBind();
cboProductSubGroup.SelectedIndex = cboProductSubGroup.Items.Count - 1;
clsProductSubGroup.CommitAndDispose();
}
//[HttpPost("/api/persons")]
public async Task <IActionResult> SaveProductSubGroup([FromBody] ProductSubGroup productsubGroup)
{
try
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (_efCoreRepositoryProductGroup != null)
{
await _efCoreRepositoryProductSubGroup.Add(productsubGroup);
// await _efCoreRepositoryProduct.SaveChangesAsync();
}
return(CreatedAtAction("getAllProduct", new { id = productsubGroup.PrSubGrpCode }, productsubGroup));
}
catch (Exception ex)
{
throw;
}
}
public ActionResult EdtiGroup(ProductSubGroup model, HttpPostedFileBase uploadfile)
{
var lang = FillLanguagesList();
var grouplist = ProductManager.GetProductGroupList(lang);
var grp = new SelectList(grouplist, "ProductGroupId", "GroupName");
ViewBag.MainGroup = grp;
if (ModelState.IsValid)
{
//ProductSubGroup model = new ProductSubGroup();
// model.GroupName = txtname;
//model.Language = drplanguage;
if (uploadfile != null && uploadfile.ContentLength > 0)
{
Random random = new Random();
int rand = random.Next(1000, 99999999);
new ImageHelper(280, 240).SaveThumbnail(uploadfile, "/Content/images/productcategory/", Utility.SetPagePlug(model.GroupName) + "_" + rand + Path.GetExtension(uploadfile.FileName));
model.GroupImage = "/Content/images/productcategory/" + Utility.SetPagePlug(model.GroupName) + "_" + rand + Path.GetExtension(uploadfile.FileName);
}
if (RouteData.Values["id"] != null)
{
int nid = 0;
bool isnumber = int.TryParse(RouteData.Values["id"].ToString(), out nid);
if (isnumber)
{
model.PageSlug = Utility.SetPagePlug(model.GroupName);
model.ProductSubGroupId = nid;
ViewBag.ProcessMessage = ProductManager.EditProductSubGroup(model);
return(View(model));
}
else
{
ViewBag.ProcessMessage = false;
return(View(model));
}
}
}
return(View());
}
public static ProductSubGroup GetProductSubGroupById(int nid)
{
using (MainContext db = new MainContext())
{
try
{
ProductSubGroup record = db.ProductSubGroup.Where(d => d.ProductSubGroupId == nid).SingleOrDefault();
if (record != null)
{
return(record);
}
else
{
return(null);
}
}
catch (Exception ex)
{
return(null);
}
}
}
public int Create(ProductSubGroup model)
{
using (IDbConnection connection = OpenConnection(sqlConnString))
{
string query = @"INSERT INTO ProductSubGroup(
prdSGCode
,prdSGName
,prdMGId
,gstId
,prdSGRemarks
)
select
@prdSGCode
,@prdSGName
,@prdMGId
,@gstId
,@prdSGRemarks";
int rowsAffected = connection.Execute(query, model);
SetIdentity <int>(connection, id => model.prdSGId = id);
return(rowsAffected);
}
}
