public dtoResult Save(dtoProduct objProduct) { dtoResult objResult = new dtoResult(); try { if (objProduct == null) throw new Exception("Please provide valid Product details."); objProduct.productCode = ("" + objProduct.productCode).Trim(); if (objProduct.productCode == string.Empty) throw new Exception("Please provide valid Product Code."); if (objProduct.productId == 0) { if (objProduct.createdBy < 1) throw new Exception("Please provide valid User ID."); objResult = repo.Insert(objProduct); } else { if (objProduct.modifiedBy < 1) throw new Exception("Please provide valid User ID."); objResult = repo.Update(objProduct); } } catch (Exception ex) { objResult.isSuccessful = false; objResult.errorMsg = ex.Message; } return objResult; }
public dtoResult Update(dtoProduct product) { return repo.Update(product); }
public dtoResult InLineUpdate(dtoProduct product) { return repo.InLineUpdate(product); }
public dtoResult Insert(dtoProduct product) { return repo.Insert(product); }
public dtoResult Update(dtoProduct t) { dtoResult objResult = new dtoResult(); List<object> parameterList = new List<object>(); object[] parameters1 = null; try { string sQuery = string.Format(@"UPDATE tbl_product SET categoryId = @P0 , productCode = @P1 , productDescription=@P2 , UOM=@P3 , unitPrice=@P4 , reorderLevel=@P5 , modifiedBy=@P6 , dateLastModified=GETDATE() , beginning=@P8 , incoming=@P9 , outgoing=@P10 , ending =@P11 WHERE productId=@P7"); parameterList.Add(t.categoryId); parameterList.Add(t.productCode); parameterList.Add(t.productDescription); parameterList.Add(t.UOM); parameterList.Add(t.unitPrice); parameterList.Add(t.reorderLevel); parameterList.Add(t.modifiedBy); parameterList.Add(t.productId); parameterList.Add(t.beginning); parameterList.Add(t.incoming); parameterList.Add(t.outgoing); parameterList.Add(t.beginning + t.incoming - t.outgoing); parameters1 = parameterList.ToArray(); DBContext.Database.ExecuteSqlCommand(sQuery, parameters1); objResult.isSuccessful = true; } catch (Exception ex) { objResult.isSuccessful = false; objResult.errorMsg = ex.Message; } parameterList = null; parameters1 = null; return objResult; }
public dtoResult SoftDelete(dtoProduct t) { throw new NotImplementedException(); }
public dtoResult Insert(dtoProduct t) { dtoResult objResult = new dtoResult(); List<object> parameterList = new List<object>(); object[] parameters1 = null; try { string sQuery = string.Format(@"INSERT INTO tbl_product(categoryId , productCode , productDescription , UOM , unitPrice , reorderLevel , branchId , createdBy , dateCreated , beginning , incoming , outgoing , ending) VALUES(@P0, @P1, @P2, @P3, @P4, @P5, @P6, @P7, GETDATE(), @P8, @P9, @P10, @P11)"); parameterList.Add(t.categoryId); parameterList.Add(t.productCode); parameterList.Add(t.productDescription); parameterList.Add(t.UOM); parameterList.Add(t.unitPrice); parameterList.Add(t.reorderLevel); parameterList.Add(t.branchId); parameterList.Add(t.createdBy); parameterList.Add(t.beginning); parameterList.Add(t.incoming); parameterList.Add(t.outgoing); parameterList.Add(t.beginning + t.incoming - t.outgoing); parameters1 = parameterList.ToArray(); DBContext.Database.ExecuteSqlCommand(sQuery, parameters1); objResult.isSuccessful = true; } catch (Exception ex) { objResult.isSuccessful = false; objResult.errorMsg = ex.Message; } parameterList = null; parameters1 = null; return objResult; }
public dtoResult InLineUpdate(dtoProduct t) { dtoResult objResult = new dtoResult(); List<object> parameterList = new List<object>(); object[] parameters1 = null; try { string sQuery = string.Format(@"UPDATE tbl_product SET modifiedBy=@P0 , dateLastModified=GETDATE() , beginning=@P1 , incoming=@P2 , outgoing=@P3 , ending =@P4 WHERE productId=@P5"); parameterList.Add(t.modifiedBy); parameterList.Add(t.beginning); parameterList.Add(t.incoming); parameterList.Add(t.outgoing); parameterList.Add(t.beginning + t.incoming - t.outgoing); parameterList.Add(t.productId); parameters1 = parameterList.ToArray(); DBContext.Database.ExecuteSqlCommand(sQuery, parameters1); objResult.isSuccessful = true; } catch (Exception ex) { objResult.isSuccessful = false; objResult.errorMsg = ex.Message; } return objResult; }
public dtoProduct Get(dtoProduct t) { throw new NotImplementedException(); }