public int InsertOperationName(EntityOperationMaster entOpera) { try { tblOperationMaster obj = new tblOperationMaster() { OperationCategoryId = entOpera.OperationCategoryId, OperationName = entOpera.OperationName, Price = entOpera.Price }; objData.tblOperationMasters.InsertOnSubmit(obj); objData.SubmitChanges(); return(1); } catch (Exception ex) { throw ex; } }
public int Update(EntityOperationMaster entOpera) { try { tblOperationMaster test = (from tbl in objData.tblOperationMasters where tbl.IsDelete == false && tbl.OperationId == entOpera.OperationId select tbl).FirstOrDefault(); test.OperationId = entOpera.OperationId; test.OperationName = entOpera.OperationName; test.OperationCategoryId = entOpera.OperationCategoryId; test.Price = entOpera.Price; objData.SubmitChanges(); return(1); } catch (Exception ex) { throw ex; } }
public bool IsRecordExists(string OperationName) { bool flag1 = false; try { tblOperationMaster objOpera = (from tbl in objData.tblOperationMasters where tbl.OperationName.ToUpper().ToString().Trim().Equals(OperationName.ToUpper().ToString().Trim()) select tbl).FirstOrDefault(); if (objOpera != null) { flag1 = true; } else { flag1 = false; } } catch (Exception ex) { throw ex; } return(flag1); }