public TrServicemasterEntity GetSingleTrServicemasterRecordById(object param) { Database db = DatabaseFactory.CreateDatabase(); string sql = "SELECT ID, ServiceName, Description FROM TR_ServiceMaster WHERE Id=@Id"; DbCommand dbCommand = db.GetSqlStringCommand(sql); db.AddInParameter(dbCommand, "Id", DbType.String, param); TrServicemasterEntity trServicemasterEntity = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { trServicemasterEntity = new TrServicemasterEntity(); if (dataReader["ID"] != DBNull.Value) { trServicemasterEntity.Id = dataReader["ID"].ToString(); } if (dataReader["ServiceName"] != DBNull.Value) { trServicemasterEntity.Servicename = dataReader["ServiceName"].ToString(); } if (dataReader["Description"] != DBNull.Value) { trServicemasterEntity.Description = dataReader["Description"].ToString(); } } } return trServicemasterEntity; }
public JsonResult AddUpdateServiceName(TrServicemasterEntity _Model) { try { if (!ModelState.IsValid) { return Json(new { Result = "ERROR", Message = "Form is not valid! Please correct it and try again." }); } bool isUpdate = false; if (_Model.Id == null) isUpdate = (bool)ExecuteDB(ERPTask.AG_SaveTrServicemasterInfo, _Model); else isUpdate = (bool)ExecuteDB(ERPTask.AG_UpdateTrServicemasterInfo, _Model); if (isUpdate) { var addedModel = _Model; return Json(new { Result = "OK", Record = addedModel }); } else return Json(new { Result = "ERROR", Message = "Information failed to save" }); } catch (Exception ex) { return Json(new { Result = "ERROR", Message = ex.Message }); } }
public bool UpdateTrServicemasterInfo(TrServicemasterEntity trServicemasterEntity, Database db, DbTransaction transaction) { string sql = "UPDATE TR_ServiceMaster SET ServiceName= @Servicename, Description= @Description WHERE Id=@Id"; DbCommand dbCommand = db.GetSqlStringCommand(sql); db.AddInParameter(dbCommand, "Id",DbType.String, trServicemasterEntity.Id); db.AddInParameter(dbCommand, "Servicename", DbType.String, trServicemasterEntity.Servicename); db.AddInParameter(dbCommand, "Description", DbType.String, trServicemasterEntity.Description); db.ExecuteNonQuery(dbCommand, transaction); return true; }
public bool SaveTrServicemasterInfo(TrServicemasterEntity trServicemasterEntity, Database db, DbTransaction transaction) { string sql = "INSERT INTO TR_ServiceMaster ( ServiceName, Description) VALUES ( @Servicename, @Description )"; DbCommand dbCommand = db.GetSqlStringCommand(sql); db.AddInParameter(dbCommand, "Servicename", DbType.String, trServicemasterEntity.Servicename); db.AddInParameter(dbCommand, "Description", DbType.String, trServicemasterEntity.Description); db.ExecuteNonQuery(dbCommand, transaction); return true; }